Too EAProc WaitQ

[Prince]

I have increase to 250 each, i will wait tomorrow to see how my site perform, but my host was againt it. Read his comment below...

"As I've stated before, this is not a good idea, you will most likely just
overrun your box with mysql connections. The reason things are running slow
has nothing to do with the # of connections allowed but the time at which it
takes to execute them. I can tell this to litespeed as well if you like.

Regards,
Chris"

[webizen]

What application are you running on the web server?

[Prince]

Wordpress, SMF forum and a social network.

[Prince]

I solved the the problem by increasing innodb_buffer_pool_size=3G to 6G and max_user_connections=100
max_connections=100 to 300 each.

Now sites running faster, but i have to upgrade ram in my host server.

[webizen]

Thanks for the update.

Do you have any cache enabled at your application level (such as Wordpress, SMF)?

[eva2000]

Originally Posted by Prince

I solved the the problem by increasing innodb_buffer_pool_size=3G to 6G and max_user_connections=100
max_connections=100 to 300 each.

Now sites running faster, but i have to upgrade ram in my host server.

Prince, I use litespeed vps edition on my wordpress blog as well definitely install wordpress plugin w3 total cache, of course with litespeed in use you can disable w3 total cache's options for http gzip file compression in browser cache.

Any reason you set the small file and mmap cache sizes to such a small value as 300 bytes ?

Total Small File Cache Size (bytes)
Total MMAP Cache Size (bytes)

IIRC default is round 20MB (20M) or 40MB (40M)

[Prince]

Originally Posted by webizen

Thanks for the update.

Do you have any cache enabled at your application level (such as Wordpress, SMF)?

YES,
For wordpress i use "quick cache" for SMF i use memcache.

[Prince]

Originally Posted by eva2000

Any reason you set the small file and mmap cache sizes to such a small value as 300 bytes ?

Total Small File Cache Size (bytes)
Total MMAP Cache Size (bytes)

IIRC default is round 20MB (20M) or 40MB (40M)

No reason, i just put in those values randomly.

What values should be there?