List:General Discussion« Previous MessageNext Message »
From:Sean Hager Date:August 28 2002 2:04pm
Subject:RE: performance tunning 4.x
View as plain text  
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: imerilai@stripped
> [mailto:imerilai@stripped]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 <mysql-thread118204@stripped>
> > To unsubscribe, e-mail
> <mysql-unsubscribe-Iikka.Merilainen=pato.vaala.fi@stripped>
> > Trouble unsubscribing? Try:
> http://lists.mysql.com/php/unsubscribe.php
> >
>
> ******************************************
> * Iikka Meriläinen                       *
> * E-mail: Iikka.Merilainen@stripped *
> * 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 <mysql-thread118207@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-rudy.metzger=pareto.nl@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


Thread
performance tunning 4.xSean Hager28 Aug
  • Re: performance tunning 4.xIikka Meriläinen28 Aug
    • RE: performance tunning 4.xSean Hager28 Aug
      • RE: performance tunning 4.xIikka Meriläinen28 Aug
        • RE: performance tunning 4.xmos29 Aug
          • Installing mysql 4.0.3 with linux threads on freebsdVarshavchick Alexander29 Aug
            • Re: Installing mysql 4.0.3 with linux threads on freebsdDan Nelson29 Aug
              • Re: Installing mysql 4.0.3 with linux threads on freebsdVarshavchick Alexander30 Aug
            • limiting the userSoheil Shaghaghi30 Aug
              • limiting the userSoheil Shaghaghi1 Sep
                • RE: limiting the userDean Harding1 Sep
          • RE: performance tunning 4.xIikka Meriläinen29 Aug
          • Re: RE: performance tunning 4.xVictoria Reznichenko30 Aug
            • Re: RE: performance tunning 4.xmos30 Aug
              • Re: RE: performance tunning 4.xPaul DuBois30 Aug
              • Re: Re: RE: performance tunning 4.xVictoria Reznichenko31 Aug