…localhost | test | Query | 0 | NULL | show processlist | +—-+———-+———–+——+———+——+———————————+————————————————————-+ 3 …| 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
… root | localhost | dumptest | Query | 324 | Sending data | select count(*) from A,B…> show processlist; +——-+——+———–+———-+————+——+——————————+——————————+———–+—————+———–+ | Id | User | Host | db | Command…
Post: How fast is FLUSH TABLES WITH READ LOCK?
April 24, 2010 By 30 Comments
… | 4 | root | localhost | test | Query | 80 | Sending data | select… | test | Query | 0 | NULL | show processlist | +—-+——+———–+——+————+——+——————-+———————————————————————-+ 4 …
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… 0 MySQL thread id 8079, query id 728899 localhost root Sending data select sql_calc_found_rows * from b limit 5 Trx… 0 MySQL thread id 8078, query id 728898 localhost root Sending data select sql_calc_found_rows * from b limit 5 Trx…, there is generic statement information which is visible in SHOW PROCESSLIST showed in SHOW INNODB STATUS, such as statement which is…
Post: The perils of InnoDB with Debian and startup scripts
January 28, 2009 By 13 Comments
… processlist; +——+——————+—————-+————- | Id | User | State | Info +——+——————+—————-+————- | 7 | debian-sys-maint | NULL | CHECK TABLE tableA… | 739 | user | | NULL | 4776 | user | | NULL | 6318 | user | Sending data…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…application is suffering because of stale data. This especially applies to Software as… Show Processlist depending on if it processes query or simply waiting. By pooling processlist … user | | NULL | Connect | 2665 | Waiting for master to send event | NULL | | 801813 | system user | | NULL | Connect |…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… compare it against the server’s variables or whatever other data I need, and write something instructional to the client about… earlier optimization. Back to the output of mysqladmin. When I send the report to the client, it typically looks something like…’s workload and data After I’m done with that, I’ll grab a few snapshots of SHOW FULL PROCESSLIST, and look…
Post: Percona Toolkit by example - pt-stalk
January 3, 2013 By 3 Comments
… you diagnose the problem by capturing diagnostic data that helps you pinpoint what’s causing… “show processlist” command, in this case, I’m using the “Host” variable. $ pt-stalk –function processlist –variable… $EXT_ARGV is the connection options that you will send it to the pt-stalk. # # $2 $3 $4…
Post: Living with backups
November 6, 2008 By 28 Comments
… text file or ordinarily copies the binary files from the data directory to a safe location. Obviously both ways involve much… that. It works by sending signals that can either stop or resume the application that copies the data: use POSIX “:sys_wait… cheks can also be more sphisticated or include things like processlist information, CPU load avergages, I/O load, etc. In this…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…stmt_resetblogpercona.commanual Com_stmt_send_long_datablogpercona.commanual Com_…data_pending_readsblogpercona.commanual Innodb_data_pending_writesblogpercona.commanual Innodb_data_readblogpercona.commanual Innodb_data_readsblogpercona.commanual Innodb_data_writesblogpercona.commanual Innodb_data…
