Thanks Jorge. 2009/9/16 Jorge Armando Medina <[email protected]>
> 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 > > > > -- > ubuntu-server mailing list > [email protected] > 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:] [email protected] [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
-- ubuntu-server mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-server More info: https://wiki.ubuntu.com/ServerTeam
