MySQL Performance: MySQL => Revise my.cnf for best performance

Members

Help

Home

Home » Performance » MySQL » Revise my.cnf for best performance

Show: Today's Messages :: Show Polls :: Message Navigator

Revise my.cnf for best performance [message #5276]

Wed, 20 January 2010 07:32

giro
Messages: 1
Registered: January 2010

Junior Member

Hi all,

Hi have a website with a MyIsam Database with 10 millon records, and 50 tables.

I have an Avg of 600 query by second.

My server is a 2 x Opteron 2352(2 x 4 x 2,1 GHz) with 16 GB ram

This is my.cnf file:

[mysqld]
set-variable=local-infile=0
set-variable=max_connections=600
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
long_query_time = 1
thread_cache_size = 50
log-slow-queries = /var/log/mysql-slow.log
query_cache_type = 1
query_cache_size = 26214400
key_buffer_size = 1500M
table_cache = 400
sort_buffer_size=4M
read_buffer_size=1M

You change any?

Thanks!!!
Giro.

Report message to a moderator

Re: Revise my.cnf for best performance [message #5277 is a reply to message #5276 ]

Wed, 20 January 2010 14:45

gmouse
Messages: 155
Registered: July 2009

Senior Member

There is no general best my.cnf for your hardware. Let someone look at it if you have performance issues. Pm me if interested, or hire someone from percona.

Report message to a moderator

Previous Topic:	SphinxSE on MySQL 5.1.42 and Sphinx 0.9.9
Next Topic:	MySQL 5.1 RPM's

Goto Forum:

-=] Back to Top [=-

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [

]

Current Time: Sat Mar 13 13:16:19 EST 2010

Total time taken to generate the page: 0.10198 seconds

.:: Contact :: Home ::.

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.