Database performance monitoring is something every DBA worth their salt should be doing on a regular basis. It should be adopted as a proactive task to help identify issues early on before they become too serious and be part of a post code deployment monitoring process. Bundled in with linux based operating systems are a heap of great tools that you can use as a DBA to … [Read more...] about 10 Database Performance Monitoring Tools You Can Get For Free
Innodb statistics are used by the query optimizer to assist it in choosing an efficient query execution plan. They are estimated values relating to each Innodb table and index. But what updates them? Let's take a look. Operations that update Innodb table statistics Typically this happens during metadata statements such as SHOW INDEX or SHOW TABLE STATUS. It also occurs … [Read more...] about When are Innodb Table Statistics Updated?
So here is a scenario, you have a number of poorly performing MySQL database queries which are consuming resources on your server. Users are complaining and you need to do something fast. Having viewed the output of SHOW FULL PROCESSLIST, you can see that they are coming from one user and have been running for a long time. You need a way to kill all MySQL processes … [Read more...] about How to Kill All MySQL Processes For a Specific User
There are a number of useful SHOW commands in MySQL. Sadly, there isn't one for mysql SHOW USERS nor is there one for mysql LIST USERS. This is a little inconsistent when you consider that there are other commands such as SHOW DATABASES, SHOW VARIABLES, SHOW TABLES, SHOW GRANTS and others. However there are ways to do it. You can get back a list of MySQL user accounts by … [Read more...] about MySQL SHOW USERS? – How to List All MySQL Users and Privileges
This post demonstrates how to list all tables for a specific MySQL database. I will use SHOW TABLES for this. First, login as user root to your MySQL instance. [sourcecode language='sql'] mysql -uroot -pYourPassword [/sourcecode] Now change to the database you want to show tables for. [sourcecode language='sql'] USE mysql; [/sourcecode] Database changed Now … [Read more...] about List Tables for a Specific Database Using MySQL SHOW TABLES