juddling Posted April 23, 2007 Share Posted April 23, 2007 I run a website with two dedicated servers one completely for the database, and the other for everything else. The database server has a massive CPU usage and I want to see which tables in particular are using up the CPU. I can only run queries to see the number of rows is there any way of seeing how much data has been transfered from the table etc? I have root server access so I can run linux commands also. I would be VERY greatful for a solution. Link to comment https://forums.phpfreaks.com/topic/48308-mysql-viewing-popular-tables/ Share on other sites More sharing options...
per1os Posted April 23, 2007 Share Posted April 23, 2007 http://dev.mysql.com/doc/refman/5.0/en/show-status.html I think thats what you want. Link to comment https://forums.phpfreaks.com/topic/48308-mysql-viewing-popular-tables/#findComment-236164 Share on other sites More sharing options...
juddling Posted April 23, 2007 Author Share Posted April 23, 2007 SHOW STATUS Aborted_clients 76 Aborted_connects 191 Binlog_cache_disk_use 0 Binlog_cache_use 0 Bytes_received 108 Bytes_sent 108 Com_admin_commands 0 Com_alter_db 0 Com_alter_table 0 Com_analyze 0 Com_backup_table 0 Com_begin 0 Com_change_db 1 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 0 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 0 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 0 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 0 Com_show_grants 0 Com_show_innodb_status 0 Com_show_keys 0 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 1 Com_show_storage_engines 0 Com_show_tables 0 Com_show_triggers 0 Com_show_variables 0 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 0 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 3881915 Created_tmp_disk_tables 0 Created_tmp_files 5 Created_tmp_tables 1 Delayed_errors 0 Delayed_insert_threads 0 Delayed_writes 0 Flush_commands 1 Handler_commit 0 Handler_delete 0 Handler_discover 0 Handler_prepare 0 Handler_read_first 0 Handler_read_key 0 Handler_read_next 0 Handler_read_prev 0 Handler_read_rnd 0 Handler_read_rnd_next 0 Handler_rollback 0 Handler_savepoint 0 Handler_savepoint_rollback 0 Handler_update 0 Handler_write 130 Innodb_buffer_pool_pages_data 19 Innodb_buffer_pool_pages_dirty 0 Innodb_buffer_pool_pages_flushed 1 Innodb_buffer_pool_pages_free 493 Innodb_buffer_pool_pages_latched 0 Innodb_buffer_pool_pages_misc 0 Innodb_buffer_pool_pages_total 512 Innodb_buffer_pool_read_ahead_rnd 1 Innodb_buffer_pool_read_ahead_seq 0 Innodb_buffer_pool_read_requests 84 Innodb_buffer_pool_reads 12 Innodb_buffer_pool_wait_free 0 Innodb_buffer_pool_write_requests 1 Innodb_data_fsyncs 7 Innodb_data_pending_fsyncs 0 Innodb_data_pending_reads 0 Innodb_data_pending_writes 0 Innodb_data_read 2756608 Innodb_data_reads 41 Innodb_data_writes 7 Innodb_data_written 35328 Innodb_dblwr_pages_written 1 Innodb_dblwr_writes 1 Innodb_log_waits 0 Innodb_log_write_requests 0 Innodb_log_writes 2 Innodb_os_log_fsyncs 5 Innodb_os_log_pending_fsyncs 0 Innodb_os_log_pending_writes 0 Innodb_os_log_written 1024 Innodb_page_size 16384 Innodb_pages_created 0 Innodb_pages_read 19 Innodb_pages_written 1 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 13292 Key_blocks_used 1760 Key_read_requests 1973010773 Key_reads 60346 Key_write_requests 1094888 Key_writes 787539 Last_query_cost 0.000000 Max_used_connections 38 Ndb_cluster_node_id 0 Ndb_connected_host Ndb_connected_port 0 Ndb_number_of_storage_nodes 0 Not_flushed_delayed_rows 0 Open_files 100 Open_streams 0 Open_tables 64 Opened_tables 0 Qcache_free_blocks 3132 Qcache_free_memory 10727704 Qcache_hits 59866660 Qcache_inserts 60152793 Qcache_lowmem_prunes 379359 Qcache_not_cached 167305 Qcache_queries_in_cache 5627 Qcache_total_blocks 14450 Questions 325079886 Rpl_status NULL Select_full_join 0 Select_full_range_join 0 Select_range 0 Select_range_check 0 Select_scan 1 Slave_open_temp_tables 0 Slave_retried_transactions 0 Slave_running OFF Slow_launch_threads 397 Slow_queries 0 Sort_merge_passes 0 Sort_range 0 Sort_rows 0 Sort_scan 0 Table_locks_immediate 244261748 Table_locks_waited 6229752 Tc_log_max_pages_used 0 Tc_log_page_size 0 Tc_log_page_waits 0 Threads_cached 0 Threads_connected 6 Threads_created 3881914 Threads_running 1 Uptime 1385940 Does anybody know what in this is the source of the problem? Link to comment https://forums.phpfreaks.com/topic/48308-mysql-viewing-popular-tables/#findComment-236175 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.