On Tue, May 22, 2001 at 06:56:00PM -0700, Nathanial Hendler wrote:
How does one know if their database server needs more memory? I
have several tables around 600,000+ rows that are being joined. I
have 512MB of memory. Is there a rule of thumb, or a good way to
calculate how much memory my database server needs.
Can I run my bigest query through some sort of benchmark to see how
much memory it consumes?
Most queries aren't really memory bound. One of the most helpful
things you can do memory-wise it allocate a good chunk of it for
MySQL's various buffers and caches.
Have a look at the sample configuration files that come with MySQL and
this part of the manual:
http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html
Try adjusting some of the values and see if they have any impact on
the speed of your MySQL server.
You'll also want to look at this:
http://www.mysql.com/doc/S/H/SHOW_STATUS.html
and see how your changes affect reads vs. read_requests for keys and
whatnot.
What have you tried so far? I could probably write several pages on
this, but I'll hold off until I have a bit more of an idea where you
stand now.
Jeremy
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951
MySQL 3.23.29: up 5 days, processed 35,150,514 queries (79/sec. avg)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php