Optimizing my.cnf

I have Dell PE2950iii with 16GB of RAM, and 1 Quadcore processor @2.00G.
Installed with MySQL 5.075 on 64bit Ubuntu Jaunty. I have these
parameters in my.cnf:

[mysqld]
key_buffer = 512M
max_allowed_packet = 512M
thread_stack = 4096K
thread_cache_size = 256

myisam-recover = BACKUP
max_connections = 999
table_cache = 2048
thread_concurrency = 100

query_cache_limit = 32M
query_cache_size = 512M

expire_logs_days = 10
max_binlog_size = 100M

skip-innodb
skip-federated

[mysqldump]
quick
quote-names
max_allowed_packet = 512M

[isamchk]
key_buffer = 512M


Is it optimized enough for a high load MySQL server machine? Is there
any suggestion to get more speed and response? TIA




Willy


--
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

Re: Optimizing my.cnf

--00148539421857cc7604753c16f3
Content-Type: text/plain; charset=ISO-8859-1

On Mon, Oct 5, 2009 at 6:12 PM, sangprabv wrote:

> I have Dell PE2950iii with 16GB of RAM, and 1 Quadcore processor @2.00G.
> Installed with MySQL 5.075 on 64bit Ubuntu Jaunty. I have these
> parameters in my.cnf:
>
> blah blah blah...
>
>
This heavily depends on workload. Are you using innodb? etc...

--
Rob Wultsch
wultsch@gmail.com

--00148539421857cc7604753c16f3--

Re: Optimizing my.cnf

As you see on my my.cnf I skip innodb and federated. So I just use
myisam in this case. TIA.



Willy


On Mon, 2009-10-05 at 20:47 -0700, Rob Wultsch wrote:
>
> On Mon, Oct 5, 2009 at 6:12 PM, sangprabv wrote:
> I have Dell PE2950iii with 16GB of RAM, and 1 Quadcore
> processor @2.00G.
> Installed with MySQL 5.075 on 64bit Ubuntu Jaunty. I have
> these
> parameters in my.cnf:
>
> blah blah blah...
>
>
> This heavily depends on workload. Are you using innodb? etc...
>
> --
> Rob Wultsch
> wultsch@gmail.com


--
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

RE: Optimizing my.cnf

If it's a dedicated MySQL server I would increase the key buffer to at
least half the available main memory and leave the rest for filesystem
cache. You'll probably get the biggest performance increase this way.

Cheers,

A

-----Original Message-----
From: sangprabv [mailto:sangprabv@gmail.com]=20
Sent: 06 October 2009 04:57
To: Rob Wultsch
Cc: mysql@lists.mysql.com
Subject: Re: Optimizing my.cnf

As you see on my my.cnf I skip innodb and federated. So I just use
myisam in this case. TIA.



Willy


On Mon, 2009-10-05 at 20:47 -0700, Rob Wultsch wrote:
>=20
> On Mon, Oct 5, 2009 at 6:12 PM, sangprabv wrote:
> I have Dell PE2950iii with 16GB of RAM, and 1 Quadcore
> processor @2.00G.
> Installed with MySQL 5.075 on 64bit Ubuntu Jaunty. I have
> these
> parameters in my.cnf:
> =20
> blah blah blah...
> =20
>=20
> This heavily depends on workload. Are you using innodb? etc...
>=20
> --=20
> Rob Wultsch
> wultsch@gmail.com


--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=3Dandrew.braithwaite@love film.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg