PDA

View Full Version : High Server Load


FockerFGAA
18 Jun 2008, 21:44
So I have had issues with high server load recently and I have gone through some of the settings in vbulletin to help with that. I then did the datastore change that is supposed to help it. I installed the microstats mod and this is what it says on the bottom of my page

Page generated in 0.20690 seconds with 14 queries [Server Loads: 6.47 4.77 : 5.78]

Now I am not an expert, but that seems to be a high amount of server load and queries. I am just looking at the best ways to decrease my server load so I can run quicker and with less downtime. I am pretty new to all this so if there is more information (like what queries I am running) I will admit I will probably need some help in figuring out how to provide that information.

My forum is just a small forum with a small amount of users, but I want to keep the board up as often as possible to keep them happy.

Paul M
18 Jun 2008, 21:46
Are you on a shared server ? if so then those load figures are for all sites on the server, not just yours.

FockerFGAA
18 Jun 2008, 22:05
I am. Is there a way to see just my share of the server load?

Jase2
18 Jun 2008, 22:18
No, there isn't. Sorry. You could always try asking your host.

FockerFGAA
18 Jun 2008, 23:18
Right I understand. Now what about the queries. Were those just my queries from my site, or was that overall as well? If they were for my site only did that seem kind of high or just normal?

Eikinskjaldi
19 Jun 2008, 02:02
Right I understand. Now what about the queries. Were those just my queries from my site, or was that overall as well? If they were for my site only did that seem kind of high or just normal?

The server load is an average for all CPU activity on your server for 3 time periods (1 minute, 5 minute, 15 minute from memory)

the query count is how many queries that page needed.
In other words, there is not much connection between the two stats.

14 queries is fine. I have pages that call alot more.

geevest.com
19 Jun 2008, 03:19
i take dedicated server for this.but my issue never complete.

Dismounted
19 Jun 2008, 08:46
Please do not hijack other people's threads - start your own.

geevest.com
24 Jun 2008, 20:59
okay im sorry sir.

txspaderz
26 Jun 2008, 03:23
I think you can use the 'top' command to view processes jailed to your shared account through shell.

Dismounted
26 Jun 2008, 08:22
But most shared hosts will not let you access SSH ;).

FockerFGAA
26 Jun 2008, 16:48
so i contacted them and they said that mysql is consuming the bulk of the cpu and most of the queries running currently are from my account. this is what they posted to me (i didnt see ne sensitive material to edit out of this)

| Id | User | Host | db | Command | Time | State | Info
+------+-----------------+-----------+----------------+---------+------+--------------+------------------------
| 8325 | fvsports_Focker | localhost | fvsports_forum | Query | 17 | Sending data | SELECT
thread.threadid
FROM footballthread AS thread
INNER JOIN footballpost AS p |
| 8355 | fvsports_Focker | localhost | fvsports_forum | Query | 8 | Locked | UPDATE footballpost SET
showsignature = 1,
allowsmilie = 1,
title = 'Re: People from www.SPORT |
| 8370 | fvsports_Focker | localhost | fvsports_forum | Query | 2 | Locked | SELECT postid
FROM footballpost AS post

WHERE threadid = 67161
AND visible = 1

|
| 8377 | fvsports_Focker | localhost | fvsports_forum | Query | 3 | Locked | SELECT postid
FROM footballpost AS post

WHERE threadid = 67712
AND visible = 1

|
| 8379 | fvsports_Focker | localhost | fvsports_forum | Query | 2 | Locked | SELECT post.*,
IF(visible = 2, 1, 0) AS isdeleted,


editlog.userid AS edit_userid, editlog |
| 8383 | fvsports_Focker | localhost | fvsports_forum | Query | 1 | Locked | SELECT post.*,
IF(visible = 2, 1, 0) AS isdeleted,


editlog.userid AS edit_userid, editlog |
| 8386 | root | localhost | | Query | 0 | | show processlist

Josh1
27 Jun 2008, 07:30
You're going to want to switch to a dedicated server if you are topping the Shared Hosts MySQL resources list. Same thing happened with me, running a forum/site that will query every single time someone accesses a page will kill a shared server with hundreds of other accounts on the server.

P.S: Your site looks fantastic!

FockerFGAA
27 Jun 2008, 18:32
Thanks for the compliment :)

Ya, we are supposed to be on a semi-dedicated account so there should be less users on the server, but we seem to top the resources consistently. I have looked over the options to reduce server load and the only thing I haven't changed was "show users online" on the main forum page. outside of that I have changed all the others to be off. will not showing the online users really make that much of a difference? It is just hard for me to justify jumping from 30 dollars a month to 80+ dollars a month when we are running around 30-40 users online at a given time.