Nissan 350Z Discussion forums, Photo Gallery and more...


Go Back   MY350Z.COM Forums > My350Z.com > Announcements
Sign in using an external account
Register Forgot Password?
MyG37.com | G35Driver.com | My350Z.com | ZDriver.com





Welcome to my350z.com!
Welcome to my350z.com.

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!



Reply
 
 
 
 
Thread Tools Search this Thread
Old 05-15-2006, 07:31 PM   #1
GodZilla
Bad Mojo
 
GodZilla's Avatar
 
Join Date: Jul 2002
Location: Tokyo, Japan
Posts: 2,611
iTrader: (0)
Points: 23,412, Level: 94
Points: 23,412, Level: 94 Points: 23,412, Level: 94 Points: 23,412, Level: 94
Today's Activity: 0%
Today's Activity: 0% Today's Activity: 0% Today's Activity: 0%
Send a message via AIM to GodZilla
Default Slowness in the site

I'm currently looking into why the server is acting so slow..
__________________
Kyle
カイル
GodZilla is offline   Reply With Quote
Old 05-16-2006, 04:05 AM   #2
Mike Wazowski
Super Moderator
MY350Z.COM

 
Mike Wazowski's Avatar
 
Join Date: Nov 2004
Location: San Diego 92111
Posts: 21,951
iTrader: (113)
Points: 99,586, Level: 100
Points: 99,586, Level: 100 Points: 99,586, Level: 100 Points: 99,586, Level: 100
Today's Activity: 10.6%
Today's Activity: 10.6% Today's Activity: 10.6% Today's Activity: 10.6%
Default

figure anything out yet?
__________________
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)
Mike Wazowski is offline   Reply With Quote
Old 05-16-2006, 04:31 AM   #3
cessna
Registered User
 
cessna's Avatar
 
Join Date: Sep 2005
Location: where the polar bears roam
Posts: 8,196
iTrader: (0)
Default

Intresting you noticed.....
I had a hard time logging in around 10-11 pm last night
__________________
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.
cessna is offline   Reply With Quote
Old 05-16-2006, 06:09 AM   #4
doug
Registered User
 
Join Date: Sep 2002
Location: ur moms bedroom.. watching TV
Posts: 16,742
iTrader: (5)
Points: 8,713, Level: 62
Points: 8,713, Level: 62 Points: 8,713, Level: 62 Points: 8,713, Level: 62
Today's Activity: 5.3%
Today's Activity: 5.3% Today's Activity: 5.3% Today's Activity: 5.3%
Default

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
doug is offline   Reply With Quote
Old 05-16-2006, 08:50 AM   #5
Mike Wazowski
Super Moderator
MY350Z.COM

 
Mike Wazowski's Avatar
 
Join Date: Nov 2004
Location: San Diego 92111
Posts: 21,951
iTrader: (113)
Points: 99,586, Level: 100
Points: 99,586, Level: 100 Points: 99,586, Level: 100 Points: 99,586, Level: 100
Today's Activity: 10.6%
Today's Activity: 10.6% Today's Activity: 10.6% Today's Activity: 10.6%
Default

Quote:
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
You know that no one uses the SEARCH function. That is why there is such a large influx of REPOSTS!
__________________
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)
Mike Wazowski is offline   Reply With Quote
Old 05-16-2006, 09:46 AM   #6
GodZilla
Bad Mojo
 
GodZilla's Avatar
 
Join Date: Jul 2002
Location: Tokyo, Japan
Posts: 2,611
iTrader: (0)
Points: 23,412, Level: 94
Points: 23,412, Level: 94 Points: 23,412, Level: 94 Points: 23,412, Level: 94
Today's Activity: 0%
Today's Activity: 0% Today's Activity: 0% Today's Activity: 0%
Send a message via AIM to GodZilla
Default

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.
__________________
Kyle
カイル

Last edited by GodZilla; 05-16-2006 at 09:50 AM.
GodZilla is offline   Reply With Quote
Old 05-16-2006, 10:00 AM   #7
Mike Wazowski
Super Moderator
MY350Z.COM

 
Mike Wazowski's Avatar
 
Join Date: Nov 2004
Location: San Diego 92111
Posts: 21,951
iTrader: (113)
Points: 99,586, Level: 100
Points: 99,586, Level: 100 Points: 99,586, Level: 100 Points: 99,586, Level: 100
Today's Activity: 10.6%
Today's Activity: 10.6% Today's Activity: 10.6% Today's Activity: 10.6%
Default

