Well, finally I have launched full blown MySQL database. Speed is amazing (in comparison with our previous monogenous M$Access database). I am now tuning MySQL (3.23.30 on RH7.0/ PIII300 Dell server with 128RAM) server via my.cnf So far here is what I got: 1. ANSI mode tables 2. logs are off 3. no slave I need ideas!?!? I looked at the manual (and Paul DUBois book), but I really need more insight from people who have mission critical productions systems running. Database is not too large. 12 tables with about 10000 rows each and an average of 10 columns each. Lots of reads, sorts and joins. Inserts, adds and deletes comprise about 5 percent of all activities, and a staff of very impatient non tech savyy associates (hey they'd rather play Win98 tetris). Any ideas would be appretiated. I really would like to set this server and forget about it (just like after my switch from NT to RH6 and RH7.0 later). I can't remember the last time I had to reboot the server. Thanks -- --------------------------------------------------------------------- Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php
Anyone got suggestions for tuning MYSQL (my.cnf suggestion request)
Apolinaras Apollo Sinkevicius - Carmel Music & Entertainment Wed, 10 Jan 2001 21:13:55 -0800
