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
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 wrote:
> 1. Find out what is slow
> 2. Fix it
> 3. GOTO 1
>
> On Tue, Aug 31,
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, indexes
1. Find out what is slow
2. Fix it
3. GOTO 1
On Tue, Aug 31, 2010 at 11:13 AM, kranthi kiran
wrote:
> 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 wyn
Sy die't drinkt
Hi All,
In performance tunning what are the steps can follow,please help
me
Thanks & Regards,
Kranthi kiran
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.
>> >>
>> >>
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
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
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>
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
>
>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
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
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
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
14 matches
Mail list logo