Physical RAM = Database size is not a great rule of thumb. What if your database has 20 gigabytes of data?
But say you have a 3 gigabyte database, and 3 gigabytes of RAM. You can't give all that RAM to the database. The operating system needs a bunch for itself and the processes running. If you try to give all that memory to MySQL (via the my.cnf file), you're machine will be slower, as the OS will claim some of the memory, and MySQL will be forced to use virtual memory (disk) to get all of it's memory - it will be swapping like crazy. Tuning will depend on the OS, and the table type (MyISAM or InnoDB). David. ----- Original Message ----- From: "Berry Sizemore" <[EMAIL PROTECTED]> To: "Hoeven, Maarten van der" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, September 23, 2003 6:37 AM Subject: Re: Amount of memory: rule of thumb > jihad! > > My opinion is memory concerns are bound to operating system. What is > recommended for your OS? > > Best, > Jerry Cornelius > > Hoeven, Maarten van der wrote: > > > Hi all, > > > > Is there a rule of thumb how much internal memory you should install, > > when pursuing maximum performance? A rule of thumb like: "Internal > > memory should be equal or more than the size of the database". Example: > > total database size=3 GB; therefor internal memory should be at least 3 > > Gb. > > > > Is there such a rule of thumb? Of course, I'm ignoring all other > > parameters and settings now for convenience reasons... > > > > > > Greets, > > Maarten > > -------------------------------------------------------------- > > Zie ook/see also: http://www.knmi.nl/maildisclaimer.html > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
