Re: Slow Database
OK here is show global status.
show global status (222 Records)
Variable_name Value
Aborted_clients 0
Aborted_connects 0
Binlog_cache_disk_use 0
Binlog_cache_use 0
Bytes_received 79702650
Bytes_sent 2571110995
Com_admin_commands 86
Com_alter_db 0
Com_alter_table 9
Com_analyze 1
Com_backup_table 0
Com_begin 0
Com_change_db 209262
Com_change_master 0
Com_check 1
Com_checksum 0
Com_commit 0
Com_create_db 0
Com_create_function 0
Com_create_index 0
Com_create_table 2
Com_dealloc_sql 0
Com_delete 150
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 10286
Com_insert_select 2
Com_kill 0
Com_load 0
Com_load_master_data 0
Com_load_master_table 0
Com_lock_tables 0
Com_optimize 34
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 0
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 117991
Com_set_option 0
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 136
Com_show_grants 0
Com_show_innodb_status 0
Com_show_keys 143
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 0
Com_show_slave_hosts 0
Com_show_slave_status 0
Com_show_status 13
Com_show_storage_engines 0
Com_show_tables 10
Com_show_triggers 0
Com_show_variables 6
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 0
Com_unlock_tables 0
Com_update 11354
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 4980
Created_tmp_disk_tables 10300
Created_tmp_files 12
Created_tmp_tables 11584
Delayed_errors 0
Delayed_insert_threads 0
Delayed_writes 0
Flush_commands 1
Handler_commit 0
Handler_delete 110
Handler_discover 0
Handler_prepare 0
Handler_read_first 6676
Handler_read_key 1851699
Handler_read_next 46013602
Handler_read_prev 838720604
Handler_read_rnd 3865142
Handler_read_rnd_next 2664897184
Handler_rollback 0
Handler_savepoint 0
Handler_savepoint_rollback 0
Handler_update 9797
Handler_write 6041274
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 1
Key_blocks_unused 222455
Key_blocks_used 21763
Key_read_requests 76246649
Key_reads 422599
Key_write_requests 7223671
Key_writes 46214
Last_query_cost 0.000000
Max_used_connections 51
Not_flushed_delayed_rows 0
Open_files 124
Open_streams 0
Open_tables 68
Opened_tables 2640
Qcache_free_blocks 5523
Qcache_free_memory 242230440
Qcache_hits 224071
Qcache_inserts 113919
Qcache_lowmem_prunes 0
Qcache_not_cached 4372
Qcache_queries_in_cache 21808
Qcache_total_blocks 49325
Questions 579024
Rpl_status NULL
Select_full_join 4321
Select_full_range_join 0
Select_range 1809
Select_range_check 0
Select_scan 64267
Slave_open_temp_tables 0
Slave_retried_transactions 0
Slave_running OFF
Slow_launch_threads 0
Slow_queries 510
Sort_merge_passes 6
Sort_range 0
Sort_rows 4233533
Sort_scan 21862
Table_locks_immediate 171511
Table_locks_waited 3495
Tc_log_max_pages_used 0
Tc_log_page_size 0
Tc_log_page_waits 0
Threads_cached 42
Threads_connected 9
Threads_created 51
Threads_running 4
Uptime 77014
generated 02/06/2006 09:19:32 by MySQL-Front 2.2
Subject
Views
Written By
Posted
9718
May 31, 2006 11:29AM
3839
May 31, 2006 12:06PM
3162
May 31, 2006 12:43PM
2973
May 31, 2006 07:43PM
2888
June 01, 2006 12:19AM
3625
June 01, 2006 04:14AM
2774
June 01, 2006 06:40PM
Re: Slow Database
3313
June 02, 2006 02:17AM
3104
June 05, 2006 10:37AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.