(Roy Lyseng) In MySQL 5.7, we have enhanced the optimizer so that derived tables and views are handled more consistently.
Tag: Open Source
Multi-threaded Replication Performance in MySQL 5.7
(Vitor Oliveira) Now that MySQL 5.7 has become GA it’s a good time to highlight how much performance has improved in replication since the 5.6 era. This blog post will focus on the performance of the multi-threaded slave applier (MTS), and about it’s scalability in particular.
Inline JSON Path Expressions in MySQL 5.7
(Evgeny Potemkin) MySQL 5.7.9 has a new feature, that simplifies queries that deal with JSON data and makes more human-readable: inlined JSON path expressions. Now you can do following:
Increasing MySQL Fabric Resilience to Failures: Meet the Multi-Node Fabric
(Alfranio Correia) Redundancy is key to providing resilience to failures, and in Fabric 1.6.2 (now available on MySQL Labs), we have introduced the possibility to start multiple MySQL Fabric instances that are kept consistent through a replicated state machine.
MySQL 5.7 Versus the Address Sanitizer
(Rik Prohaska) MySQL 5.7 supports the Address Sanitizer, which checks for several memory related software errors including memory leaks. It is really nice to see support for the Address Sanitizer built into MySQL. Unfortunately, when running the mysql tests included in MySQL 5.7.9, the Address San
MySQL-Docker operations. – Part 1: Getting started with MySQL in Docker
(Giuseppe Maxia) Docker is one of the fastest growing trends in IT. It allows fast deployment of services and applications on a Linux machine (and, with some limits, on other operating systems). Compared to other methods of deploying databases, such as virtual machines or application isolation, it o
A MySQL UDF written in Go
(Daniel van Eeden) I was wondering if it is possible to write a MySQL User Defined Function (UDF) in Go. So I tried and I got a very basic UDF working.
Use MySQL and Perl to automatically find, follow and unfollow twitter users
(Tony Darnell) A friend of mine asked me how they could automatically follow and unfollow people on Twitter. But they didn’t want to follow just anyone and everyone. He had a Twitter account which they used for recruiting in a very narrow construction industry.
Slow query graphs using Performance Schema and Graphite
(Daniel Guzmán Burgos) I love graphs. They just make things easier when it comes to finding patterns. I also love visibility. Having the ability to known what is going on inside the database is priceless. How about having visibility of the slow queries execution time on a graph? Let’s do it.
pt-table-checksum & Waiting to check replicas for differences: 0% 00:00 remain
(Kedar Vaijanapurkar) I recently came across an issue where the task was to checksum databases using Percona’s pt-table-checksum. The command continued well for all the databases but when it came to specific DB, it kept on showing following error:
