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 article.tittel as title,
article.dato as date,
article.artikkelid as id,
article.picid as pic,
article.ingress as ing,
article.categori as cat,
article.emne as sub,
article.text as text
FROM article,
Article_ref
WHERE article.dato NOW()
AND article.categori = 'nyhetsak'
AND article.artikkelid = Article_ref.artikkelid
AND Article_ref.portalid = $content // --- Here's a php var
for which page we are on.
ORDER BY article.dato DESC
LIMIT 0,15
I read that where statements can be very inefficient. I feel I have a
lot of where conditions in my query.
The output from the EXPLAIN select In the extra field it says:
where used; Using temporary; Using filesort These are three drawbacks
of my query?
-Original Message-
From: Yasuo Ohgaki [mailto:[EMAIL PROTECTED]]
Sent: 9. april 2002 17:14
To: Trond Erling Hundal
Subject: Re: Mysql and memory issue
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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
