All pastes #588891 Raw Edit

Miscellany

public text v1 · immutable
#588891 ·published 2007-06-25 19:06 UTC
rendered paste body
1. Server status (connection active/failed) - login to db OK/FAIL
3. CPU usage
4. I/O usage
5. RAM usage

6. Threads Running
| Threads_cached                    | 7         | 
| Threads_connected                 | 1         | 
| Threads_created                   | 14        | 
| Threads_running                   | 1         | 

7. Connection usage
| Max_used_connections              | 14        |

8. Query Rate
show global status like 'Uptime'
show global status like 'Questions'

questions / uptime = query rate

9. Slow Queries
| Slow_queries                      | 1         | 

10. Lock Connections 
| Table_locks_immediate             | 452884    | 
| Table_locks_waited                | 604       | 
	
11. Keys
| Key_blocks_not_flushed            | 0         | 
| Key_blocks_unused                 | 14312     | 
| Key_blocks_used                   | 187       | 
| Key_read_requests                 | 922030    | 
| Key_reads                         | 4866      | 
| Key_write_requests                | 398575    | 
| Key_writes                        | 278297    | 

12. Query Cache 
| Qcache_free_blocks                | 75        | 
| Qcache_free_memory                | 133490464 | 
| Qcache_hits                       | 516831    | 
| Qcache_inserts                    | 117351    | 
| Qcache_lowmem_prunes              | 0         | 
| Qcache_not_cached                 | 3485      | 
| Qcache_queries_in_cache           | 459       | 
| Qcache_total_blocks               | 1034      |

13. Temp Tables to Disk
| Created_tmp_disk_tables           | 0         | 
| Created_tmp_files                 | 5         | 
| Created_tmp_tables                | 3         | 

14. Open Tables
| Opened_tables                     | 0         | 

15. Open Files
| Open_files                        | 133       |

16. InnoDB Stats
| Innodb_buffer_pool_pages_free     | 16291     | 
| Innodb_buffer_pool_pages_total    | 16384     |  
| Innodb_buffer_pool_read_requests  | 11841     | 
| Innodb_buffer_pool_reads          | 41        | 
| Innodb_buffer_pool_wait_free      | 0         | 
| Innodb_buffer_pool_write_requests | 444       | 
| Innodb_data_fsyncs                | 220       | 
| Innodb_data_pending_fsyncs        | 0         | 
| Innodb_data_pending_reads         | 0         | 
| Innodb_data_pending_writes        | 0         | 
| Innodb_data_read                  | 3690496   | 
| Innodb_data_reads                 | 63        | 
| Innodb_data_writes                | 231       | 
| Innodb_data_written               | 3781632   | 
| Innodb_dblwr_pages_written        | 113       | 
| Innodb_dblwr_writes               | 32        | 
| Innodb_log_waits                  | 0         | 
| Innodb_log_write_requests         | 53        | 
| Innodb_log_writes                 | 68        | 
| Innodb_os_log_fsyncs              | 101       | 
| Innodb_os_log_pending_fsyncs      | 0         | 
| Innodb_os_log_pending_writes      | 0         | 
| Innodb_os_log_written             | 61952     | 
| Innodb_page_size                  | 16384     | 
| Innodb_pages_created              | 4         | 
| Innodb_pages_read                 | 92        | 
| Innodb_pages_written              | 113       | 
| Innodb_row_lock_current_waits     | 0         | 
| Innodb_row_lock_time              | 0         | 
| Innodb_row_lock_time_avg          | 0         | 
| Innodb_row_lock_time_max          | 0         | 
| Innodb_row_lock_waits             | 0         | 
| Innodb_rows_deleted               | 0         | 
| Innodb_rows_inserted              | 86        | 
| Innodb_rows_read                  | 4519      | 
| Innodb_rows_updated               | 4         | 

17. Slave Status
| Slave_running                     | OFF       | 
	SQL thread ON/OFF
	I/O thread ON/OFF
	seconds behind

18. Critical Alerts
19. Warnings
20. Info