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 database server, it has
only 2 Gb. mysqld itself is using around 600Mb the rest is used
by the OS mainly for file caching. Since the total size of all
databases is around 1.5 Gb they almost fit in memory and the
server is happily serving around 300 queries/s with 200 concurrent
connections and almost no disk I/O (no reads, just a few write
every 5 seconds).
Hope this helps
--
Joseph Bueno
[EMAIL PROTECTED] wrote:
> 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 of the DB
> daemon?
> The total size of the DB is > 30 GB and several tables are > 4GB.
> --
> -Chris Beck - Coradiant, Inc - Research & Development - +1.514.908.6314-
> -- http://www.coradiant.com - Leaders in Web Performance Optimization --
> ------- This email represents my opinion, not that of Coradiant. -------
> "We do not inherit the Earth from our Ancestors,
> we borrow it from our Children." -- Indian Proverb
>
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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
