The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
|
#1
12-01-2008, 07:33 PM
|
|||
|
|||
Queries clogging MySQL
Here are the queries that they said were running when our MySQL load goes to 100%. I can't really tell what is causing the issue because I don't have a clue what all that means, but it is something that isn't good im sure. Any help would be appreciated.
Quote:
|
|
#2
12-03-2008, 03:29 AM
|
|||
|
|||
|
this shit is driving me insane. i just want it to run smoothly yet i have queries causing a lock up and i cant tell what. im really getting frustrated by all this.
|
|
#3
12-03-2008, 03:56 AM
|
||||
|
||||
|
Do a search in your files for parts of those queries. I assume you have a copy of the full query, so it will be easier for you to search for them and locate the correct ones. But, usually it isn't those queries that are the problem - it's the query performed right before them that locked the tables that is the problem. Check the times on these and see if they show up at the same time - perhaps a cron job/scheduled task is being run that is causing the problem.
|
|
#4
12-03-2008, 04:07 AM
|
|||
|
|||
|
im not sure which files you mean i should do searches in? and is there a good program to do a search in multiple files? i checked my raw access logs and basically i get these
Quote:
and as for the queries, i only have the information they give me. i dont really have access to a lot of stuff (im a semi dedicated). that was just what the techs send me whenever i messaged support. --------------- Added [DATE]1228284748[/DATE] at [TIME]1228284748[/TIME] --------------- sigh. think this is something i could hire someone through the paid services to do? this is just so frustrating. we dont have a high traffic board, but ive invested a lot of time trying to make it run properly. i know im limited at what i can do with a semi dedicated, but there has to be something. maybe a bad table in the database (i used repair and analyze and got nothing)? maybe an old mod gone bad (but ive tried to make sure i remove all lines of code that i changed when i uninstall a mod)
|
|
#5
12-03-2008, 04:16 AM
|
||||
|
||||
|
I use BBEdit to search all files in a folder. That is for a Mac. I've sure there are similar applications for the PC.
And what I was talking about was finding the query so you can figure out what is happening when it's called. You would search for part of the query like "IF(visible = 2, 1, 0) AS isdeleted" (I think that one is from functions.php getting threadinfo). But, as I said, I don't think that will help because those are the queries having problems *because* the table is locked. You need to find out *why* the table is locked and whatever is doing that is doing it right before those queries. So, you should see if you can get the times of the problem queries and see if it is always happening at the same time and then figure out what is going on on your forum at those times. As for /transparent, I would guess it is a modification causing that problem because it isn't a default vbulletin thing. So, you need to look through your plugins for that one (although I think I've seen it mentioned before, so perhaps a search here and reading a few threads will tell you what modification it is).
|
|
#6
12-03-2008, 04:25 AM
|
|||
|
|||
|
Well I went through the scheduled tasks in my admin panel and the only task that was set for more than twice an hour was an RSS deal. I disabled that since I don't have any RSS stuff currently anyways, but it is occurring right now about once every 5 minutes or so. It will do this for around an hour usually (sometimes longer) and then it will run smoothly for a few hours. Sometimes it won't do it for days and a few times even weeks and then sometimes its every other hour.
|
|
#7
12-03-2008, 04:27 AM
|
||||
|
||||
|
How much access to the server do you have? If you are able to change your php.ini and my.cnf, then I would suggest posting on vb.com in the Server Configuration forum to see if they can help fine tune your server.
|
|
#8
12-03-2008, 04:38 AM
|
|||
|
|||
|
Quote:
--------------- Added [DATE]1228286407[/DATE] at [TIME]1228286407[/TIME] --------------- this is what they just posted to me again Quote:
|
|
#9
12-03-2008, 04:47 AM
|
||||
|
||||
|
None of those tell me a thing. Like I said, those are problem queries because the table is locked and thus the queries can't be performed. The real problem is whatever is locking the tables. You need to start noting down the times and what is going on on your forum when this happens and then see if you can figure it out. Basically a near impossible task (believe me, I say that from experience!).
What you might want to do is turn off all your modifications. Leave them off for a couple of days and see if that fixes the problem. Then turn on a modification a day and keep seeing if the problem returns. Maybe that way you can figure out what modification is causing the problem and then disable it for good.
|
|
#10
12-03-2008, 04:55 AM
|
|||
|
|||
|
Ya I have been trying that. I will see what I can find out doing it. I told them that those queries weren't showing anything and if they had more info for me. I will see what I get.
--------------- Added [DATE]1228288183[/DATE] at [TIME]1228288183[/TIME] --------------- and basically ive ruled out that the transparent deal is in any file or template (i found editplus that searches all files in a folder and subfolders) that has to deal with my forum. now i have to check to see about folders in my public_html i suppose
|
 |
«
Previous Thread
|
Next Thread
»
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 12:35 AM.