…db | Command | Time | State | Info | Rows_sent | Rows_examined | Rows_read | +——-+——+———–+———-+———+——+————————-+—————————–+———–+—————+———–+ | 10219 | root | localhost | dumptest | Query | 324 | Sending data…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
…_send_long_data to see whenever sending long data…mysql> select sum(data_length+index_length) from information_schema.tables where engine=’memory’; +——————————-+ | sum(data… system 294352 (82672 + 211680) Lock system 318875832 (318747272 + 128560) … 3046376 Modified db pages 23419 …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, especially the option…commanual Com_alter_db_upgradeblogpercona.commanual Com….commanual Com_stmt_send_long_datablogpercona.commanual…lock_countblogpercona.commanual memlockblogpercona.commanual min_examined_row_limitblogpercona.commanual myisam_block_sizeblogpercona.commanual myisam_data…
Post: How fast is FLUSH TABLES WITH READ LOCK?
April 24, 2010 By 28 Comments
…db | Command | Time | State | Info | +—-+——+———–+——+————+——+——————-+———————————————————————-+ | 4 | root | localhost | test | Query | 80 | Sending data…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…var/db/mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql… to the output of mysqladmin. When I send the report to the client, it typically…settings and status pretty quickly. Analyzing MySQL‘s workload and data After I’m done with …
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… declared inside InnoDB 442 mysql tables in use 1, locked 0 MySQL thread id 8079, query id 728899 localhost root Sending data select sql_calc… declared inside InnoDB 166 mysql tables in use 1, locked 0 MySQL thread id 8078, query id 728898 localhost root Sending data select sql_calc… pool size 262144 Free buffers 0 Database pages 258053 Modified db pages 37491 Pending reads 0 Pending writes: LRU 0, flush…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…’ ‘Com_stmt_reset’, ’0′ ‘Com_stmt_send_long_data‘, ’0′ ‘Com_truncate’, ’0′ ‘Com_…mysql.sock pid-file=/var/run/mysql/mysql.pid datadir=/db/disk2/mysql/data log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql…used before. skip-locking innodb_data_home_dir=/db/disk2/data innodb_data_file_path=…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…data…Lock…mysql> show processlist; +——–+————-+———–+——+———+——+———————————————————————–+——————+ | Id | User | Host | db…
