You are currently viewing our forum as a guest, which gives you limited access to view most discussions and access our other features. By joining our community, at no cost, you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is free, fast and simple, so please join our community today!
Well unfortunately we are having some performance issues of late, it's related to one SQL query that locks the thread/post table for up to 60 seconds, since a lot of the SQL is created on the fly depending on the page it's very hard to find where the query is being executed from for me to dig through the code.
I have temporarily put a server load limit in at 8, which is pretty high. When the db locks the table the more and more users that try to browse the worse and worse it gets. Until I can find and fix the query hopefully the next few days I'm leaving this in to help try to keep the problem under control.
I know it's a pain but please work with me here, if you have any problems/suggestions/complains please feel free to PM me.
If you guys have a dedicated server, do you run the db from a secondary hard disk? I always found that helped some with sql load issues and disk i/o, even if it's not related to this exact issue.
now it seems like the site is falling apart. The link at the top is cutting in and out
__________________ 2004 Honda CBR 600RR current 2009 Suzuki DL650 V-Strom current 2009 Subaru WRX - current 2011 Nissan Pathfinder 4x4 current 1975 Datsun Fairlady Z RHD Project 2004.5 Nissan 350Z (gone, but not forgotten) 2008.5 Nissan Titan(Goodbye my monster truck)
__________________ 2004 Honda CBR 600RR current 2009 Suzuki DL650 V-Strom current 2009 Subaru WRX - current 2011 Nissan Pathfinder 4x4 current 1975 Datsun Fairlady Z RHD Project 2004.5 Nissan 350Z (gone, but not forgotten) 2008.5 Nissan Titan(Goodbye my monster truck)
Thats funny that a search probably queries the db more than someone responding to a question. Not to mention ten unecessary flame posts telling the poster to search more.
__________________
Originally Posted by HraesvelgYou're ghey, you smell like Kimchi, and were probably that fat Korean kid who beat everyone at Street Fighter in the arcade.
This is a problem for all vbulletin sites after a while, most disable searches, while some setup multiple slaves servers to handle the queries while the normal insert/select's happen on the master server.
Quote:
Originally Posted by scuba_steve
Thats funny that a search probably queries the db more than someone responding to a question. Not to mention ten unecessary flame posts telling the poster to search more.
Can I get some people to test searches, fulltext searches are now on, I had to index the post/thread table it took a while though..
Seems A OK to me
__________________
Quote:
Originally Posted by nbdyfcnsqnc
They're nice dogs, but if I went to a zoo and it just had dogs and a fat hamster I'd feel kind of ripped off. Unless maybe the hamster was like really fat.
Quote:
Originally Posted by Fowlman to his manwhore (AKA:Hraesvelg)
Saw Juno post that and knew you would be on my penis as usual. No one on this board has felt it except you so if you say it is small I guess I'll have to believe you. If it was any bigger so would be your roids. I guess it is all for the best.
# Query_time: 35 Lock_time: 29 Rows_sent: 1 Rows_examined: 0
SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate
) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS display
groupid,
language.phrasegroup_forumdisplay AS phrasegroup_forumdisplay,
language.phrasegroup_inlinemod AS phrasegroup_inlinemod,
language.phrasegroup_global AS phrasegroup_global,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep
FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.
userid) INNER JOIN language AS language ON (language.languageid = IF(user.languageid = 0,
1, user.languageid))
Server too busy messages! Just temporary
