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?

[orban]

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

[moondragon13]

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?

[orban]

Oh wow?!

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

[moondragon13]

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.

[orban]

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.

[moondragon13]

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.

[Yellow Slider]

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?

[moondragon13]

Originally Posted by Yellow Slider

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

[mtlcore]

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