… | 468 | | Bytes_received | 38563413074 | 1708212 | | Bytes_sent | 216162991863 | 7796961 | | Com_admin_commands | 255868807 | 11893 | | Com_alter_db | 0 | 0 | …snip This output… out. … snip … | Com_admin_commands | 255868807 | 11893 | Why is something running an admin command constantly? This is generally a Ping command, which is useless. Something…
Post: Checking for a live database connection considered harmful
May 5, 2010 By 38 Comments
… to the ‘ping’ or ‘statistics’ command at the MySQL protocol level, which will increment Com_admin_commands in SHOW GLOBAL STATUS, or a… I saw a Ruby on Rails app where the ‘Administrator command: statistics’ command was taking over 40% of the server’s total… Item # ==== ================== ================ ====== ======== =============== # 1 0x5E796D5A4A7D1CA9 10651.0708 73.1% 120487 0.0884 ADMIN STATISTICS # 2 0x85FFF5AA78E5FF6A 1090.0772 7.5% 23621 0.0461…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… collation_connectionblogpercona.commanual collation_databaseblogpercona.commanual collation_serverblogpercona.commanual Com_admin_commandsblogpercona.commanual Com_alter_dbblogpercona.commanual Com_alter_db_upgradeblogpercona… log_short_formatblogpercona.commanual log_slave_updatesblogpercona.commanual log_slow_admin_statementsblogpercona.commanual log_slow_queriesblogpercona.commanual log_slow_slave_statementsblogpercona…
Post: XtraDB feature: save / restore buffer pool
January 20, 2010 By 20 Comments
… select * from information_schema.XTRADB_ADMIN_COMMAND /*!XTRA_LRU_DUMP*/; and to restore select * from information_schema.XTRADB_ADMIN_COMMAND /*!XTRA_LRU_RESTORE*/; it…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…_cache_use’, ’9638599′ ‘Bytes_received’, ’2671219831′ ‘Bytes_sent’, ’2416986544′ ‘Com_admin_commands‘, ’76′ ‘Com_alter_db’, ’0′ ‘Com_alter_table’, ’7′ ‘Com…_errors’, ’0′ ‘Delayed_insert_threads’, ’0′ ‘Delayed_writes’, ’0′ ‘Flush_commands‘, ’5′ ‘Handler_commit’, ’19092941′ ‘Handler_delete’, ’0′ ‘Handler_discover’, ’0…
Post: MySQL 5.6: Improvements in the Nutshell
January 27, 2013 By 16 Comments
…for Row based Replication – Replication Utilities for Failover and Admin Transparency – Many new INFORMATION_SCHEMA Tables – - INNODB_METRICS – - …with Salt for Authentication – Use obfuscated password storage for command line tools – Policy Based password validation – Plugin authentication support…
Comment: What Linux Distribution do you use to run MySQL ?
December 16, 2012 By 17 Comments
@Dean, I like CentOS, but from a sys admin standpoint when using the command line, I am more confident with Ubuntu than I am with CentOS. With CentOS, I always fear that I will screw something up.
Comment: Should you move from MyISAM to Innodb ?
June 1, 2012 By 59 Comments
… for the learning purposes. I created all databases using “MySql Command Line” and it works fine on the first machine. The…;” that it displays all the four tables (customer, reservation, login, admin) under the hotel database. Please instruct to overcome this issue…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
December 5, 2011 By 102 Comments
… whatever they are comfortable with. There are multiple graphical and command-line options for configuring the cluster. The proper thing for… the options known, not to dictate a specific tool that admins must use. Having said that, the first document listed under…
Comment: Checking for a live database connection considered harmful
May 6, 2010 By 38 Comments
This problem shows itself in Ruby on Rails if you are using a connection pool. When a connection is checked out of a pool it is checked if it is active. Under heavy load this starts to cause problems on the DB and the “admin statistics” command starts appearing in your slow query log.
