Slowness in the site
Originally Posted by doug
The database is large.. and alot of people are using the search function that uses alot of resources... during peak times the server will get bogged down from time to time
Thread Starter
Bad Mojo
Joined: Jul 2002
Posts: 2,620
Likes: 1
From: Tokyo, Japan
Yes I found out what the problem is, its a posts that have over 1000 replies and multiple people hitting it at the same time, the query eats up some major resource.
Last edited by GodZilla; May 16, 2006 at 08:50 AM.
Originally Posted by GodZilla
Yes I found out what the problem is, its a posts that have over 1000 replies and multiple people hitting it at the same time, the query eats up some major resource.
Trending Topics
Originally Posted by GodZilla
Yes I found out what the problem is, its a posts that have over 1000 replies and multiple people hitting it at the same time, the query eats up some major resource.
Linky please.
Registered User
Joined: Oct 2005
Posts: 743
Likes: 0
From: Under Snow
Originally Posted by vo7848
Care to share the post? Linky please.
Linky please.Maybe I'm wrong- I was gone for a few days, and when I came back, that great thread was gone...
Lost in Transit
Joined: Oct 2004
Posts: 10,003,830
Likes: 0
From: Houston, TX
Update:
I have optimized the database a bit more but we seem to have a few queries that are locking everyone else out of the database, I didn't find any corruption in the DB, but we are eating a lot of IO on the database volume itself..
Investigation continues.. please stay tuned.
I have optimized the database a bit more but we seem to have a few queries that are locking everyone else out of the database, I didn't find any corruption in the DB, but we are eating a lot of IO on the database volume itself..
Investigation continues.. please stay tuned.
Originally Posted by cessna
By the Way,
I wasent able to log on last Saturday from 6am till about 3:30PM EST..... Weird eh?
I wasent able to log on last Saturday from 6am till about 3:30PM EST..... Weird eh?
This is just in jest
Registered User
Joined: Sep 2005
Posts: 8,194
Likes: 0
From: where the polar bears roam
Originally Posted by yobri
That was the new post limiter feature. When you have over a specified number of posts in a day or certain timespan, your account will be suspended for 24 hour period. Afterwards, you will be able to post for another specified number of posts.
This is just in jest
This is just in jest
LOL!
You had me going there man!lol!!!
Havent posted half as much as I use to.....
Seriously, when I was finally able to log on, it didnt look like the whole site was down..... I thaught for a sec, that a mod/admit had given me a temp ban or something....
just thaught it was weird.....
Registered User
Joined: Sep 2005
Posts: 8,194
Likes: 0
From: where the polar bears roam
Originally Posted by silvrhand
Well, there is one query that is locking the entire post text table for over 56 seconds, I'm trying to track down the specifics of the query and why it's returning so many rows..
English or French please?
<is not intraweb savy
Lost in Transit
Joined: Oct 2004
Posts: 10,003,830
Likes: 0
From: Houston, TX
English:
One user is holding up the entire website cause he's looking for a specific subset of data that is locking the database, when the database is locked on a table lock we have to wait for his search to finish. Until then everyone else has to wait.
I'm working on tweaking some MySQL settings tonight if you haven't noticed.
One user is holding up the entire website cause he's looking for a specific subset of data that is locking the database, when the database is locked on a table lock we have to wait for his search to finish. Until then everyone else has to wait.
I'm working on tweaking some MySQL settings tonight if you haven't noticed.
Originally Posted by cessna
English or French please?
<is not intraweb savy
<is not intraweb savy