Re: Need Perfomance / Tuning Help
Show Status :
| Variable_name | Value |
+----------------------------+-----------+
| Aborted_clients | 0 |
| Aborted_connects | 3 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 92709869 |
| Bytes_sent | 264477665 |
| Com_admin_commands | 22 |
| Com_alter_db | 0 |
| Com_alter_table | 2 |
| Com_analyze | 94 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 528374 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 0 |
| Com_dealloc_sql | 0 |
| Com_delete | 46362 |
| 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 | 181 |
| 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 | 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 | 828568 |
| Com_set_option | 60182 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_charsets | 1 |
| Com_show_collations | 48 |
| Com_show_column_types | 0 |
| Com_show_create_db | 0 |
| Com_show_create_table | 7 |
| Com_show_databases | 3 |
| Com_show_errors | 0 |
| Com_show_fields | 241 |
| Com_show_grants | 0 |
| Com_show_innodb_status | 3986 |
| Com_show_keys | 238 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_privileges | 0 |
| Com_show_processlist | 1 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 3987 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 12 |
| Com_show_variables | 27 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_stmt_prepare | 22 |
| Com_stmt_execute | 22 |
| Com_stmt_send_long_data | 0 |
| Com_stmt_reset | 0 |
| Com_stmt_close | 22 |
| Com_truncate | 0 |
| Com_unlock_tables | 0 |
| Com_update | 31715 |
| Com_update_multi | 0 |
| Connections | 30185 |
| Created_tmp_disk_tables | 0 |
| Created_tmp_files | 3 |
| Created_tmp_tables | 24893 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 4 |
| Handler_delete | 97 |
| Handler_discover | 0 |
| Handler_read_first | 42955 |
| Handler_read_key | 1806260 |
| Handler_read_next | 4311586 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 619306 |
| Handler_read_rnd_next | 11437806 |
| Handler_rollback | 0 |
| Handler_update | 12273 |
| Handler_write | 617536 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 57654 |
| Key_blocks_used | 360 |
| Key_read_requests | 6588891 |
| Key_reads | 987 |
| Key_write_requests | 21208 |
| Key_writes | 10202 |
| Max_used_connections | 13 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 91 |
| Open_streams | 0 |
| Open_tables | 50 |
| Opened_tables | 169 |
| Qcache_free_blocks | 0 |
| Qcache_free_memory | 0 |
| Qcache_hits | 0 |
| Qcache_inserts | 0 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 0 |
| Qcache_queries_in_cache | 0 |
| Qcache_total_blocks | 0 |
| Questions | 1534963 |
| Rpl_status | NULL |
| Select_full_join | 2016 |
| Select_full_range_join | 0 |
| Select_range | 22272 |
| Select_range_check | 0 |
| Select_scan | 21816 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slave_retried_transactions | 0 |
| Slow_launch_threads | 0 |
| Slow_queries | 0 |
| Sort_merge_passes | 0 |
| Sort_range | 516 |
| Sort_rows | 893962 |
| Sort_scan | 27630 |
| Table_locks_immediate | 1063103 |
| Table_locks_waited | 293 |
| Threads_cached | 0 |
| Threads_connected | 3 |
| Threads_created | 30184 |
| Threads_running | 1 |
| Uptime | 6946 |
+----------------------------+-----------+
Subject
Views
Written By
Posted
2629
November 21, 2005 05:38AM
1854
November 21, 2005 06:31AM
Re: Need Perfomance / Tuning Help
1795
November 21, 2005 07:26AM
3256
November 22, 2005 08:21PM
1880
November 23, 2005 07:19AM
1804
November 23, 2005 08:54AM
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.