2010/9/23 Johnny Withers <joh...@pixelated.net> > > Can you show us the output of: show status like '%innodb%' > JW >
Sure. mysql> show status like '%innodb%'; +-----------------------------------+----------------+ | Variable_name | Value | +-----------------------------------+----------------+ | Innodb_buffer_pool_pages_data | 262143 | | Innodb_buffer_pool_pages_dirty | 7219 | | Innodb_buffer_pool_pages_flushed | 376090524 | | Innodb_buffer_pool_pages_free | 0 | | Innodb_buffer_pool_pages_misc | 1 | | Innodb_buffer_pool_pages_total | 262144 | | Innodb_buffer_pool_read_ahead_rnd | 385466 | | Innodb_buffer_pool_read_ahead_seq | 1304599 | | Innodb_buffer_pool_read_requests | 19253892075 | | Innodb_buffer_pool_reads | 142749467 | | Innodb_buffer_pool_wait_free | 0 | | Innodb_buffer_pool_write_requests | 3491971805 | | Innodb_data_fsyncs | 32809939 | | Innodb_data_pending_fsyncs | 0 | | Innodb_data_pending_reads | 0 | | Innodb_data_pending_writes | 0 | | Innodb_data_read | 4013196644352 | | Innodb_data_reads | 147753642 | | Innodb_data_writes | 440467519 | | Innodb_data_written | 12643997136896 | | Innodb_dblwr_pages_written | 376090524 | | Innodb_dblwr_writes | 5464581 | | Innodb_log_waits | 6599 | | Innodb_log_write_requests | 490350909 | | Innodb_log_writes | 201315186 | | Innodb_os_log_fsyncs | 13605257 | | Innodb_os_log_pending_fsyncs | 0 | | Innodb_os_log_pending_writes | 0 | | Innodb_os_log_written | 319623115776 | | Innodb_page_size | 16384 | | Innodb_pages_created | 6050545 | | Innodb_pages_read | 244945432 | | Innodb_pages_written | 376090524 | | Innodb_row_lock_current_waits | 0 | | Innodb_row_lock_time | 594325 | | Innodb_row_lock_time_avg | 154 | | Innodb_row_lock_time_max | 27414 | | Innodb_row_lock_waits | 3857 | | Innodb_rows_deleted | 2170086 | | Innodb_rows_inserted | 550876090 | | Innodb_rows_read | 15529216710 | | Innodb_rows_updated | 142880071 | +-----------------------------------+----------------+ 42 rows in set (0.00 sec) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
