On Wed, 2002-09-04 at 11:32, Florin Andrei wrote: > I'm running a database server (MySQL) with quite a few connections: ... > Basically, the system receives data almost constantly over the network, > via a custom daemon that dispatches it and sends it to MySQL. The > database is doing plain INSERT DELAYED's most of the time (although some > occasional SELECT's are issued from Apache/PHP to spice up things every > now and then).
I don't know that 7.3 will offer you much, but if you can simulate the activity, you might want to try porting to PostgreSQL rather than MySQL. MySQL is reputed to perform very poorly with a large number of clients connected, and with a high insert/select ratio, both of which describe your installation. PostgreSQL (might as well run on 7.3, with the latest server version) may offer significant performance improvements. You'll have to do your own benchmarking to find out if that's the case. The only thing that I wonder about is that your load is mostly in the "system". You might get better performance by simply adjusting your read-ahead and write-cache settings. Try to figure out how *much* disk activity is being generated by the server using "vmstat". -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED]?subject=unsubscribe https://listman.redhat.com/mailman/listinfo/redhat-list
