How to increase the time for the queries to auto kill themselves. What exactly should I be doing to eliminate this repeated error.
I am using PrestaShop and I have been facing these queries which are crowding my server as reported by my server assistant.
Thu Jun 18 09:56:15 +0000 2015 [info] killed_thread_id:11508142 user:pres102 host:localhost db:pres102 command:Sleep time:21 query:
These are repeatedly being displayed in the list of killed queries.
In which file do I make the changes for these queries to be resolved correctly?
Also what other changes in which file I should make to kill other queries. I do not know the file name in PrestaShop where such queries and their changes should be made. Please help.