Prosper just isn't cutting it, I need something that cna handle alot of traffic

[heavyt]

Prosper and the way the db is locking tables is bottle necking my setup. I need something that can handle xx,xxx clicks an hour. Does anyone recommend anything that can provide the same stats as prosper but can handle tons of traffic?

 

[parrot head]

... ? statsjunky maybe

 

[erect]

Is prosper on a dedicated with decent specs with no cpanel? I'd be surprised if it bottle-necked that quickly.

 

[heavyt]

yeah prosper server is a quad hapertown with 6gb ram and scsi drives, lp server is the same, and the db server is a quad harpertown with 8gb ram and 4 ssd's in raid 5.

 

[heavyt]

during the traffic spike I sent it was doing 900 queries a second, prosper has a table locking problem with it inserts which was driving the db server load up to 75 while the web servers were .5

Does prosper support innodb?

 

[texic]

Are you taking advantage of the Memcache support?

 

[jvincent]

mysql is notoriously shitty. you could probably at least somewhat easily modify 202 to use a much higher performance db. also, tweak your mysql to do as much as it can in-memory, and dump out to disk only when it has a chance. that alone will help a shitton, disk i/o is a cpu monster and massive bottleneck for any db

 

[heavyt]

yep using memcache

 

[Webferret]

mysql is notoriously shitty. you could probably at least somewhat easily modify 202 to use a much higher performance db. also, tweak your mysql to do as much as it can in-memory, and dump out to disk only when it has a chance. that alone will help a shitton, disk i/o is a cpu monster and massive bottleneck for any db

use flat files. It's the future. I've seen it.

 

[texic]

I'd either pm wes or go to the 202 forums and post. They might have some suggestions.

 

[heavyt]

yeah talking with him now gonna see fi he can do some custom stuff for some donations or something.

 

[heavyt]

had me remove all the locations tables for flags and that brought it way down

 

[strategic]

Why don't you move to tracking202?

 

[AdHustler]

after he helps you, maybe you should donate some bucks to their fundraiser.

 

[heavyt]

I did, I donated 300 to him and nobody has donated since

 

[heavyt]

Why don't you move to tracking202?

their servers won't handle it I already talked to wes about it

 

[andyt]

If it's still too slow and locking on the inserts you could remove all the indexes from the slow inserts and setup a db replication server which has the indexes. Then setup the reporting part of prosper to run off the replicated db server. Congrats on all the traffic. I've never come close to having a problem like that.

 

[Grant29]

Have you tweaked your my.cnf file to take advantage of all the ram? I assume with that much ram you are using 64 bit OS and 64-bit mysql.

Take a look at MySQLTuner - MySQLTuner. The tool is amazing for helping tweak your query cache, open file limits, # of connections etc. The tool will analyze your current transaction data to determine the best settings. Your server needs to be up for at least 24 hours before mysqltuner can give the best setting.

Maybe your settings just need to be tweaked.

If it's the table locking, ask Wes if you can change the table to innodb. I think you can change the table type on the fly, but it will take some time to rebuild. innodb has it's own set of variables that would need to be tweaked too.