MySQL queries stacks and delaying in execution

saurabhnsonar

• October 11, 2014 05:44

Hi all, I recently upgraded MySQL on my server from 5.5 to 5.6.17. After I upgrade I notice that MySQL process stacks and taking delay in execution. Many process just shows sleep for long time without execution and stacking in queue. Due to this I am having comparatively very high load of 30.0+ on the server. my.cnf output: [mysqld] default-storage-engine=MyISAM innodb_file_per_table=1 local-infile=0 open_files_limit=50000 max_allowed_packet=268435456 innodb_buffer_pool_size=734217728 query_cache_type=1 table_open_cache=2500 max_heap_table_size=32M tmp_table_size=32M slow_query_log=1 slow_query_log_file = /var/log/mysql/slow.log long_query_time = 1 log-queries-not-using-indexes key_buffer_size=4M query_cache_size=4M join_buffer_size=400K low_priority_updates=1 concurrent_insert=ALWAYS
Please help me with this because my server is having very hih load from couple of days after I upgraded to newer version of MySQL.

• 

  cPanelMichael

  • October 23, 2014 15:49

  Hello :) You may want to run the MySQL tuner as discussed here: mysqlmymonlite.sh server stats gathering tool for cPanel Server Thank you.

  0

Please sign in to leave a comment.