I am running one magento instance, When I open my website and check process list using

Show Processlist

in mysql it shows multiple of queries set to "sleep". I am only opening one static page, which contains header,footer and static content of a cms page.

See Screenshot. enter image description here

When I check with

Show full processlist;

It does not show any queries. There is no query logged in mysql and it is slow to open the query log also.

Please let me know what does this mean? Why it is only in a Magento Project, it is not happening in Core PHP project?

Tell me if any information from my side is required.

  • Hi, did you solve this problem? I faced it hours ago and could solve it by deleting malicious sql injections in catalogsearch_query database table. Commented Feb 16, 2018 at 11:08
  • Yes, I turned off first visitor log data. Follow my below code in app/etc/local.xml Commented Feb 20, 2018 at 4:35

1 Answer 1


@KevinKrieger Yes, I turned on Memcache on server also switch off logs in magento. Follow my below code in app/etc/local.xml

To Enable Memcache for Magento after enabling it on server.


To Turn off all logs disabled disabled disabled disabled disabled disabled


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.