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. It offers quite a bit of

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 I read

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, how you should

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 information on how the

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 have a

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 query

performance tunning 4.x

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

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 bit

RE: performance tunning 4.x

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

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=708a=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