Forums

wp or mysql problem: WordPress database error: [MySQL client run out of memory] (8 posts)

  1. tomasc
    Member
    Posted 6 years ago #

    I have three blogs that I just upgraded to 2.01 this weekend and everything worked fine for 2 days then yesterday on 2 of my blogs I started getting this error WordPress database error: [MySQL client run out of memory] when editing or inserting a new post.

    All are the same except for the themes more or less and have the same plugins. The major difference is that the 2 that are displaying this problem have 7000+ and 10,000+ records in wp_posts.

    What I am trying to determine is if this is a wordpress problem or a host/mysql problem. Has anyone else seen this?

    This is the error I get (and for the life of me I can't figure out why there are so many select statements)

    WordPress database error: [MySQL client run out of memory]
    SELECT * FROM wp_posts WHERE ID = '2635' LIMIT 1

    WordPress database error: [MySQL client run out of memory]
    SELECT * FROM wp_posts WHERE ID = '2634' LIMIT 1

    WordPress database error: [MySQL client run out of memory]
    SELECT * FROM wp_posts WHERE ID = '2633' LIMIT 1

    WordPress database error: [MySQL client run out of memory]
    SELECT * FROM wp_posts WHERE ID = '2632' LIMIT 1

    WordPress database error: [MySQL client run out of memory]
    SELECT * FROM wp_posts WHERE ID = '2631' LIMIT 1

    WordPress database error: [MySQL client run out of memory]
    SELECT * FROM wp_posts WHERE ID = '2630' LIMIT 1

    WordPress database error: [MySQL client run out of memory]
    SELECT * FROM wp_posts WHERE ID = '2629' LIMIT 1

    WordPress database error: [MySQL client run out of memory]
    SELECT * FROM wp_posts WHERE ID = '2628' LIMIT 1

    WordPress database error: [MySQL client run out of memory]
    SELECT * FROM wp_posts WHERE ID = '2627' LIMIT 1

    WordPress database error: [MySQL client run out of memory]
    SELECT * FROM wp_posts WHERE ID = '2626' LIMIT 1

    WordPress database error: [MySQL client run out of memory]
    SELECT * FROM wp_posts WHERE ID = '2625' LIMIT 1

    WordPress database error: [MySQL client run out of memory]
    SELECT * FROM wp_posts WHERE ID = '2624' LIMIT 1

    WordPress database error: [MySQL client run out of memory]
    SELECT * FROM wp_posts WHERE ID = '2623' LIMIT 1

    WordPress database error: [MySQL client run out of memory]
    SELECT * FROM wp_posts WHERE ID = '2622' LIMIT 1

    WordPress database error: [MySQL client run out of memory]
    SELECT * FROM wp_posts WHERE ID = '2621' LIMIT 1

    WordPress database error: [MySQL client run out of memory]
    SELECT * FROM wp_posts WHERE ID = '2620' LIMIT 1

    WordPress database error: [MySQL client run out of memory]
    SELECT * FROM wp_posts WHERE ID = '2619' LIMIT 1

    WordPress database error: [MySQL client run out of memory]
    SELECT * FROM wp_posts WHERE ID = '2618' LIMIT 1

  2. asturleones
    Member
    Posted 5 years ago #

    I have just the same problem. Some ideas?

  3. Samuel B
    moderator
    Posted 5 years ago #

    If you are really using v 2.0.1 then delete the contents of your WP cache folder.

  4. asturleones
    Member
    Posted 5 years ago #

    Hi samboll, i'm using v 2.1.

  5. drmike
    Member
    Posted 5 years ago #

    Gotta a dmit that I've voting for host myself but without knowing their settings, I couldn't be sure.

  6. Otto
    Tech Ninja
    Posted 5 years ago #

    If you have a line with "ENABLE_CACHE" in your wp-config.php file, delete that line.

  7. asturleones
    Member
    Posted 5 years ago #

    no line *enable_cache* in my config file.

  8. asturleones
    Member
    Posted 5 years ago #

    I forget: thank you all for help :)

Topic Closed

This topic has been closed to new replies.

About this Topic