Re: Mysql and memory issue
| From: | Yasuo Ohgaki | Date: | Wed, 10 Apr 2002 00:14:08 +0000 |
| Subject: | Re: Mysql and memory issue | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-18371@lists.php.net to get a copy of this message | ||
Trond Erling Hundal wrote:
Hi, maybe this list isn't the best place to ask for this but...This is the right place.
I keep getting "memory exhausted" errors from mysql, on a system running as mail/mysql/apache+php server. (rh7.1) Is it my queries that are inefficient? Is it my modelling-scheme that sucks or could it be that mysql is leaking memory in some way? Would it help to move mysql to a separate machine?If you do normal query, mysql store whole result in memory! You can avoid that. It's in the manual. -- Yasuo Ohgaki