RE: Performance Tunning

2010-08-31 Thread kranthi kiran
Hi All, In performance tunning what are the steps can follow,please help me Thanks Regards, Kranthi kiran

Re: Performance Tunning

2010-08-31 Thread Johan De Meersman
1. Find out what is slow 2. Fix it 3. GOTO 1 On Tue, Aug 31, 2010 at 11:13 AM, kranthi kiran kranthikiran@gmail.comwrote: Hi All, In performance tunning what are the steps can follow,please help me Thanks Regards, Kranthi kiran -- Bier met grenadyn Is als mosterd by den

Re: Performance Tunning

2010-08-31 Thread Jangita
On 31/08/2010 12:23 p, Johan De Meersman wrote: 1. Find out what is slow 2. Fix it 3. GOTO 1 Good one Johan, Performance tuning depends alot on your table types, your server, the version of MySQL, how you client applications access your database, the size of your data, type of queries,

Re: Performance Tunning

2010-08-31 Thread Johnny Withers
So, it's not just me that is stuck in this infinite loop? I thought I had gone mad! -- - Johnny Withers 601.209.4985 joh...@pixelated.net On Tue, Aug 31, 2010 at 5:23 AM, Johan De Meersman vegiv...@tuxera.bewrote: 1. Find out what is slow 2. Fix it 3. GOTO 1 On

RE: Performance Tunning

2010-08-31 Thread Gavin Towey
This is a good place to start: https://launchpad.net/mysql-tuning-primer -Original Message- From: Johnny Withers [mailto:joh...@pixelated.net] Sent: Tuesday, August 31, 2010 5:38 AM To: Johan De Meersman Cc: kranthi kiran; mysql@lists.mysql.com Subject: Re: Performance Tunning So, it's

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

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