…MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL…send all your writes to one node. This should prevent the deadlock errors, but will not change the lock…_count % 100 == 0 ) { $db->do( “UPDATE achievements SET …system to replicate your data to a …
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…Data Locking behavior prior to MySQL 5.5.3 Metadata Locking behavior prior to MySQL 5.5.3 Prior to MySQL… | Id | User | Host | db…| 0.000001 | | Sorting result | 0.000002 | | Sending data | 0.000040 | | end | 0.000003 |…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
…db | Command | Time | State | Info | Rows_sent | Rows_examined | Rows_read | +——-+——+———–+———-+———+——+————————-+—————————–+———–+—————+———–+ | 10219 | root | localhost | dumptest | Query | 324 | Sending data…
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 30 Comments
…db | Command | Time | State | Info | +—-+——+———–+——+————+——+——————-+———————————————————————-+ | 4 | root | localhost | test | Query | 80 | Sending data…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 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: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…and mysql shuts down Your server or RAID controller crashes and all data is…myisam and innodb tables. Global read lock only held until myisam tables are … we dump schemas: loop through each DB write out ALTER DATABASE DEFAULT CHARACTER …an error and are aborted, we send a critical alert immediately to …
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 21 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=…
