Although i have a fine running Percona mysql server ver.5.5, but almost daily when the concurrent connections exceed 100 or even closer to that figure, My CPU starts to tremble
I am not sure what settings in the configuration do i need to tweak so that it can sustain these many or more users with ease.
My Server configuration is as follows :-
Release | CentOS release 6.4 (Final)
Kernel | 2.6.32-358.6.1.el6.x86_64
Processors | physical = 2, cores = 12, virtual = 24, hyperthreading = yes
Models | 24xIntel® Xeon® CPU E5-2630 0 @ 2.30GHz
Memory | 47.1G
Also the memory is almost consumed by the server in a couple of days after a weekly server restart. There is hardly any thing left.
But, my main concern is the CPU, If anybody could suggest something ?