What OS are you using?
Linux 2.4.20.
> 'top' shows that mysqld is using 264M of memory. So I presume the rest is > used for disk caching. How do I know for sure that mysql is using the rest > of the memory, or how do I get mysql to use it all?
That seems fine we are using about the same.
> Would an extra gig of memory help mysql, or linux, to be faster? Will MySQL > put it's tables in the extra memory so it won't have to read from disk > anymore?
We are running on a Gig of RAm with the smae size of DB so I doubt it.
But if we have 2Gb of memory, instead of 1Gb, Linux could use more memory to cache the disk, so it could store more queries in cache, rather than to get them from the disk again, right? The more memory Linux uses for buffering, the less it has to get from disk..
> What I *really* need to know, is would our server get quicker from > installing an extra 1Gb of ram, before we take the chance and purchase the > expensive PC800-RIMMS.
If you could provide me with your MySQL version and your OS I can advise a bit
more.
MySQL 3.23.55, Linux 2.4.20.
We had major problems with slow mysql up until a few days ago which we have now solved, depending on your set up I could help out.
Cheers John Wards SportNetwork.net
--------------------------------------------------------------------- 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
Systems Administrator Rockingstone IT
--------------------------------------------------------------------- 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
