mysql performance tuning on 64 bit hardy

ahsiangsiang ahsiangsiang at
Mon Sep 14 15:45:36 UTC 2009

Hi Guys,

I have a 64 bit ubuntu server 8.04, HP DL380 G5 with 2 72GB SAS Raid 1 for
OS and 2 146GB SAS Raid 1 for MySQL datastore and 22GB of memory. We plan to
setup the server run as standalone MySQL server (MySQL enterprise 5.1.38)

The data in the server is huge ( EST > 850,000) which the server will serve
> 500 clients.

we will use both MyISAM and InnoDB engine

what is the best my.cnf value to configure for best performance?

any advice, suggestion is appreciate......


Soon Siang, Shio
[please ping me at:] ahsiangsiang at
WiKID Two-factor authentication, without the hassle factor
DSPAM - Just go ahead send me viagra
Ubuntu JeOS "Juicy" - Just Enough Operating System
Postfix - a Wietse Venema's mailer
*please AVOID sending me Word or PowerPoint attachments.
Before printing, please consider the environment.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <>

More information about the ubuntu-server mailing list