2010/9/23 Johnny Withers <johnny@stripped>
>
> 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)
