mysql performance tuning on 64 bit hardy

[Jorge Armando Medina]

ahsiangsiang wrote:
> 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?
Probably this video can help you:

Performance Tuning Best Practices for MySQL
http://www.youtube.com/watch?v=u70mkgDnDdU


>
> any advice, suggestion is appreciate......
>
> thanks
>
> -- 
> i'm
> Soon Siang, Shio
> [please ping me at:] ahsiangsiang at gmail.com
> <mailto:ahsiangsiang at gmail.com>
> ------------------------------------------------------------------------------------------------
> Promoting:
> 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
> and
> *please AVOID sending me Word or PowerPoint attachments.
> http://www.gnu.org/philosophy/no-word-attachments.html
> Before printing, please consider the environment.
> Be GREEN!
>
>


-- 
Jorge Armando Medina
Computación Gráfica de México
Web: http://www.e-compugraf.com
Tel: 55 51 40 72, Ext: 124
Email: jmedina at e-compugraf.com
GPG Key: 1024D/28E40632 2007-07-26
GPG Fingerprint: 59E2 0C7C F128 B550 B3A6  D3AF C574 8422 28E4 0632


-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 252 bytes
Desc: OpenPGP digital signature
URL: <https://lists.ubuntu.com/archives/ubuntu-server/attachments/20090915/203567c4/attachment.pgp>