[PHP-DB] Re: Mysql and memory issue

2002-04-10 Thread Yasuo Ohgaki
I really suggest you to take a look at the manual Try http://www.php.net/manual/en/function.mysql-unbuffered-query.php Mail list not suitable to explain about ulimit, mamory manager, etc. (i.e. You may want some books for this) Your query result is exceeding memory limit that the web server

[PHP-DB] RE: Mysql and memory issue

2002-04-10 Thread Trond Erling Hundal
Thanks Yasuo Ohgaki and Gurhan Ozen. My system has 256mb of DDR ram, it's a Intel PIII 900Mhz processor. Ps -aux | grep mysql shows that about all of the mysql connections uses about 15mb of memory. Is that too much? My query fetches 15 records from two tables. Here is the query: SELECT articl

[PHP-DB] Re: Mysql and memory issue

2002-04-09 Thread Yasuo Ohgaki
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-