WordPress.org

Support

Support » How-To and Troubleshooting » MySQL database memory

MySQL database memory

  • I’ve had htis problem periodically come up when I try to load my page. It’ll say that I’m exceeding my memory allocation and then give an error of what can’t load. Is there anyway I can better optimize the tables or my code so that I won’t get such errors?

Viewing 15 replies - 1 through 15 (of 21 total)
  • If you’re on a really restrictive host, one thing is the posts-per-page option. That’s a killer if you crank it up high.
    -d

    I’ve currently got posts per page up to 7. So it’s possible to get my host to increase the memory size? I was told that I could clear forms/tables at the end of each page to save on memory. Should I consider doing this if I can figure ou thow?

    I would tell your host that you want this sorting, and if they don’t do it all for you, move hosts.
    You are paying for tech support – not just for when things go wrong, but in making sure things stay going right, and if the host – who should have all the technical know-how – is telling you what you should do (when all you are using is a very popular and efficient blogging program) then I don’t think they are doing their job.
    It does sound like your host is being very restrictive, and that is up to them to alter their settings to enable you to have a blog that runs as intended. Given the high number of WP blogs and that this is the first query I can recall, it’s not a WP code problem, it’s the host.
    Hassle them, and good luck 🙂

    heh ok, I’ll have to get my host to increase the memory or something. What host do you use?

    I’m hosted through a friend 🙂
    Try these ?
    http://wiki.wordpress.org/Known%20Good%20Hosts

    heh yea i’m hosted through a friend too lol

    hmm, apparently i don’t have a database size limit, so i’m thinking that it’s not teh wordpress code itself, but a plugin i might’ve added. The error that came up with referenced to the user-online plugin, so could that be it?

    I guess the only way to find out is to remove it for a few days and see if the error happens again.
    It’s odd though – I really can’t recall an error like this being reported here before.

    yea, I’ve only seen it happen that one time for like a few minutes. maybe it was just a weird error.

    hmm i get this error now:
    Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 46080 bytes) in /home/virtual/site29/fst/var/www/html/wp-content/plugins/wp-last-visit.php on line 212
    Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 46080 bytes) in /home/virtual/site29/fst/var/www/html/wp-content/plugins/wp-style-switcher.php on line 130
    Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 46080 bytes) in /home/virtual/site29/fst/var/www/html/wp-content/plugins/useronline.php on line 67
    and a new php file seems to come up most refreshes until it decides to go through…

    it’s weird cause all those errors are so random. I’m gettin gmy host to increase the memory to 16 MB but I’m not sure if that’ll really fix it.

    That certainly looks like a plugin error. Which ones are you using ?

    lawtai, I can host you if you want.
    mail at carthik dot net is where I live (no, seriously) 🙂

    well, I turned off some of the plugins last night, but before I had running
    Cutter, Search Hilite, Polls, Recently commented posts, useronline, weather, since last visit, wp mobile edition, and style switcher. Thanks for the offer of hosting, but I’m not sure that it’s a hosting problem. I did get my host to increase the memory allocated so I’ll have to see if that does anything. But I’m thinking if it’s a plugin error, I’ll still get the error since it’s somehow using up all the memory.

    Cool! Let us know if you have any more problems.

Viewing 15 replies - 1 through 15 (of 21 total)
  • The topic ‘MySQL database memory’ is closed to new replies.
Skip to toolbar