…admin_commands | 255868807 | 11893 | Why is something running an admin command constantly? This is generally a Ping command…queries in odd statuses, like “statistics“, I know something weird is going on, and I look deeper. I also look at the queries…
Post: Checking for a live database connection considered harmful
May 5, 2010 By 38 Comments
… ‘ping’ or ‘statistics‘ command at the MySQL protocol level, which will increment Com_admin_commands in SHOW GLOBAL STATUS, or a trivial query such as ‘SELECT… on Rails app where the ‘Administrator command: statistics‘ command was taking over 40% of the server’s total query time. Eliminating the useless connection…
Post: MySQL 5.6: Improvements in the Nutshell
January 27, 2013 By 16 Comments
…improvements available in MySQL 5.6 which… BY nidxcol LIMIT N – Persistent Statistics for Innodb – Improvements to …Utilities for Failover and Admin Transparency – Many new INFORMATION_SCHEMA Tables -…Query Logs – SHA256 hashing with Salt for Authentication – Use obfuscated password storage for command…
