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? any advice, suggestion is appreciate...... thanks -- i'm Soon Siang, Shio [please ping me at:] [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!
-- ubuntu-server mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-server More info: https://wiki.ubuntu.com/ServerTeam
