Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> SHOW GLOBAL STATUS;
- +-----------------------------------+------------+
- | Variable_name | Value |
- +-----------------------------------+------------+
- | Aborted_clients | 610 |
- | Aborted_connects | 2 |
- | Binlog_cache_disk_use | 0 |
- | Binlog_cache_use | 0 |
- | Bytes_received | 3542732221 |
- | Bytes_sent | 3021885933 |
- | Com_admin_commands | 0 |
- | Com_alter_db | 0 |
- | Com_alter_table | 0 |
- | Com_analyze | 0 |
- | Com_backup_table | 0 |
- | Com_begin | 27379 |
- | Com_change_db | 2124790 |
- | Com_change_master | 0 |
- | Com_check | 0 |
- | Com_checksum | 0 |
- | Com_commit | 27269 |
- | Com_create_db | 0 |
- | Com_create_function | 0 |
- | Com_create_index | 0 |
- | Com_create_table | 0 |
- | Com_dealloc_sql | 0 |
- | Com_delete | 47462 |
- | Com_delete_multi | 0 |
- | Com_do | 0 |
- | Com_drop_db | 0 |
- | Com_drop_function | 0 |
- | Com_drop_index | 0 |
- | Com_drop_table | 0 |
- | Com_drop_user | 0 |
- | Com_execute_sql | 0 |
- | Com_flush | 0 |
- | Com_grant | 0 |
- | Com_ha_close | 0 |
- | Com_ha_open | 0 |
- | Com_ha_read | 0 |
- | Com_help | 0 |
- | Com_insert | 1392705 |
- | Com_insert_select | 0 |
- | Com_kill | 0 |
- | Com_load | 0 |
- | Com_load_master_data | 0 |
- | Com_load_master_table | 0 |
- | Com_lock_tables | 0 |
- | Com_optimize | 0 |
- | Com_preload_keys | 0 |
- | Com_prepare_sql | 0 |
- | Com_purge | 0 |
- | Com_purge_before_date | 0 |
- | Com_rename_table | 0 |
- | Com_repair | 0 |
- | Com_replace | 56123 |
- | Com_replace_select | 0 |
- | Com_reset | 0 |
- | Com_restore_table | 0 |
- | Com_revoke | 0 |
- | Com_revoke_all | 0 |
- | Com_rollback | 0 |
- | Com_savepoint | 0 |
- | Com_select | 7055214 |
- | Com_set_option | 696558 |
- | Com_show_binlog_events | 0 |
- | Com_show_binlogs | 0 |
- | Com_show_charsets | 0 |
- | Com_show_collations | 0 |
- | Com_show_column_types | 0 |
- | Com_show_create_db | 0 |
- | Com_show_create_table | 0 |
- | Com_show_databases | 0 |
- | Com_show_errors | 0 |
- | Com_show_fields | 0 |
- | Com_show_grants | 0 |
- | Com_show_innodb_status | 0 |
- | Com_show_keys | 8194 |
- | Com_show_logs | 0 |
- | Com_show_master_status | 0 |
- | Com_show_ndb_status | 0 |
- | Com_show_new_master | 0 |
- | Com_show_open_tables | 0 |
- | Com_show_privileges | 0 |
- | Com_show_processlist | 2 |
- | Com_show_slave_hosts | 0 |
- | Com_show_slave_status | 0 |
- | Com_show_status | 17159 |
- | Com_show_storage_engines | 0 |
- | Com_show_tables | 0 |
- | Com_show_triggers | 0 |
- | Com_show_variables | 41 |
- | Com_show_warnings | 0 |
- | Com_slave_start | 0 |
- | Com_slave_stop | 0 |
- | Com_stmt_close | 0 |
- | Com_stmt_execute | 0 |
- | Com_stmt_fetch | 0 |
- | Com_stmt_prepare | 0 |
- | Com_stmt_reset | 0 |
- | Com_stmt_send_long_data | 0 |
- | Com_truncate | 309 |
- | Com_unlock_tables | 0 |
- | Com_update | 2172043 |
- | Com_update_multi | 0 |
- | Com_xa_commit | 0 |
- | Com_xa_end | 0 |
- | Com_xa_prepare | 0 |
- | Com_xa_recover | 0 |
- | Com_xa_rollback | 0 |
- | Com_xa_start | 0 |
- | Compression | OFF |
- | Connections | 2804202 |
- | Created_tmp_disk_tables | 109959 |
- | Created_tmp_files | 1170 |
- | Created_tmp_tables | 631814 |
- | Delayed_errors | 0 |
- | Delayed_insert_threads | 0 |
- | Delayed_writes | 0 |
- | Flush_commands | 1 |
- | Handler_commit | 0 |
- | Handler_delete | 355214 |
- | Handler_discover | 0 |
- | Handler_prepare | 0 |
- | Handler_read_first | 1150808 |
- | Handler_read_key | 547668009 |
- | Handler_read_next | 446409346 |
- | Handler_read_prev | 4178574 |
- | Handler_read_rnd | 432136942 |
- | Handler_read_rnd_next | 2531375685 |
- | Handler_rollback | 0 |
- | Handler_savepoint | 0 |
- | Handler_savepoint_rollback | 0 |
- | Handler_update | 3726845 |
- | Handler_write | 439901270 |
- | Innodb_buffer_pool_pages_data | 0 |
- | Innodb_buffer_pool_pages_dirty | 0 |
- | Innodb_buffer_pool_pages_flushed | 0 |
- | Innodb_buffer_pool_pages_free | 0 |
- | Innodb_buffer_pool_pages_latched | 0 |
- | Innodb_buffer_pool_pages_misc | 0 |
- | Innodb_buffer_pool_pages_total | 0 |
- | Innodb_buffer_pool_read_ahead_rnd | 0 |
- | Innodb_buffer_pool_read_ahead_seq | 0 |
- | Innodb_buffer_pool_read_requests | 0 |
- | Innodb_buffer_pool_reads | 0 |
- | Innodb_buffer_pool_wait_free | 0 |
- | Innodb_buffer_pool_write_requests | 0 |
- | Innodb_data_fsyncs | 0 |
- | Innodb_data_pending_fsyncs | 0 |
- | Innodb_data_pending_reads | 0 |
- | Innodb_data_pending_writes | 0 |
- | Innodb_data_read | 0 |
- | Innodb_data_reads | 0 |
- | Innodb_data_writes | 0 |
- | Innodb_data_written | 0 |
- | Innodb_dblwr_pages_written | 0 |
- | Innodb_dblwr_writes | 0 |
- | Innodb_log_waits | 0 |
- | Innodb_log_write_requests | 0 |
- | Innodb_log_writes | 0 |
- | Innodb_os_log_fsyncs | 0 |
- | Innodb_os_log_pending_fsyncs | 0 |
- | Innodb_os_log_pending_writes | 0 |
- | Innodb_os_log_written | 0 |
- | Innodb_page_size | 0 |
- | Innodb_pages_created | 0 |
- | Innodb_pages_read | 0 |
- | Innodb_pages_written | 0 |
- | 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 | 0 |
- | Innodb_rows_read | 0 |
- | Innodb_rows_updated | 0 |
- | Key_blocks_not_flushed | 0 |
- | Key_blocks_unused | 0 |
- | Key_blocks_used | 57990 |
- | Key_read_requests | 1850286751 |
- | Key_reads | 1209997 |
- | Key_write_requests | 20001729 |
- | Key_writes | 7727629 |
- | Last_query_cost | 0.000000 |
- | Max_used_connections | 277 |
- | Not_flushed_delayed_rows | 0 |
- | Open_files | 1541 |
- | Open_streams | 0 |
- | Open_tables | 1629 |
- | Opened_tables | 2252 |
- | Qcache_free_blocks | 10844 |
- | Qcache_free_memory | 31818008 |
- | Qcache_hits | 9669358 |
- | Qcache_inserts | 6799397 |
- | Qcache_lowmem_prunes | 709318 |
- | Qcache_not_cached | 281208 |
- | Qcache_queries_in_cache | 22256 |
- | Qcache_total_blocks | 55753 |
- | Questions | 26098495 |
- | Rpl_status | NULL |
- | Select_full_join | 116 |
- | Select_full_range_join | 0 |
- | Select_range | 1403846 |
- | Select_range_check | 0 |
- | Select_scan | 1271409 |
- | Slave_open_temp_tables | 0 |
- | Slave_retried_transactions | 0 |
- | Slave_running | OFF |
- | Slow_launch_threads | 0 |
- | Slow_queries | 1504 |
- | Sort_merge_passes | 585 |
- | Sort_range | 1263142 |
- | Sort_rows | 554892164 |
- | Sort_scan | 638477 |
- | Table_locks_immediate | 20365227 |
- | Table_locks_waited | 211851 |
- | Tc_log_max_pages_used | 0 |
- | Tc_log_page_size | 0 |
- | Tc_log_page_waits | 0 |
- | Threads_cached | 267 |
- | Threads_connected | 10 |
- | Threads_created | 277 |
- | Threads_running | 3 |
- | Uptime | 278674 |
- +-----------------------------------+------------+
- 222 rows in set (0.03 sec)
Add Comment
Please, Sign In to add comment