MySQL client run out of memory!! ( 6 Views )

1. Sometimes I get this error on my site: MySQL client run out of memory
   
   Site: raioo.com
   This is the host's versions:
   
   PHP Version4.3.2Mysql Version4.0.18-standard
   
   The site have been working fine for a long time, until recently. I contacted the host, they said they were aware of some issues. Next day I was able to view the site properly. A week later I started seeing the message intermittently, or I would see parts of the page, and some other parts supposed to be queried from the database missing.
   
   I think the mysql client memory is obviousely running out of memory. Now my question is there anything I can do on my side (PHP) to aleviate this problem? I have a habit of opening databse connections, perform the SQL query.. but neglect to close the connections. Is there a better practice to connecting to the mySQL database?
   
   Thanks.
   
   
   (þule, Greenland)


2. You think it might be something in the code? Like an infinite loop?
   BTW, by mySQL client, what do you mean? phpMyADMIN/a webpage, mysql(command-line tool), etc.?
   
   
   (levent, South Georgia and the South Sandwich Islands)


3. Quote:

   Originally Posted by colinr You think it might be something in the code? Like an infinite loop? BTW, by mySQL client, what do you mean? phpMyADMIN/a webpage, mysql(command-line tool), etc.?

   No I don't think it's an infinite loop, I reviewed my code carefully. When I get the MySQL client run out of memory message it's on a web page, not phpMyAdmin.
   
   This is driving me crazy and the web page host is NOT helpful. Do you folks think it has to do with database connections since these are expensive in terms of memory? If you think there is a possibility, how can I improve connecting to the database? I know there is a few methods to connect to the database and each has pros and cons. Connection pooling reduces the frequency at which I connect to database, how do I enable that in my PHP statement? any other ideas?
   
   
   (bahadir, Northern Mariana Islands)

Related Topics ... (or search in 1.720.883 topics !)