MySQL has run out of memory

**!dahan!** · 07-13-2009, 12:21 AM

::Help needed::

I am new to PHP and MySQL and have come across a problem I have no idea of solving. . . .
I've created a PHP web application in Dreamweaver, which uses a MySQL database, containing 14 tables.
On one page, I use a 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?

**tripy** · 07-13-2009, 04:19 AM

Your problem is not there...
Either your computer have a very low amount of memory (128/256Mo), or your query has missing joins which create an cartesian product.
This means that every rows in every table is matched with every other rows in all the other tables.
You can end up with billions of records with that error, and that would make any server choke, even with 4Go of ram.

Post your db schema and the query here, and we'll look through it.

**twhdir** · 07-13-2009, 07:40 PM

Also make sure that your application is not running MySQL on standard mode. Because standard mode requires more RAM.

**TWD** · 10:11 PM

Can you post the exact errror message?

Are you sure the problem is with MySQL and not PHP?
If its PHP it can be quite easy to increase your memory limit
in the "php.ini" file.

You should talk to your hosting company about it.

**!dahan!** · 07-15-2009, 12:42 AM

Quote:

Originally Posted by TWD

Can you post the exact errror message?

Are you sure the problem is with MySQL and not PHP?
If its PHP it can be quite easy to increase your memory limit
in the "php.ini" file.

You should talk to your hosting company about it.

i have ask the hosting company about it,they haven't solute my questions!
do i need the 4G of stockpile？