I’m having a heck of a time this week.
My hosting service continues to shut me down saying that I’m having performance issues. I keep coming up with error establishing a database connection.
We’ve narrowed it down to my tmp folder in my root directory. It’s generating thousands of messages in my mysql_slow_queries folder. Even after deactivating all the plug-ins it’s still happening. There were like over 14,000 files in that one folder generated in the last five days.
It’s coming from comment_date_gmt and here is one of the files that I’m getting:
# Fri Jan 18 03:57:07 2013
# Query_time: 1.128534 Lock_time: 0.000299 Rows_sent: 46 Rows_examined: 22497
SELECT * FROM wp_comments WHERE comment_approved = ‘1’ AND comment_author_email = ‘email@example.com’ ORDER BY comment_date_gmt DESC
I called back again after finding out that after deactivating all my plug-ins that these files are still generating they told me that it’s beyond their scope of being able to help and for me to head over to this forum and see if anyone else has any suggestions.
I’m at a total loss as to what to do. I’m not a techie person so if someone walks me through what to do I can do that.
Has anyone had this issue and can someone please help me.
Great appreciated guys.
- The topic ‘Slow Queries’ is closed to new replies.