MySQL Forums
Forum List  »  Performance

Re: CPU usage extremely high
Posted by: Temu Kinn
Date: April 28, 2015 09:03AM

SHOW GLOBAL STATUS returns:

Variable_name = Value
Aborted_clients = 6
Aborted_connects = 4
Binlog_cache_disk_use = 0
Binlog_cache_use = 0
Bytes_received = 364826647
Bytes_sent = 430635357
Com_admin_commands = 426296
Com_assign_to_keycache = 0
Com_alter_db = 0
Com_alter_db_upgrade = 0
Com_alter_event = 0
Com_alter_function = 0
Com_alter_procedure = 0
Com_alter_server = 0
Com_alter_table = 0
Com_alter_tablespace = 0
Com_analyze = 0
Com_backup_table = 0
Com_begin = 130
Com_binlog = 0
Com_call_procedure = 165
Com_change_db = 432469
Com_change_master = 0
Com_check = 0
Com_checksum = 0
Com_commit = 130
Com_create_db = 0
Com_create_event = 0
Com_create_function = 0
Com_create_index = 0
Com_create_procedure = 0
Com_create_server = 0
Com_create_table = 0
Com_create_trigger = 0
Com_create_udf = 0
Com_create_user = 0
Com_create_view = 0
Com_dealloc_sql = 0
Com_delete = 1700
Com_delete_multi = 0
Com_do = 0
Com_drop_db = 0
Com_drop_event = 0
Com_drop_function = 0
Com_drop_index = 0
Com_drop_procedure = 0
Com_drop_server = 0
Com_drop_table = 0
Com_drop_trigger = 0
Com_drop_user = 0
Com_drop_view = 0
Com_empty_query = 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 = 260322
Com_insert_select = 1
Com_install_plugin = 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_release_savepoint = 0
Com_rename_table = 0
Com_rename_user = 0
Com_repair = 0
Com_replace = 973
Com_replace_select = 0
Com_reset = 0
Com_restore_table = 0
Com_revoke = 0
Com_revoke_all = 0
Com_rollback = 0
Com_rollback_to_savepoint = 0
Com_savepoint = 0
Com_select = 482735
Com_set_option = 235441
Com_show_authors = 0
Com_show_binlog_events = 0
Com_show_binlogs = 0
Com_show_charsets = 0
Com_show_collations = 77
Com_show_column_types = 0
Com_show_contributors = 0
Com_show_create_db = 0
Com_show_create_event = 0
Com_show_create_func = 0
Com_show_create_proc = 0
Com_show_create_table = 0
Com_show_create_trigger = 0
Com_show_databases = 2
Com_show_engine_logs = 0
Com_show_engine_mutex = 0
Com_show_engine_status = 0
Com_show_events = 0
Com_show_errors = 0
Com_show_fields = 41
Com_show_function_status = 2
Com_show_grants = 0
Com_show_keys = 13
Com_show_master_status = 0
Com_show_new_master = 0
Com_show_open_tables = 0
Com_show_plugins = 2
Com_show_privileges = 0
Com_show_procedure_status = 2
Com_show_processlist = 2
Com_show_profile = 0
Com_show_profiles = 0
Com_show_slave_hosts = 0
Com_show_slave_status = 0
Com_show_status = 300
Com_show_storage_engines = 0
Com_show_table_status = 4
Com_show_tables = 5
Com_show_triggers = 0
Com_show_variables = 91
Com_show_warnings = 1
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_reprepare = 0
Com_stmt_reset = 0
Com_stmt_send_long_data = 0
Com_truncate = 0
Com_uninstall_plugin = 0
Com_unlock_tables = 0
Com_update = 22267
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 = 1411
Created_tmp_disk_tables = 50
Created_tmp_files = 219
Created_tmp_tables = 289591
Delayed_errors = 0
Delayed_insert_threads = 0
Delayed_writes = 0
Flush_commands = 1
Handler_commit = 323279
Handler_delete = 31313
Handler_discover = 0
Handler_prepare = 0
Handler_read_first = 791248
Handler_read_key = 564006239
Handler_read_next = 2951049845
Handler_read_prev = 0
Handler_read_rnd = 1253705
Handler_read_rnd_next = 374376698325
Handler_rollback = 0
Handler_savepoint = 0
Handler_savepoint_rollback = 0
Handler_update = 553451311
Handler_write = 2601532
Innodb_buffer_pool_pages_data = 508
Innodb_buffer_pool_pages_dirty = 0
Innodb_buffer_pool_pages_flushed = 63661
Innodb_buffer_pool_pages_free = 1
Innodb_buffer_pool_pages_misc = 3
Innodb_buffer_pool_pages_total = 512
Innodb_buffer_pool_read_ahead_rnd = 366131
Innodb_buffer_pool_read_ahead_seq = 108908
Innodb_buffer_pool_read_requests = 1432937882
Innodb_buffer_pool_reads = 8740282
Innodb_buffer_pool_wait_free = 0
Innodb_buffer_pool_write_requests = 682662
Innodb_data_fsyncs = 42617
Innodb_data_pending_fsyncs = 0
Innodb_data_pending_reads = 0
Innodb_data_pending_writes = 0
Innodb_data_read = 205590646784
Innodb_data_reads = 9993099
Innodb_data_writes = 88703
Innodb_data_written = 2129371648
Innodb_dblwr_pages_written = 63661
Innodb_dblwr_writes = 5009
Innodb_log_waits = 0
Innodb_log_write_requests = 60633
Innodb_log_writes = 28891
Innodb_os_log_fsyncs = 32599
Innodb_os_log_pending_fsyncs = 0
Innodb_os_log_pending_writes = 0
Innodb_os_log_written = 41422848
Innodb_page_size = 16384
Innodb_pages_created = 913
Innodb_pages_read = 12548125
Innodb_pages_written = 63661
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 = 4
Innodb_rows_deleted = 31311
Innodb_rows_inserted = 39575
Innodb_rows_read = 3965279152
Innodb_rows_updated = 19015
Key_blocks_not_flushed = 0
Key_blocks_unused = 0
Key_blocks_used = 6694
Key_read_requests = 3904172
Key_reads = 21372
Key_write_requests = 685562
Key_writes = 682713
Last_query_cost = 0.000000
Max_used_connections = 24
Not_flushed_delayed_rows = 0
Open_files = 50
Open_streams = 0
Open_table_definitions = 83
Open_tables = 64
Opened_files = 784
Opened_table_definitions = 74
Opened_tables = 199
Prepared_stmt_count = 0
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
Queries = 1944956
Questions = 1366739
Rpl_status = NULL
Select_full_join = 2364
Select_full_range_join = 0
Select_range = 19
Select_range_check = 0
Select_scan = 448293
Slave_open_temp_tables = 0
Slave_retried_transactions = 0
Slave_running = OFF
Slow_launch_threads = 0
Slow_queries = 4
Sort_merge_passes = 107
Sort_range = 2566
Sort_rows = 1257387
Sort_scan = 221690
Ssl_accept_renegotiates = 0
Ssl_accepts = 0
Ssl_callback_cache_hits = 0
Ssl_cipher =
Ssl_cipher_list =
Ssl_client_connects = 0
Ssl_connect_renegotiates = 0
Ssl_ctx_verify_depth = 0
Ssl_ctx_verify_mode = 0
Ssl_default_timeout = 0
Ssl_finished_accepts = 0
Ssl_finished_connects = 0
Ssl_session_cache_hits = 0
Ssl_session_cache_misses = 0
Ssl_session_cache_mode = NONE
Ssl_session_cache_overflows = 0
Ssl_session_cache_size = 0
Ssl_session_cache_timeouts = 0
Ssl_sessions_reused = 0
Ssl_used_session_cache_entries = 0
Ssl_verify_depth = 0
Ssl_verify_mode = 0
Ssl_version =
Table_locks_immediate = 1690011
Table_locks_waited = 10
Tc_log_max_pages_used = 0
Tc_log_page_size = 0
Tc_log_page_waits = 0
Threads_cached = 0
Threads_connected = 22
Threads_created = 1410
Threads_running = 2
Uptime = 81303
Uptime_since_flush_status = 81303

Options: ReplyQuote


Subject
Views
Written By
Posted
3052
April 28, 2015 08:55AM
Re: CPU usage extremely high
1421
April 28, 2015 09:03AM
1162
April 29, 2015 05:43PM
1189
May 09, 2015 07:22AM
1063
May 09, 2015 07:38AM
1076
May 11, 2015 06:30PM


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.