Re: Re: RE: performance tunning 4.x

2002-08-31 Thread Victoria Reznichenko
mos, Friday, August 30, 2002, 7:04:25 PM, you wrote: m> At 07:58 AM 8/30/2002, you wrote: >>mos, >>Thursday, August 29, 2002, 5:45:05 PM, you wrote: >> >> >>Start by looking at the MySQL documentation: >> >>http://www.mysql.com/doc/en/Query_Cache.html >> >>Read the entire 6.9 section. >> >> >> >>

Re: RE: performance tunning 4.x

2002-08-30 Thread Paul DuBois
At 11:04 -0500 8/30/02, mos wrote: >At 07:58 AM 8/30/2002, you wrote: >>mos, >>Thursday, August 29, 2002, 5:45:05 PM, you wrote: >> Start by looking at the MySQL documentation: http://www.mysql.com/doc/en/Query_Cache.html Read the entire 6.9 section. It offers quite a bit of i

Re: RE: performance tunning 4.x

2002-08-30 Thread mos
At 07:58 AM 8/30/2002, you wrote: >mos, >Thursday, August 29, 2002, 5:45:05 PM, you wrote: > > >>Start by looking at the MySQL documentation: > >>http://www.mysql.com/doc/en/Query_Cache.html > >>Read the entire 6.9 section. > >> > >>It offers quite a bit of information on how the cache operates, h

Re: RE: performance tunning 4.x

2002-08-30 Thread Victoria Reznichenko
mos, Thursday, August 29, 2002, 5:45:05 PM, you wrote: >>Start by looking at the MySQL documentation: >>http://www.mysql.com/doc/en/Query_Cache.html >>Read the entire 6.9 section. >> >>It offers quite a bit of information on how the cache operates, how >>you should configure it and so on. m>

RE: performance tunning 4.x

2002-08-29 Thread Iikka Meriläinen
Hello, A MySQL developer would be able to answer to these questions more accurately, but I'll try to answer _logically_. So don't bet a million dollars on the correctness of my answer. > >>NOTE: The query cache does not return stale data. When data is modified, > any relevant entries in the que

RE: performance tunning 4.x

2002-08-29 Thread mos
> >Hi, > >Start by looking at the MySQL documentation: >http://www.mysql.com/doc/en/Query_Cache.html >Read the entire 6.9 section. > >It offers quite a bit of information on how the cache operates, how >you should configure it and so on. > > >Regards, >Iikka likka, I read it too but I h

RE: performance tunning 4.x

2002-08-28 Thread Iikka Meriläinen
On Wed, 28 Aug 2002, Sean Hager wrote: > 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 tes

RE: performance tunning 4.x

2002-08-28 Thread Sean Hager
MAIL 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 Ref

Re: performance tunning 4.x

2002-08-28 Thread Iikka Meriläinen
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 bi