May 25, 2012

Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables

db | Command | Time | State | Info | Rows_sent | Rows_examined | Rows_read | +——-+——+———–+———-+———+——+————————-+—————————–+———–+—————+———–+ | 10219 | root | localhost | dumptest | Query | 324 | Sending data

Post: Troubleshooting MySQL Memory Usage

…_send_long_data to see whenever sending long datamysql> 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

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?

db | Command | Time | State | Info | +—-+——+———–+——+————+——+——————-+———————————————————————-+ | 4 | root | localhost | test | Query | 80 | Sending data

Post: How Percona does a MySQL Performance Audit

…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

… 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

…’ ‘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

dataLockmysql> show processlist; +——–+————-+———–+——+———+——+———————————————————————–+——————+ | Id | User | Host | db