…window for each node and run the tool on each so I can see things across the entire cluster at…columns in the cluster section, and it’s important to understand that this tool only currently …This is a general indicator that flow control is slowing replication (and hence overall cluster writes) down. …
Post: Realtime stats to pay attention to in Percona XtraDB Cluster and Galera
November 26, 2012 By 4 Comments
Post: Slow Query Log analyzes tools
September 6, 2006 By 84 Comments
… So “tail -f mysql-slow.log | mysql_slow_log_filter -T 0.5 -R 1000″ will look at queries as they…examined. Aggregating slow query log As I already mentioned besides finding slowest queries it is important to find… tool normally require you to keep the other window open and find query sample with real …
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… for many tables at onces, which typically make system extremely slow and also can …MySQL to fail with wierd error messages. In MySQL 4.1 sync_frm option was added which reduces this problem as time window… is important. There are other problems which you may experience related to MySQL Crash Recovery…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… free already. OS Waits are relatively slow, and if you get tens of …look at it is context switch rate in your OS stats. The other important peice …declared inside InnoDB 442 mysql tables in use 1, locked 0 MySQL thread id 8079, … always see 4 helper threads, on Windows it however can be adjusted by …
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…on Unix at a time. On Windows, InnoDB uses native async I/O, and can perform many read-aheads at …swap out not buffer pool but some other important parts of MySQL process. Q20: We’ve migrated to using … it’s having to seek on disk which slows down throughput. If we could control the checkpointing …
