Thanks Jorge. <div class="gmail_quote">2009/9/16 Jorge Armando Medina <<a href="mailto:jmedina@e-compugraf.com">jmedina@e-compugraf.com</a>> <blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> <div class="im">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? </div>Probably this video can help you: Performance Tuning Best Practices for MySQL <a href="http://www.youtube.com/watch?v=u70mkgDnDdU" target="_blank">http://www.youtube.com/watch?v=u70mkgDnDdU</a> <div class="im"> > > any advice, suggestion is appreciate...... > > thanks > > -- > i'm > Soon Siang, Shio > [please ping me at:] <a href="mailto:ahsiangsiang@gmail.com">ahsiangsiang@gmail.com</a> </div>> <mailto:<a href="mailto:ahsiangsiang@gmail.com">ahsiangsiang@gmail.com</a>> <div><div></div><div class="h5">> ------------------------------------------------------------------------------------------------ > 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. > <a href="http://www.gnu.org/philosophy/no-word-attachments.html" target="_blank">http://www.gnu.org/philosophy/no-word-attachments.html</a> > Before printing, please consider the environment. > Be GREEN! > > </div></div>-- Jorge Armando Medina Computación Gráfica de México Web: <a href="http://www.e-compugraf.com" target="_blank">http://www.e-compugraf.com</a> Tel: 55 51 40 72, Ext: 124 Email: <a href="mailto:jmedina@e-compugraf.com">jmedina@e-compugraf.com</a> GPG Key: 1024D/28E40632 2007-07-26 GPG Fingerprint: 59E2 0C7C F128 B550 B3A6 D3AF C574 8422 28E4 0632 -- ubuntu-server mailing list <a href="mailto:ubuntu-server@lists.ubuntu.com">ubuntu-server@lists.ubuntu.com</a> <a href="https://lists.ubuntu.com/mailman/listinfo/ubuntu-server" target="_blank">https://lists.ubuntu.com/mailman/listinfo/ubuntu-server</a> More info: <a href="https://wiki.ubuntu.com/ServerTeam" target="_blank">https://wiki.ubuntu.com/ServerTeam</a> </blockquote></div> -- i'm Soon Siang, Shio a Linux Toy Player [please ping me at:] <a href="mailto:ahsiangsiang@gmail.com">ahsiangsiang@gmail.com</a> [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. <a href="http://www.gnu.org/philosophy/no-word-attachments.html">http://www.gnu.org/philosophy/no-word-attachments.html</a> Before printing, please consider the environment. Be GREEN! ahsiangsiang in .- .... ... .. .- -. --. ... .. .- -. --. morse code ahsiangsiang ASCII code