Slow Queries

  • 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
    use adrienn7_wrd01;
    SET timestamp=1358506627;
    SELECT * FROM wp_comments WHERE comment_approved = ‘1’ AND comment_author_email = ‘[email protected]’ 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.

Viewing 2 replies - 1 through 2 (of 2 total)

  • HI Missa,

    Sorry to hear about this. This is very strange. Is it possible for you to switch themes for maybe a day or so and see if that helps narrow the problem. If these queries stop than at least you will know that it’s the theme and you can dig a bit more.

    Failing that, it sounds like you may need to hire someone who could look into this. Your theme might be running deprecated code or unnecessary queries. I’m only guessing though… I’m not 100% sure.

    Thread Starter Missa

    (@missa)

    Hi Missa,

    I haven’t done anything with my theme in awhile so why would this all of a sudden affect that? I’m using Thesis so maybe I’ll go over there and see if anyone else is having this issue.

    Thanks for replying so I’m still on the hunt for answers.

    ~Adrienne

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Slow Queries’ is closed to new replies.