Magnum I.P.

Members
  • Content count

    137
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Magnum I.P.

  • Rank
    mad 1337

Contact Methods

  • AIM
    magnumip1
  • Website URL
    http://magnumip.org
  • ICQ
    0

Profile Information

  • Location
    Delaware
  1. Well $30 a month is not bad at all for a low end server from ServerPronto. I can't seem to find anything around that price. I don't want them to have to pay a lot for a Dedicated server. If money wasn't an issue i would go with caro.net.
  2. All this DB talk makes me excited to learn more about it from Stankdawg on HPR.
  3. riscphree is correct.. And did I get this straight, you're seeing a 92 load average? Ouch. Also, a VPS might not help as it's another way to "share" load on one machine. Hence "Virtual" Private server.... Yeah 92 load average when they shut off the DB on the mysql server. When they were with their previous host, they had the DB on the web server instead of on a separate server like dreamhost. So what you are saying is they might have to go with a Dedicated server instead of a VPS? They are looking into ServerPronto now to see if its a good idea to switch hosts again. # Categories: 14 # Discussions: 2914 # Comments: 114785 # Users: 385 # Unique Guests: 56161 That's the stats from the site as of today. It doesn't seem that big to me so I can't understand how it managed to put a load of 92 on the mysql server
  4. What is a good place to get a VPS or Dedicated server for cheap? ServerPronto looks good (and cheap). All it's going to be used for is a website, forums, and maybe storing video/audio files. Not sure how much bandwidth the site would use though
  5. Well i think that maybe the case. Their previous host was a dedicated server till the last month when it got downgraded to a shared host but they never ran into this problem till moving to dreamhost. They might just have the DB hosted somewhere else or upgrade to VPS
  6. Well I have it an exact copy of the forums and DB running on a old p3 with 512MB using ubuntu server 7.10. So far with normal use from like 6 people logged in at a time, the load is under 0.6. It peaked when i had someone load 10 tabs and i did the same. I got 1 error that showed up on mtop for a query that had a time of 30 but i am not sure if its because I am running this on a low end machine and cable internet. I tried to recreate the same error but it never happened again. We are still stumped as to how my low end machine is not even peaking past 4 on the server side and 2 on the mysql side. Could it be that because the DB and the forums are on the same server that it doesn't hit that hard? would it hit harder if the 2 were on 2 seperate shared hosts?
  7. I will ask him that. Here are some of the queries that are causing the strain if it helps. Here is a second or so worth of queries below for reference. 114859 Query select t.DiscussionID as DiscussionID, t.FirstCommentID as FirstCommentID, t.AuthUserID as AuthUserID, t.WhisperUserID as WhisperUserID, t.Active as Active, t.Closed as Closed, t.Sticky as Sticky, t.Sink as Sink, t.Name as Name, t.DateCreated as DateCreated, t.LastUserID as LastUserID, t.DateLastActive as DateLastActive, t.CountComments as CountComments, t.CategoryID as CategoryID, u.Name as AuthUsername, lu.Name as LastUsername, c.Name as Category, b.DiscussionID is not null as Bookmarked, utw.LastViewed as LastViewed, coalesce(utw.CountComments, 0) as LastViewCountComments from LUM_Discussion t left join LUM_User u on t.AuthUserID = u.UserID left join LUM_User lu on t.LastUserID = lu.UserID left join LUM_Category c on t.CategoryID = c.CategoryID left join LUM_CategoryRoleBlock crb on t.CategoryID = crb.CategoryID and crb.RoleID = 6 left join LUM_UserBookmark b on t.DiscussionID = b.DiscussionID and b.UserID = 60 left join LUM_UserDiscussionWatch utw on t.DiscussionID = utw.DiscussionID and utw.UserID = 60 where (crb.Blocked = '0' or crb.Blocked = 0 or crb.Blocked is null ) and t.DiscussionID = '1602' and (t.WhisperUserID = '0' or t.WhisperUserID = 0 or t.WhisperUserID is null ) 114859 Query update LUM_UserDiscussionWatch set CountComments='545', LastViewed='2008-01-10 12:37:22' where UserID = '60' and DiscussionID = '1602' 114859 Query select count(m.CommentID) as Count from LUM_Comment m inner join LUM_Discussion t on m.DiscussionID = t.DiscussionID where (m.Deleted = '0' or m.Deleted = 0 ) and (m.WhisperUserID = '0' or m.WhisperUserID = 0 or m.WhisperUserID is null ) and m.DiscussionID = '1602' 114859 Query select m.CommentID as CommentID, m.DiscussionID as DiscussionID, m.Body as Body, m.FormatType as FormatType, m.DateCreated as DateCreated, m.DateEdited as DateEdited, m.DateDeleted as DateDeleted, m.Deleted as Deleted, m.AuthUserID as AuthUserID, m.EditUserID as EditUserID, m.DeleteUserID as DeleteUserID, m.WhisperUserID as WhisperUserID, m.RemoteIp as RemoteIp, a.Name as AuthUsername, a.Icon as AuthIcon, r.Name as AuthRole, r.RoleID as AuthRoleID, r.Description as AuthRoleDesc, r.Icon as AuthRoleIcon, r.PERMISSION_HTML_ALLOWED as AuthCanPostHtml, e.Name as EditUsername, d.Name as DeleteUsername, t.WhisperUserID as DiscussionWhisperUserID, w.Name as WhisperUsername, a.Preferences as AuthUserPrefs from LUM_Comment m inner join LUM_User a on m.AuthUserID = a.UserID left join LUM_Role r on a.RoleID = r.RoleID left join LUM_User e on m.EditUserID = e.UserID left join LUM_User d on m.DeleteUserID = d.UserID inner join LUM_Discussion t on m.DiscussionID = t.DiscussionID left join LUM_User w on m.WhisperUserID = w.UserID left join LUM_CategoryRoleBlock crb on t.CategoryID = crb.CategoryID and crb.RoleID = 6 where (crb.Blocked = '0' or crb.Blocked = 0 or crb.Blocked is null ) and (m.Deleted = '0' or m.Deleted = 0 ) and (m.WhisperUserID = '0' or m.WhisperUserID = 0 or m.WhisperUserID is null ) and m.DiscussionID = '1602' order by m.DateCreated asc limit 540, 20 114859 Query SELECT CategoryID, Cat_filter FROM LUM_Category 114859 Query SELECT Priority FROM LUM_Role WHERE RoleID=6 114859 Quit 114813 Query select m.CommentID as CommentID, m.DiscussionID as DiscussionID, m.Body as Body, m.FormatType as FormatType, m.DateCreated as DateCreated, m.DateEdited as DateEdited, m.DateDeleted as DateDeleted, m.Deleted as Deleted, m.AuthUserID as AuthUserID, m.EditUserID as EditUserID, m.DeleteUserID as DeleteUserID, m.WhisperUserID as WhisperUserID, m.RemoteIp as RemoteIp, a.Name as AuthUsername, a.Icon as AuthIcon, r.Name as AuthRole, r.RoleID as AuthRoleID, r.Description as AuthRoleDesc, r.Icon as AuthRoleIcon, r.PERMISSION_HTML_ALLOWED as AuthCanPostHtml, e.Name as EditUsername, d.Name as DeleteUsername, t.WhisperUserID as DiscussionWhisperUserID, w.Name as WhisperUsername, a.Preferences as AuthUserPrefs from LUM_Comment m inner join LUM_User a on m.AuthUserID = a.UserID left join LUM_Role r on a.RoleID = r.RoleID left join LUM_User e on m.EditUserID = e.UserID left join LUM_User d on m.DeleteUserID = d.UserID inner join LUM_Discussion t on m.DiscussionID = t.DiscussionID left join LUM_User w on m.WhisperUserID = w.UserID left join LUM_CategoryRoleBlock crb on t.CategoryID = crb.CategoryID and crb.RoleID = 1 where (crb.Blocked = '0' or crb.Blocked = 0 or crb.Blocked is null ) and (m.Deleted = '0' or m.Deleted = 0 ) and (m.WhisperUserID = '0' or m.WhisperUserID = 0 or m.WhisperUserID is null ) and m.DiscussionID = '8' order by m.DateCreated asc limit 3480, 20 080110 12:37:23 114813 Query select m.CommentID as CommentID, m.DiscussionID as DiscussionID, m.Body as Body, m.FormatType as FormatType, m.DateCreated as DateCreated, m.DateEdited as DateEdited, m.DateDeleted as DateDeleted, m.Deleted as Deleted, m.AuthUserID as AuthUserID, m.EditUserID as EditUserID, m.DeleteUserID as DeleteUserID, m.WhisperUserID as WhisperUserID, m.RemoteIp as RemoteIp, a.Name as AuthUsername, a.Icon as AuthIcon, r.Name as AuthRole, r.RoleID as AuthRoleID, r.Description as AuthRoleDesc, r.Icon as AuthRoleIcon, r.PERMISSION_HTML_ALLOWED as AuthCanPostHtml, e.Name as EditUsername, d.Name as DeleteUsername, t.WhisperUserID as DiscussionWhisperUserID, w.Name as WhisperUsername, a.Preferences as AuthUserPrefs from LUM_Comment m inner join LUM_User a on m.AuthUserID = a.UserID left join LUM_Role r on a.RoleID = r.RoleID left join LUM_User e on m.EditUserID = e.UserID left join LUM_User d on m.DeleteUserID = d.UserID inner join LUM_Discussion t on m.DiscussionID = t.DiscussionID left join LUM_User w on m.WhisperUserID = w.UserID left join LUM_CategoryRoleBlock crb on t.CategoryID = crb.CategoryID and crb.RoleID = 1 where (crb.Blocked = '0' or crb.Blocked = 0 or crb.Blocked is null ) and (m.Deleted = '0' or m.Deleted = 0 ) and (m.WhisperUserID = '0' or m.WhisperUserID = 0 or m.WhisperUserID is null ) and m.DiscussionID = '8' order by m.DateCreated asc limit 3500, 20 114813 Query select m.CommentID as CommentID, m.DiscussionID as DiscussionID, m.Body as Body, m.FormatType as FormatType, m.DateCreated as DateCreated, m.DateEdited as DateEdited, m.DateDeleted as DateDeleted, m.Deleted as Deleted, m.AuthUserID as AuthUserID, m.EditUserID as EditUserID, m.DeleteUserID as DeleteUserID, m.WhisperUserID as WhisperUserID, m.RemoteIp as RemoteIp, a.Name as AuthUsername, a.Icon as AuthIcon, r.Name as AuthRole, r.RoleID as AuthRoleID, r.Description as AuthRoleDesc, r.Icon as AuthRoleIcon, r.PERMISSION_HTML_ALLOWED as AuthCanPostHtml, e.Name as EditUsername, d.Name as DeleteUsername, t.WhisperUserID as DiscussionWhisperUserID, w.Name as WhisperUsername, a.Preferences as AuthUserPrefs from LUM_Comment m inner join LUM_User a on m.AuthUserID = a.UserID left join LUM_Role r on a.RoleID = r.RoleID left join LUM_User e on m.EditUserID = e.UserID left join LUM_User d on m.DeleteUserID = d.UserID inner join LUM_Discussion t on m.DiscussionID = t.DiscussionID left join LUM_User w on m.WhisperUserID = w.UserID left join LUM_CategoryRoleBlock crb on t.CategoryID = crb.CategoryID and crb.RoleID = 1 where (crb.Blocked = '0' or crb.Blocked = 0 or crb.Blocked is null ) and (m.Deleted = '0' or m.Deleted = 0 ) and (m.WhisperUserID = '0' or m.WhisperUserID = 0 or m.WhisperUserID is null ) and m.DiscussionID = '8' order by m.DateCreated asc limit 3520, 20 114399 Query select m.CommentID as CommentID, m.DiscussionID as DiscussionID, m.Body as Body, m.FormatType as FormatType, m.DateCreated as DateCreated, m.DateEdited as DateEdited, m.DateDeleted as DateDeleted, m.Deleted as Deleted, m.AuthUserID as AuthUserID, m.EditUserID as EditUserID, m.DeleteUserID as DeleteUserID, m.WhisperUserID as WhisperUserID, m.RemoteIp as RemoteIp, a.Name as AuthUsername, a.Icon as AuthIcon, r.Name as AuthRole, r.RoleID as AuthRoleID, r.Description as AuthRoleDesc, r.Icon as AuthRoleIcon, r.PERMISSION_HTML_ALLOWED as AuthCanPostHtml, e.Name as EditUsername, d.Name as DeleteUsername, t.WhisperUserID as DiscussionWhisperUserID, w.Name as WhisperUsername, a.Preferences as AuthUserPrefs from LUM_Comment m inner join LUM_User a on m.AuthUserID = a.UserID left join LUM_Role r on a.RoleID = r.RoleID left join LUM_User e on m.EditUserID = e.UserID left join LUM_User d on m.DeleteUserID = d.UserID inner join LUM_Discussion t on m.DiscussionID = t.DiscussionID left join LUM_User w on m.WhisperUserID = w.UserID left join LUM_CategoryRoleBlock crb on t.CategoryID = crb.CategoryID and crb.RoleID = 1 where (crb.Blocked = '0' or crb.Blocked = 0 or crb.Blocked is null ) and (m.Deleted = '0' or m.Deleted = 0 ) and (m.WhisperUserID = '0' or m.WhisperUserID = 0 or m.WhisperUserID is null ) and m.DiscussionID = '8' order by m.DateCreated asc limit 12500, 20
  8. still waiting for a response on that. I know so far it has 2332 discussions. not sure on how many users. I thought that maybe when they moved from the 1 host to the other, they didn't do a clean install of the forum software. Could having a DB started in an older mysql be affected if moved to a new version of mysql?
  9. They want to stay with Vanilla software since it works for them. They are going to try and start the forum with all extensions off to see what the strain is. Then go 1 by 1 to see if maybe there is an extension causing the many queries to the DB. Could something have happened when they move from 1 host to Dreamhost and the either the software or DB was not transfered over right? This is part of the email explaining this from Dreamhost top - 12:35:22 up 64 days, 20:40, 2 users, load average: 92.12, 93.85, 81.54 92, a normal load is 1 to 4, so this is a serious overload. After disabling your database the load has indeed dropped down to the normal range. There was a pretty large flood of queries to the server, some large, causing the problems. I don't see a way this site is going to work using the LUM software. If you must use this software then the database needs to be hosted on a VPS or dedicated. If you are willing to change the forum software to one that is more efficient so it can stay on shared hosting, possible solutions are simple machines forum ( free - http://www.simplemachines.org/ ), phpbb ( free - http://www.phpbb.com/ ) or many others that are not free but also popular such as vbulletin. Here is a second or so worth of queries below for reference.
  10. thanks for all the info so far. I will look into what you all said whe I get off work. I'm gonna try and replicate the forums on an old laptop I have to see if I can see what is going on to cause the problems. I will post back with results. I really don't want my friend to have to spend more money than he has to for his forums. I hope with the help of Binrev I can help him out. thanks again for all the help so far guys
  11. I am looking for some advice on why or how to reduce queries to a mysql database for a forum using Vanilla 1.1.4. the database is around 60MB and it is hosted on a shared hosting plan with dreamhost. the load on the server is around 92. the normal usage is around 1 to 4 as said by dreamhost. any ideas on what to do to lower the load on the DB?
  12. Not a bad service for free. I like the ajax webpage for when your logged in to control the conference. The audio for the voice prompts gets a little static but is not that bad. I have only tested it out with 2 people. The call was good and there was hardly and delay.
  13. Just ordered mine. 1 of each. I needed new shirts to wear too. Thanks for doing this Diggy!
  14. ok so i got unreal running but for some reason i cannot get anope working. I have anope installed but when running services, i get a locops link error. I tried a few things in both the services.conf and the ircd.conf and i still can't get it to run. I am running out of ideas where i went wrong. Help? Please?
  15. Awesome! That is what I am looking for. For the meetme manager, all I need installed is php to get this running? what directory do I need to untar this program into? The install instructions are a little vague for me