mysql performance tuning on 64 bit hardy

[ahsiangsiang]

Thanks Jorge.

2009/9/16 Jorge Armando Medina <jmedina at e-compugraf.com>

> 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
>
>
>
> --
> ubuntu-server mailing list
> ubuntu-server at lists.ubuntu.com
> https://lists.ubuntu.com/mailman/listinfo/ubuntu-server
> More info: https://wiki.ubuntu.com/ServerTeam
>



-- 
i'm
Soon Siang, Shio
a Linux Toy Player
[please ping me at:] ahsiangsiang at gmail.com
[also at:] +6012-488-3692
------------------------------------------------------------------------------------------------
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!

ahsiangsiang in
.- .... ... .. .- -. --. ... .. .- -. --. morse code
ahsiangsiang ASCII
code
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.ubuntu.com/archives/ubuntu-server/attachments/20090915/57d189ae/attachment.html>