Hi,
can you please send me some optimization examples for my.cnf ?
I use mysql 5.1.37
The server run just 2 very busy forums.
It is quad core cpu and 8 giga ram so we have lot of run (run debian)
Can you please give me some examples?
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
--0016e658626a5dd43e0472a920d4
Content-Type: text/plain; charset=ISO-8859-1
Hi Christos,
Performance optimization is very subjective, and if you are experiencing low
performance it can be a million different things. The description you
provided didn't mention any of your current my.cnf settings, nor did it
mention what kind of tables your database contains, size of data, types of
indexes, engines used by your tables etc.
You mention you have a quad core machine running 8G ram .... how much of
that ram is being used by MySQL and how much by other applications? how much
of it is free? What kind of CPU usage are you experiencing, what is the size
of your db, are you logging slow queries and checking for missing indexes?
My.cnf is not a magic box which improves performance by setting a couple of
variables and normally the performance improvements are minimal as compared
to other things like:
1: faster disks
2: normalized and correctly designed db (not in your power I guess)
3: good code in your application (not in your power either)
I'd suggest you read High Performance MySQL 2nd ed which will definitely be
of help.
Sorry for bombarding you with questions but performance tuning is not
something you do by setting a couple of params on my.cnf!
Gluck
Darren
www.mysqlpreacher.com - yet another blog from a mysql dba
www.securich.com - a mysql security plugin
On Thu, Sep 3, 2009 at 10:06 AM, Christos Pelekis
> Hi,
> can you please send me some optimization examples for my.cnf ?
> I use mysql 5.1.37
> The server run just 2 very busy forums.
> It is quad core cpu and 8 giga ram so we have lot of run (run debian)
> Can you please give me some examples?
> Thanks
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=info@mysqlpreacher.com
>
>
--0016e658626a5dd43e0472a920d4--
--000e0cd5cc56aefd300472afee96
Content-Type: text/plain; charset=ISO-8859-1
Well said Darren. Its not magic :)
Christos, you can download and run mysqlreport from
http://hackmysql.com/mysqlreportguide
it will give you more idea about DB serve performance.
On Thu, Sep 3, 2009 at 3:07 PM, Darren Cassar
> Hi Christos,
>
> Performance optimization is very subjective, and if you are experiencing
> low
> performance it can be a million different things. The description you
> provided didn't mention any of your current my.cnf settings, nor did it
> mention what kind of tables your database contains, size of data, types of
> indexes, engines used by your tables etc.
>
> You mention you have a quad core machine running 8G ram .... how much of
> that ram is being used by MySQL and how much by other applications? how
> much
> of it is free? What kind of CPU usage are you experiencing, what is the
> size
> of your db, are you logging slow queries and checking for missing indexes?
>
> My.cnf is not a magic box which improves performance by setting a couple of
> variables and normally the performance improvements are minimal as compared
> to other things like:
> 1: faster disks
> 2: normalized and correctly designed db (not in your power I guess)
> 3: good code in your application (not in your power either)
>
> I'd suggest you read High Performance MySQL 2nd ed which will definitely be
> of help.
>
> Sorry for bombarding you with questions but performance tuning is not
> something you do by setting a couple of params on my.cnf!
>
> Gluck
>
> Darren
>
> www.mysqlpreacher.com - yet another blog from a mysql dba
> www.securich.com - a mysql security plugin
>
> On Thu, Sep 3, 2009 at 10:06 AM, Christos Pelekis
>
> > Hi,
> > can you please send me some optimization examples for my.cnf ?
> > I use mysql 5.1.37
> > The server run just 2 very busy forums.
> > It is quad core cpu and 8 giga ram so we have lot of run (run debian)
> > Can you please give me some examples?
> > Thanks
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> > http://lists.mysql.com/mysql?unsub=info@mysqlpreacher.com
> >
> >
>
--
Best Regards,
Prabhat Kumar
MySQL DBA
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat
--000e0cd5cc56aefd300472afee96--
>-----Original Message-----
>From: prabhat kumar [mailto:aim.prabhat@gmail.com]
>Sent: Thursday, September 03, 2009 1:44 PM
>To: Darren Cassar
>Cc: Christos Pelekis; mysql@lists.mysql.com
>Subject: Re: optimize my.cnf
>
>Well said Darren. Its not magic :)
>
[JS] Actually, its voodoo :)
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
>Christos, you can download and run mysqlreport from
>http://hackmysql.com/mysqlreportguide
>it will give you more idea about DB serve performance.
>
>On Thu, Sep 3, 2009 at 3:07 PM, Darren Cassar
>
>> Hi Christos,
>>
>> Performance optimization is very subjective, and if you are experiencing
>> low
>> performance it can be a million different things. The description you
>> provided didn't mention any of your current my.cnf settings, nor did it
>> mention what kind of tables your database contains, size of data, types of
>> indexes, engines used by your tables etc.
>>
>> You mention you have a quad core machine running 8G ram .... how much of
>> that ram is being used by MySQL and how much by other applications? how
>> much
>> of it is free? What kind of CPU usage are you experiencing, what is the
>> size
>> of your db, are you logging slow queries and checking for missing indexes?
>>
>> My.cnf is not a magic box which improves performance by setting a couple of
>> variables and normally the performance improvements are minimal as compared
>> to other things like:
>> 1: faster disks
>> 2: normalized and correctly designed db (not in your power I guess)
>> 3: good code in your application (not in your power either)
>>
>> I'd suggest you read High Performance MySQL 2nd ed which will definitely be
>> of help.
>>
>> Sorry for bombarding you with questions but performance tuning is not
>> something you do by setting a couple of params on my.cnf!
>>
>> Gluck
>>
>> Darren
>>
>> www.mysqlpreacher.com - yet another blog from a mysql dba
>> www.securich.com - a mysql security plugin
>>
>> On Thu, Sep 3, 2009 at 10:06 AM, Christos Pelekis
>>
>> > Hi,
>> > can you please send me some optimization examples for my.cnf ?
>> > I use mysql 5.1.37
>> > The server run just 2 very busy forums.
>> > It is quad core cpu and 8 giga ram so we have lot of run (run debian)
>> > Can you please give me some examples?
>> > Thanks
>> >
>> >
>> > --
>> > MySQL General Mailing List
>> > For list archives: http://lists.mysql.com/mysql
>> > To unsubscribe:
>> > http://lists.mysql.com/mysql?unsub=info@mysqlpreacher.com
>> >
>> >
>>
>
>
>
>--
>Best Regards,
>
>Prabhat Kumar
>MySQL DBA
>My Blog: http://adminlinux.blogspot.com
>My LinkedIn: http://www.linkedin.com/in/profileprabhat
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org