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?

Request server optimization over at vb.com in the server forum before you do anything at all.

orban,

Thanks for the reply. I will look into that. I can say that my Hardware should more than handle it. A Dell 6650 with 6GB ram and 4 multi-threaded CPUs with multi-threaded apache installed. I am going to move the db to its own machine this week too.

I had vB 3.0 two weeks ago with no problem. Upgraded to 3.6 and the problems started. Is there more overhead now in 3.6?

Oh wow?!

How many users online and how many posts do you have? That's a crazy machine

orban,

Not enough to make this machine sweat but all my users are complaining and I agree with them. It can take 30 seconds to post a message and it has to be MySQL related.

I have about 1.8 million post. On a peak 300 - 400 users.

I have requested support at vB.com and no answers yet.

moondragon, you can run 300-400 users on a much much much smaller machine. Also how large is your db?

There is absolutely no need to move to a two machine setup for these numbers.

orban,

I agree 100%, you wouldn't believe the complaints I am getting now though. I will PM you the URL to see if you see the same "slowness" they are talking about.

My db is about 750MB.

I'm experiencing slowness too, my DB is 920 MB and the DB collection is UTF8,
i've installed xcache+xcache modofication and it helped a little, also the template cache plugin, try those..

which plugins do you have installed?

Zero, I stripped them all to send vB a support ticket. Things seem to be running better now that I have MySQL 5

I would love to browse your site sicne you mentioned it is running on a beast-like machine.

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.

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.

You aren't swapping by any chance are you?

Hey bud, it's still running slow.