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 6 replies - 16 through 21 (of 21 total)
  • Thread Starter lawtai

    (@lawtai)

    well, i just got my database memory size upped to 16MB so hopefully the problem will go away and I won’t have to do something with the code.

    I get similar errors, but only when I try to create a thumbnail during upload of a large image. For images under 1mb, it seems to work ok. The error I get is:
    Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 8192 bytes) in /home/mabennett/public_html/wp-admin/admin-functions.php on line 135
    Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 40 bytes) in Unknown on line 0
    Any idea about how to change this so that it doesn’t happen? I’m hosting on my own Linux box, sitting in the next room.

    This is probably more of a Linux config problem, but … Help me! I’m not very good with Linux!

    I also posted this at Ars Forum, and here’s what I found out:

    Ok. I figured it out.
    In the file php.ini file, there’s a line:
    memory_limit = 8M ;
    which, surprise surprise, is 8388608 bytes. So, if you set this value higher, then it doesn’t occur.

    Yeah, that’s not a database error, that’s a PHP memory limit error, as were all the previously-noted errors.
    Hosts that cap at 8MB should be shot (mine does — need to ‘prove’ to them why I need more!).
    -d

    Just out of curiousity, what type of scripts do you run that require more memory than that?

Viewing 6 replies - 16 through 21 (of 21 total)
  • The topic ‘MySQL database memory’ is closed to new replies.