mysql copying to tmp table query stuck

Security related issues

mysql copying to tmp table query stuck

Postby praveenj79 » Mon Aug 20, 2018 3:52 pm

Hi,
I am facing some issues when I am tring to pull some reports the query is stuck on copying to tmp table in mysql process list

I am Using OSDIAL 3.2 version

the database is 2 years old and database size is 2GB


For example if I select a user and select stats report then the page is stuck and at bottom it will show server ip and waiting

but when I go in mysql and enter show processlist it will show copying to tmp table with the query to get the information if i leave it then also it is stuck over their I have to kill it at list.

Can any one help me to resolve this issue

I have tried to put new values in /etc/my.cnf after that mysql doses start.

I have changed below values in server.cnf but no luck

max_connections = 400 change it 1000

max_heap_table_size = 256M change to 1000M

tmp_table_size = 556M change to 2000M

key_buffer_size = 32M 200M

myisam_repair_threads = 1 change to 2

max_allowed_packet = 16M change to 64M
praveenj79
 
Posts: 7
Joined: Mon Dec 03, 2012 2:21 pm

Return to Security

Who is online

Users browsing this forum: No registered users and 0 guests

cron