Browsing is fast; posting slow - what size does replicatin make sense?

Hello,

I am starting to experience a lag (10 seconds or more) in posting on my forum and I believe it could be due to the amount of traffic at a given time that is on the server trying to post messages. Browsing the forum is quick and most pages load in the time it takes to verbally say "1 - 1,000" so about a second to 2 seconds top.

In your experience at what level do you start to see a need to have two databases? One for inserts and the other for the select queries?

I am running MySQL 4.1.20 and will be upgrading to MySQL 5 soon. Will this help?

[Farcaster]

Offhand, have you tried disabling the option "Automatic Similar Thread Search?" It might help to look at the queries running as well in debug mode to see where the hold up might be.

[orban]

Do you have any news? Have you managed to set up slow query log?

[moondragon13]

Originally Posted by orban

Do you have any news? Have you managed to set up slow query log?

orban,

I have this in the my.cnf file:

[mysqld_safe]
log-error=/var/log/mysqld.log
log-slow-queries=/var/log/mysqldslow.log
pid-file=/var/run/mysqld/mysqld.pid

But it hasn't logged the slow queries and I am showing 8 slow queries now. The good news is I've done some more MySQL tweaking with help from a MySQL focused forum and it seems to be helping. Will keep everyone updated.

[orban]

You aren't swapping by any chance are you?

[mtlcore]

Hey bud, it's still running slow.