…QPI speed (and thus, faster inter-process/node communication). Results: First of all… with taskset. The following chart shows a results comparison on a single…max-time=120 –max-requests=0 –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…mysql-pidfile plugin verifies that MySQL‘s PID file exists. Evidence of contention in the processlist. The pmp-check-mysql-processlist plugin checks SHOW… much memory. A runaway server process, or poorly optimized queries, …environment makes it difficult to handle max_connections problems (the use of…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…n 1′ and ‘uptime’. That shows me what processes are running, but it also shows me load average, memory …I’ll paste in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | +———————+———–+ | max_heap_table_size | 268435456 |…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…you can use this sample database to spread processing over up to 20 nodes. The Infobright … data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact’G … 6697533 Avg_row_length: 241 Data_length: 1616904192 Max_data_length: 0 Index_length: 539279360 Data_…
Post: How fast can MySQL Process Data
April 9, 2008 By 3 Comments
… processing limitations of current systems. This raises valid question how fast can MySQL process…128) NOT NULL ) ENGINE=MEMORY DEFAULT CHARSET=latin1 mysql> show table status like “m4″ \G *************************** 1. …_row_length: 129 Data_length: 685609952 Max_data_length: 948528873 Index_length: …
Post: How Percona diagnoses MySQL server stalls
March 3, 2011 By 6 Comments
… approach and good tools. The process is straightforward: Determine what conditions …things you can observe (such as SHOW STATUS snapshots) and establish both …the following lines: # This is the max number of
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
…up to max_packet_size per connection) are all connection buffers and so if you close connection MySQL can … and forgot to remove (or still use for processing). Of course you will see these tables going … I do as it is least intrusive. Run SHOW ENGINE INNODB STATUS and look for memory information block…
Post: ALTER TABLE: Creating Index by Sort and Buffer Pool Size
June 27, 2012 By 4 Comments
… terms of data and index size: mysql> show table status like “sbtest” \G *************************** 1. row … Avg_row_length: 224 Data_length: 2247098368 Max_data_length: 0 Index_length: 1460322304 … IO, which is what file merge process uses. This is important illustration as…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… 0, not started, process no 3396, OS thread id 1152440672 MySQL thread id 8080, query id 728900 localhost root show innodb status —TRANSACTION 0 80157600, ACTIVE 4 sec, process no 3396… innodb_max_purge_lag will become your friend. “undo n:o” will show the undo log record number which purge is currently processing…
Post: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
June 22, 2012 By 33 Comments
…process when these pages age towards the tail of the LRU. The other good thing is that in Oracle MySQL…mysql-table-engine=innodb –mysql-socket=/tmp/mysql_sandbox5524.sock –mysql-db=test –oltp-table-name=sbtest_20m –max-time=900 –num-threads=8 –max…MySQL 5.5.23 does show an improvement over MySQL…
