Slowness in the site
#5
350Z-holic
iTrader: (113)
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
#6
Bad Mojo
Thread Starter
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; 05-16-2006 at 08:50 AM.
Trending Topics
#8
Administrator
iTrader: (25)
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.
#10
Registered User
Join Date: Oct 2005
Location: Under Snow
Posts: 743
Likes: 0
Received 0 Likes
on
0 Posts
Originally Posted by vo7848
Care to share the post? Linky please.
Maybe I'm wrong- I was gone for a few days, and when I came back, that great thread was gone...
#12
Lost in Transit
Join Date: Oct 2004
Location: Houston, TX
Posts: 10,003,830
Likes: 0
Received 0 Likes
on
0 Posts
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.
#16
350Z-holic
iTrader: (2)
Join Date: Jun 2001
Location: teh interwebnets
Posts: 17,685
Likes: 0
Received 0 Likes
on
0 Posts
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
#17
Registered User
Join Date: Sep 2005
Location: where the polar bears roam
Posts: 8,194
Likes: 0
Received 0 Likes
on
0 Posts
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.....
#18
Lost in Transit
Join Date: Oct 2004
Location: Houston, TX
Posts: 10,003,830
Likes: 0
Received 0 Likes
on
0 Posts
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..
#19
Registered User
Join Date: Sep 2005
Location: where the polar bears roam
Posts: 8,194
Likes: 0
Received 0 Likes
on
0 Posts
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
#20
Lost in Transit
Join Date: Oct 2004
Location: Houston, TX
Posts: 10,003,830
Likes: 0
Received 0 Likes
on
0 Posts
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