lefred's blog


There Are 10 Types of People in the World....

MySQL Lock information in MySQL Shell

Last Tuesday, it was the very first session of DB AMA, Morgan Tocker made a nice presentation of MySQL Performance_Schema and illustrated it with some nice queries to get Meta et Data Locks. As those queries were not that simple to write or at least to remember, I thought it might be a good idea to add them to MySQL … Read More


MySQL Shell Plugins: InnoDB

Today, we will cover a totally different MySQL Shell plugin: InnoDB. Currently only 3 methods have been created: Those related to the Table space fragmentation, have already been covered in this recent article. Let’s discover the getAlterProgress()method. This method allows us to have an overview of the progress of some alter statements status like: stage/innodb/alter table (end) stage/innodb/alter table (flush) … Read More


MySQL Shell Plugins: check (part 2)

In the first part of this article related to the check plugin, we discovered information retrieved from the binary logs. This part, is about what Performance_Schema and SYS can provide us about the queries hitting the MySQL database. Currently, 3 methods are available: getSlowerQuery() getQueryTempDisk() getFullTableScanQuery() The method’s name should be self explaining. This is an overview of the parameters … Read More


MySQL 8.0: if I should optimize only one query on my application, which one should it be ?

Answering this question is not easy. Like always, the best response is “it depends” ! But let’s try to give you all the necessary info the provide the most accurate answer. Also, may be fixing one single query is not enough and looking for that specific statement will lead in finding multiple problematic statements. The most consuming one The first … Read More


MySQL 8.0 Memory Consumption on Small Devices

Recently, PeterZ pointed a huge difference in memory usage of MySQL 8.0 compare to MySQL 5.7. This can be an issue for small instances if the same configuration for buffers like the buffer pool are not changed. As explained in Peter’s article, this can lead to the awakening of the so feared OOM Killer ! MorganT, pointed accurately in his … Read More


I deeply value the diversity of MySQL developers, users, community and my blog readers. I cannot agree the suffering, oppression, and systemic racism the Black community faces every day. Black lives matter.
recent
categories