Re: MySQL max memory usage on linux/intel

How do I set the cache limit? Any suggestions on optimizing mySQL? At 07:05 PM 11/21/2002 +0100, Joseph Bueno wrote: You can expect that your operating system will use the remaining memory as a file cache that will speed up your databases accesses. We don't have that much memory our dedicated d

Re: MySQL max memory usage on linux/intel

You can expect that your operating system will use the remaining memory as a file cache that will speed up your databases accesses. We don't have that much memory our dedicated database server, it has only 2 Gb. mysqld itself is using around 600Mb the rest is used by the OS mainly for file caching

MySQL max memory usage on linux/intel

Apologies if this is off topic ... please let me know what a more appropriate forum is if so. Quick question: since there is normally a per-process limit of 4GB on 32-bit linux/intel platforms is there any point to installing more than 4gb in an sql server that is only running running 1 instance