You can use server parameters see capter 10.1 Tuning server parameters. and any other for maximum performance.
we use mail server, http server, app. server, on pentium 1 GHz, 800 MB of ram, nothing problem. Ady Wicaksono([EMAIL PROTECTED])@Thu, Nov 29, 2001 at 06:54:32PM +0700: > > Hi guys, i have 256 RAM and dual Pentium III > This machine will run mail server, web server, and database MySQL server > there's CGI Application that use MySQL server WITHOUT persistent connection - > uh... the lack of my CGI Application > > > What is the best configuration of my.cnf if : > > there will be 250 hit, concurrent access every 2 seconds > HTTP (using Apache) start run with 200 Daemon > MailServer use about 100 Thread -- __ (oo) Open Solution Provider visit http://www.trabas.com / \/ \ GnuPg public information pub 1024/EBD26280 `V__V' A9A9 8F57 9E9D 14E3 05B4 3EDB C241 A313 EBD2 6280 You never hesitate to tackle the most difficult problems. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php