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
> 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 g
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 mo
Hi All,
In performance tunning what are the steps can follow,please help
me
Thanks & Regards,
Kranthi kiran
Hi,
FreeBSD 7 should offer much better performance for MySQL. The FreeBSD
kernel developers have found ways to relieve some of the kernel
bottlenecks which permit multithreaded applications to operate much
better.
Regards,
Antony.
On 3 Jun 2008, at 03:43, VeeJay wrote:
Hi Guys
I need
Hi all !
VeeJay wrote:
[[...]]
At my job, I am going to build a Web Server with
1. FreeBSD 7.0-RELEASE amd64
2. Apache 2.2.8
3. PHP 4.4.8 (or may be PHP5, what do you suggest?)
Server's hardware configuration is as follow:
2 x Quad Core Xeon E5450 3.0GHz,2x6MB,1333FSB
16GB (8x2GB Dua
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
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 thr
17 matches
Mail list logo