MySQL Excessive Usage
By Luke
Hey.
I've had previous problems with excessive CPU usage on my VPS before now, and I finally discovered this was down to the installation of the Black Pod theme, Since removing that things have been fine.
However, I now have excessive MySQL usage on my VPS. My hosting have said that they've cleaned it up a little, but that I should look into this.
I have over 1400 users, use of galleries and video embedding. I also have a forum and WP installed. I don't have hundreds of plugins installed.
In the evenings I have approximately 10 - 20 members on the site at one time.
Is this simply a case of needing a dedicated server, or is there something I can do with MySQL to stop these affects on the server?
Any help appreciated.
Elgg Technical Support
Get support from other Elgg users
- bujji1@bujji1
bujji1 - 0 likes
- Luke@LukePathan
Luke - 0 likes
- Cash@costelloc
Cash - 0 likes
- bujji1@bujji1
bujji1 - 0 likes
You must log in to post replies.Excessive MySQL usage on your VPS for 1400 users ?
1) What elgg version are you using ?
2) What is your VPS configuration ?
Regards
Kiran
Hi,
Using 1.7.2
I'm not sure on VPS config. What would you like to know and how do I find it? lol
Thanks :)
If you're not running the eager widgets, you should. It drastically decreases mysql queries for profile and dashboard pages.
Hi Luke ,
It is about your system RAM and CPU speed .
To get CPU info run this command on shell :- cat /proc/cpuinfo
To get Memory info :- cat /proc/meminfo
As Cash said eager widgets do wonder .
Regards
Kiran