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:] [email protected] > <mailto:[email protected]> > ------------------------------------------------------------------------------------------------ > 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: [email protected] GPG Key: 1024D/28E40632 2007-07-26 GPG Fingerprint: 59E2 0C7C F128 B550 B3A6 D3AF C574 8422 28E4 0632
signature.asc
Description: OpenPGP digital signature
-- ubuntu-server mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-server More info: https://wiki.ubuntu.com/ServerTeam
