MySQL overheated

[Anon]

Hello, today I wanted to test the amount of messages my phpforum could handle(phpforum.sourceforge.net).

So I inserted 40 000 messages into my MySQL database.

This wasn't smart becase after I did this MySQL CPU usage become 80%-90% of the total CPU power(Celeron 400). And this without even trying to access the database.

I'm running the windows version of MySQL. Anyone know if I'll get the same result on a Linuxbox?

How can I overcome this problem?

[Anon]

Hi!

Tuning the mysql server parameters on Window$!
Read in the manual page (11. Getting maximum performance from MySQL)

mysqld -O key_buffer=16M -O table_cache=256 -O sort_buffer=4M -O record_buffer=1M -O tmp_table_size=4M