MySQL

Category to track posts in PlanetMySQL

Watch Out for Disk I/O Performance Issues when Running EXT4

Performance Issues When Running EXT4

Recently, at Percona Live Europe 2019, Dimitri Kravchuk from Oracle mentioned that he observed some unclear drop in performance for MySQL on an ext4 filesystem with the latest Linux kernels. I decided to check this case out on my side and found out that indeed, starting from linux kernel 4.9, there are some cases […]

Read more

Use MySQL Without a Password (and Still be Secure)

Use MySQL Without a Password

Some say that the best password is the one you don’t have to remember. That’s possible with MySQL, thanks to the auth_socket plugin and its MariaDB version unix_socket.
Neither of these plugins is new, and some words have been written about the auth_socket on this blog before, for example: how to change passwords in MySQL […]

Read more

Column Histograms on Percona Server and MySQL 8.0

MySQL Column HIstorgrams

From time to time you may have experienced that MySQL was not able to find the best execution plan for a query. You felt the query should have been faster. You felt that something didn’t work, but you didn’t realize exactly what.
Maybe some of you did tests and discovered there was a better execution […]

Read more