In the Ziff Daveis eWeek benchmark http://www.eweek.com/article/0,3658,s=708&a=23115,00.asp )I noticed the following:
MySQL's great performance was due mostly to our use of an in-memory query results cache that is new in MySQL 4.0.1. When we tested without this cache, MySQL's performance fell by two-thirds. I couldn't find any information in the online document on how to configure this in-memory query results chache. Can anyone point me to some information on how to do this? sean. > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of > Iikka Meriläinen > Sent: Wednesday, August 28, 2002 8:37 AM > To: Sean Hager > Cc: mySQL (E-mail) > Subject: Re: performance tunning 4.x > > > Hello, > > Yes, there are lots of good documentation: > First, the official MySQL Technical Reference, Section 5 at > http://www.mysql.com/doc/en/index.html > Then scroll down to "5 MySQL Optimisation" and read those. > > Also, check this: > http://www.devshed.com/Server_Side/MySQL/Optimize/page1.html > It's a bit older, but still useful. > > And finally, use www.google.com. :-) > > Regards, > Iikka > > On Wed, 28 Aug 2002, Sean Hager wrote: > > > Are there any documents on how to performance tune mySQL 4.x? > > > > sean. > > > > > > > > > --------------------------------------------------------------------- > > 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 > > > > ****************************************** > * Iikka Meriläinen * > * E-mail: [EMAIL PROTECTED] * > * Vaala, Finland * > ****************************************** > > > --------------------------------------------------------------------- > 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