By bdparker on

Hi! I have a Drupal 7 site and for some indistinguishable reason, some times it bogs down the MySQL system and creates a lot of stalling for my site and other sites on my server.

Here's an example of some of the processes which are running when the system is slow:

https://www.dropbox.com/s/ivpwn2c1yjtdfty/tmp.PNG?dl=0

It seems the "Copying to tmp table" command are the ones which cause the slowness. Sometimes these processes can take several minutes to complete. What is this, and is there a way I can disable it? I think it comes from a couple views I have with complex search and filtering criteria, but I'm not positive.

Thanks,

Brendan

⋅ Categories: Drupal 7.x