MySQL Forums
Forum List  »  Performance

Re: Unusually high cpu usage
Posted by: Fabrizio Bartolomucci
Date: January 13, 2015 11:47AM

Here I am again with 296% while executing a quite long procedure to reload the full line of a bus. This is however the quite poor, to my judgment, current processlist:
86098 fabrizio localhost inarrivo Sleep 500 NULL
86099 fabrizio localhost inarrivo Sleep 6 NULL
86260 fabrizio localhost inarrivo Sleep 459 NULL
86261 fabrizio localhost inarrivo Sleep 6 NULL
87493 fabrizio localhost inarrivo Sleep 56 NULL
87494 fabrizio localhost inarrivo Sleep 6 NULL
87666 fabrizio localhost inarrivo Query 5 Sending data SELECT * FROM palette WHERE number='77135'
87667 fabrizio localhost inarrivo Query 5 Sending data SELECT * FROM palette WHERE number='80495'
87668 fabrizio localhost inarrivo Query 5 Sending data SELECT * FROM palette WHERE number='77136'
87673 fabrizio localhost inarrivo Sleep 2 NULL
87675 fabrizio localhost inarrivo Sleep 2 NULL
87677 fabrizio localhost inarrivo Sleep 2 NULL
87680 fabrizio localhost inarrivo Sleep 1 NULL
87681 root localhost NULL Sleep 1 NULL
87682 fabrizio localhost inarrivo Query 0 NULL

The Mysql version is 5.1.73-log
I have 2 GB of RAM.
the last command yields:

bulk_insert_buffer_size 8388608
join_buffer_size 1048576
key_buffer_size 524288000
myisam_sort_buffer_size 268435456
net_buffer_length 16384
preload_buffer_size 32768
read_buffer_size 131072
read_rnd_buffer_size 1048576
sort_buffer_size 2097144
sql_buffer_result OFF

And finally this is the show status result with a whopping number of connections I frankly do not know where they come from:

Aborted_clients 0
Aborted_connects 83
Binlog_cache_disk_use 0
Binlog_cache_use 0
Bytes_received 453
Bytes_sent 8287
Com_admin_commands 0
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 0
Com_binlog 0
Com_call_procedure 0
Com_change_db 2
Com_change_master 0
Com_check 0
Com_checksum 0
Com_commit 0
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 0
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 0
Com_insert_select 0
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 0
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 1
Com_set_option 3
Com_show_authors 0
Com_show_binlog_events 0
Com_show_binlogs 0
Com_show_charsets 1
Com_show_collations 1
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
Variable_name Value
Com_show_databases 1
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 0
Com_show_function_status 0
Com_show_grants 1
Com_show_keys 0
Com_show_master_status 0
Com_show_new_master 0
Com_show_open_tables 0
Com_show_plugins 0
Com_show_privileges 0
Com_show_procedure_status 0
Com_show_processlist 0
Com_show_profile 0
Com_show_profiles 0
Com_show_slave_hosts 0
Com_show_slave_status 0
Com_show_status 1
Com_show_storage_engines 0
Com_show_table_status 0
Com_show_tables 0
Com_show_triggers 0
Com_show_variables 3
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_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 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 92366
Created_tmp_disk_tables 0
Created_tmp_files 4
Created_tmp_tables 6
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 188
Handler_rollback 0
Handler_savepoint 0
Handler_savepoint_rollback 0
Handler_update 0
Handler_write 182
Key_blocks_not_flushed 0
Key_blocks_unused 452415
Key_blocks_used 542
Key_read_requests 458046
Key_reads 528
Key_write_requests 1471
Key_writes 1343
Last_query_cost 0.000000
Max_used_connections 52
Not_flushed_delayed_rows 0
Open_files 81
Open_streams 0
Open_table_definitions 31
Open_tables 56
Opened_files 543
Opened_table_definitions 0
Opened_tables 0
Prepared_stmt_count 0
Qcache_free_blocks 40
Qcache_free_memory 78450568
Qcache_hits 33301
Qcache_inserts 7583
Qcache_lowmem_prunes 0
Qcache_not_cached 687
Qcache_queries_in_cache 110
Qcache_total_blocks 271
Queries 181202
Questions 14
Variable_name Value
Rpl_status NULL
Select_full_join 0
Select_full_range_join 0
Select_range 0
Select_range_check 0
Select_scan 6
Slave_open_temp_tables 0
Slave_retried_transactions 0
Slave_running OFF
Slow_launch_threads 0
Slow_queries 0
Sort_merge_passes 0
Sort_range 0
Sort_rows 0
Sort_scan 0
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 41611
Table_locks_waited 984
Tc_log_max_pages_used 0
Tc_log_page_size 0
Tc_log_page_waits 0
Threads_cached 15
Threads_connected 14
Threads_created 73
Threads_running 4
Uptime 19530
Uptime_since_flush_status 19530

Options: ReplyQuote


Subject
Views
Written By
Posted
2946
January 11, 2015 02:55PM
1183
January 12, 2015 09:49PM
1034
January 13, 2015 09:32AM
Re: Unusually high cpu usage
1365
January 13, 2015 11:47AM
1052
January 13, 2015 04:21PM


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.