Quote:
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.
Go BraveHearts! LOL
__________________
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)
Mike Wazowski is offline   Reply With Quote
Old 05-18-2006, 02:57 PM   #8
vo7848
Super Moderator
MY350Z.COM

 
vo7848's Avatar
 
Join Date: Jun 2005
Location: Down Under & Dirty
Posts: 35,071
iTrader: (25)
Points: 24,211, Level: 94
Points: 24,211, Level: 94 Points: 24,211, Level: 94 Points: 24,211, Level: 94
Today's Activity: 17.3%
Today's Activity: 17.3% Today's Activity: 17.3% Today's Activity: 17.3%
Default

Quote:
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.
Care to share the post? Linky please.
__________________
Team Nextstage
Sponsored by Meguiar's, Imported Performance
www.teamnextstage.com
Team DNF n00bslayer & eater of children............................................................ ...............
vo7848 is offline   Reply With Quote
Old 05-18-2006, 03:08 PM   #9
Vader007
Registered User
 
Vader007's Avatar
 
Join Date: Nov 2004
Location: Yardley, Pa.
Posts: 753
iTrader: (22)
Points: 2,753, Level: 32
Points: 2,753, Level: 32 Points: 2,753, Level: 32 Points: 2,753, Level: 32
Today's Activity: 0%
Today's Activity: 0% Today's Activity: 0% Today's Activity: 0%
Default

You must have fixed it because I've NEVER seen it this fast before!



Jerry
Vader007 is offline   Reply With Quote
Old 05-20-2006, 11:44 AM   #10
Ringo
Registered User
 
Ringo's Avatar
 
Join Date: Oct 2005
Location: Under Snow
Posts: 743
iTrader: (0)
Default

Quote:
Originally Posted by vo7848
Care to share the post? Linky please.
If I'm not mistaken, it was the "War on Newbism" thread, which has now been deleted.

Maybe I'm wrong- I was gone for a few days, and when I came back, that great thread was gone...
__________________


I'm pretty much half man, half amazing.
But mostly amazing.
Ringo is offline   Reply With Quote
Old 05-22-2006, 07:09 PM   #11
Mesto
Registered User
 
Join Date: Apr 2006
Location: Chesterfield,VA
Posts: 89
iTrader: (0)
Default

I thought it was only me because i have a **** load of downloads going on bit torrent
Mesto is offline   Reply With Quote
Old 05-24-2006, 06:48 PM   #12
silvrhand
Lost in Transit
 
silvrhand's Avatar
 
Join Date: Oct 2004
Location: Houston, TX
Posts: 10,003,737
iTrader: (0)
Points: 5,947, Level: 49
Points: 5,947, Level: 49 Points: 5,947, Level: 49 Points: 5,947, Level: 49
Today's Activity: 11.4%
Today's Activity: 11.4% Today's Activity: 11.4% Today's Activity: 11.4%
Send a message via AIM to silvrhand Send a message via MSN to silvrhand Send a message via Yahoo to silvrhand
Default

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.
silvrhand is offline   Reply With Quote
Old 06-12-2006, 05:35 PM   #13
Mike Wazowski
Super Moderator
MY350Z.COM

 
Mike Wazowski's Avatar
 
Join Date: Nov 2004
Location: San Diego 92111
Posts: 21,951
iTrader: (113)
Points: 99,586, Level: 100
Points: 99,586, Level: 100 Points: 99,586, Level: 100 Points: 99,586, Level: 100
Today's Activity: 10.6%
Today's Activity: 10.6% Today's Activity: 10.6% Today's Activity: 10.6%
Default

any news yet? This is getting bad lately.
__________________
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)
Mike Wazowski is offline   Reply With Quote
Old 06-12-2006, 07:29 PM   #14
cessna
Registered User
 
cessna's Avatar
 
Join Date: Sep 2005
Location: where the polar bears roam
Posts: 8,196
iTrader: (0)
Default

By the Way,

I wasent able to log on last Saturday from 6am till about 3:30PM EST..... Weird eh?
__________________
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.
cessna is offline   Reply With Quote
Old 06-12-2006, 07:31 PM   #15
GodZilla
Bad Mojo
 
