Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2009
    Posts
    4

    Unanswered: MySQL has run out of memory

    I've created a PHP web application in Dreamweaver, which uses a MySQL database, containing 14 tables.

    On one page, I use an SQL query to select data from 10 of the tables in the database.

    However, when I try to preview the page in a browser, a PHP warning stating that the MySQL engine has run out of memory.

    Is there a way of increasing the Memory Cache of the engine, or a way to optimize the performance?

    I am testing locally and will be hosted on our existing internal server, for internal users only. The internal server has the same Apache, PHP and MySQL set up as my local installation.

    I don't know how to adjust the settings to increase the memory size, cache or idle time (if this is the problem).

    I'm also not sure how to backup my SQL database to upload, along with my PHP code, to something like RapidShare for you guys to take a look at.

    I hope someone can help on this as it will help me out tremendously!

    Cheers

    Samuel

  2. #2
    Join Date
    Mar 2004
    Posts
    480
    You would give us a better idea of how you are querying the tables. Perhaps there is something you are doing that is taking up memory when it isn't needed.

    are your tables indexed? are you making efficient queries where you are using JOINs or UNIONs?

  3. #3
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by guelphdad
    are you making efficient queries where you are using JOINs or UNIONs?
    that's the problem, the joins weren't done properly, and he was getting humoungous cross join effects

    see this thread on that other forum

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •