Member Avatar for kool_samule

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 Contributors
  • 1 Reply
  • 176 Views
  • 4 Days Discussion Span
  • Latest Post Latest Post by ferensick
Member Avatar for ferensick

Take a look at this if you have not already:
http://dev.mysql.com/doc/refman/5.1/en/out-of-memory.html

"To remedy the problem, first check whether your query is correct. Is it reasonable that it should return so many rows? If not, correct the query and try again. Otherwise, you can invoke mysql with the --quick option. This causes it to use the mysql_use_result() C API function to retrieve the result set, which places less of a load on the client (but more on the server). "

To easily manage MySQL over the web, try to use PHPMyAdmin. It is very useful. With this you will also be able to easily export or backup your database(s) without having to write the queries manually.

You may not get this error in the 'Production' environment even though you have the same set up. If your internal server has more memory / free space than your testing server then you may not get this error.

I am also curious. What engine are you using? For larger databases you should be using InnoDB. Usually by default MyISAM is used. You can easily change the tables from MyISAM to InnoDB without affecting the records or anything. Please post back if you figured it out and if any of this helped. I hope it does. =)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.