GodZilla's Avatar
 
Join Date: Jul 2002
Location: Tokyo, Japan
Posts: 2,611
iTrader: (0)
Points: 23,412, Level: 94
Points: 23,412, Level: 94 Points: 23,412, Level: 94 Points: 23,412, Level: 94
Today's Activity: 0%
Today's Activity: 0% Today's Activity: 0% Today's Activity: 0%
Send a message via AIM to GodZilla
Default

Latest is we have been looking into getting a second server to balance the load.

Even though we have a bad ass server now a second is needed.
__________________
Kyle
カイル
GodZilla is offline   Reply With Quote
Old 06-12-2006, 10:29 PM   #16
yobri
Administrator
 
Join Date: Jun 2001
Location: teh interwebnets
Posts: 16,301
iTrader: (2)
Points: 11,600, Level: 70
Points: 11,600, Level: 70 Points: 11,600, Level: 70 Points: 11,600, Level: 70
Today's Activity: 6.8%
Today's Activity: 6.8% Today's Activity: 6.8% Today's Activity: 6.8%
Default

Quote:
Originally Posted by cessna
By the Way,

I wasent able to log on last Saturday from 6am till about 3:30PM EST..... Weird eh?
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 a 24-hour period. Afterwards, you will be able to post for another specified number of posts.































This is just in jest
__________________
SHIFT_norcal ~ SF Bay Area ~ Breaking Bad, Homeland, Dexter, GSW (SFW), SF Giants, Jdorama, SFII, IT croo
yobri is online now   Reply With Quote
Old 06-13-2006, 05:41 AM   #17
cessna
Registered User
 
cessna's Avatar
 
Join Date: Sep 2005
Location: where the polar bears roam
Posts: 8,196
iTrader: (0)
Default

Quote:
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

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.....
__________________
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.
cessna is offline   Reply With Quote
Old 06-13-2006, 09:07 AM   #18
silvrhand
Lost in Transit
 
silvrhand's Avatar
 
Join Date: Oct 2004
Location: Houston, TX
Posts: 10,003,737
iTrader: (0)
Points: 5,947, Level: 49
Points: 5,947, Level: 49 Points: 5,947, Level: 49 Points: 5,947, Level: 49
Today's Activity: 11.4%
Today's Activity: 11.4% Today's Activity: 11.4% Today's Activity: 11.4%
Send a message via AIM to silvrhand Send a message via MSN to silvrhand Send a message via Yahoo to silvrhand
Default

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..
silvrhand is offline   Reply With Quote
Old 06-13-2006, 06:34 PM   #19
cessna
Registered User
 
cessna's Avatar
 
Join Date: Sep 2005
Location: where the polar bears roam
Posts: 8,196
iTrader: (0)
Default

Quote:
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
__________________
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.
cessna is offline   Reply With Quote
Old 06-13-2006, 08:53 PM   #20
silvrhand
Lost in Transit
 
silvrhand's Avatar
 
Join Date: Oct 2004
Location: Houston, TX
Posts: 10,003,737
iTrader: (0)
Points: 5,947, Level: 49
Points: 5,947, Level: 49 Points: 5,947, Level: 49 Points: 5,947, Level: 49
Today's Activity: 11.4%
Today's Activity: 11.4% Today's Activity: 11.4% Today's Activity: 11.4%
Send a message via AIM to silvrhand Send a message via MSN to silvrhand Send a message via Yahoo to silvrhand
Default

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.

Quote:
Originally Posted by cessna
English or French please?


<is not intraweb savy
silvrhand is offline   Reply With Quote
Old 06-13-2006, 08:53 PM
My350Z
350 Z




Paid Advertisement
 
 
 
Reply



Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Recently began seeing... davidv My350Z.com Forum-related Feedback, Suggestions & Questions 37 03-30-2009 10:59 PM
Slowness in the site GodZilla Announcements 33 03-23-2006 05:01 PM

ADVERTISING
INSURANCE CENTER

All times are GMT -8. The time now is 06:53 AM.

Advertise on MY350Z.COM - MY350Z.COM - Archive - Top

Advertise on MY350Z.COM - Terms of Service - Privacy Policy - Jobs
Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.5.2
Copyright ©2002 - 2008, MY350Z.COM All Rights Reserved.

Admin control Panel Backup