Today I read the nice post of Bhuvanesh on the memory leak issue they experienced with MySQL. In fact when you read the post, you realize that MySQL was just following the parameters that were setup (the default of max_prepare_stmt_count…
We saw in the previous post that MySQL likes memory. We also saw how to perform operating system checks and some configuration changes for Swap and NUMA. Today, we will check what MySQL server can tell us about its memory…
Many of you already know how to retrieve the size of your dataset, schemas and tables in MySQL. To summarize, below are the different queries you can run: Dataset Size I the past I was using something like this :…
If you are a MySQL DBA for a long time (like me), it’s very complicated to get rid of bad habits. One of them I really need to change is the way to retrieve the list of all the running…
Performance_Schema is used most of the time to get metrics about queries and connections. But it can also provide other very useful information. So today, I will show you how you can see a list of users that didn’t connect…
As MySQL Community Manager, I am an employee of Oracle and the views expressed on this blog are my own and do not necessarily reflect the views of Oracle.
You can find articles I wrote on Oracle’s blog.