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-7878 Fax: (408) 349-5454 Cell: (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
