MySQL queries stacks and delaying in execution
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.
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.
-
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.
Comments
1 comment