Logo

MySQL Server On The Break, I mean, Fritz

Thread Locked | Back To Forums

Post #1 · Posted at 2009-01-22 06:55:25am 5.8 years ago

Offline al2k4
al2k4 Avatar Badge Admin
8,023 Posts
United Kingdom
Reg. 2006-05-01
1133.6pts
Log in to send this user a private messageWindows Live Messenger: alanhmlam2k[at]hotmail.comAOL Instant Messenger: alanhmlamSkype: alanhmlamFacebookTwitter: al2k4Google+TwitchHitbox
Xbox Gamer Tag: al2k4PlayStation Network: al2k4Nintendo Network ID: alanhmlamSteam: alanhmlamOrigin: alanhmlam3DS Friend Code: 3540-0871-4839Game Center Nickname: al2k4CROSS×BEATS User ID: 64014374GREE Username: al2k4
Occurrences
2009-01-24, 22:00 GMT
2009-01-25, 16:00 GMT
2009-01-25, 22:00 GMT Duration 33 mins.
2009-01-26, 16:00 GMT Duration 20 mins.
2009-01-27, 16:20 GMT Duration 19 mins.
2009-01-27, 23:52 GMT
2009-01-28, 16:06 GMT
2009-01-29, 04:00 GMT Duration 15 mins.
2009-02-20, 22:00 GMT Duration 20 mins.
Yeah, recent Internal Server Errors are caused by the MySQL server taking absolutely ages to return the queries back to the web server.

It seems like my host doesn't even know what the issue despite many tickets from me; though they keep throwing the blame on me about the queries being bad or whatever, then how come when I can run a replica of Zenius on my four year old computer with only 1gb RAM, it's completely fine? A bit funny isn't it?

I even disabled the site, which some of you may have noticed earlier today, to see if it was Zenius causing it. It turns out it was slow still, get this, it took the MySQL server a whole 120 seconds to show me a list of databases I had, seriously what the hell is up with that? With Zenius disabled and with all linked queries eliminated, it took two minutes just to show me the database and it's tables; You don't expect this from a well known host at all!

They have admitted in the latest ticket to me, there are "other issues" on the MySQL server, which confirms it might not be Zenius that's causing it.

I suggested them transferring me to another MySQL server, but they haven't agreed to it yet. So all I can say is bear with it for now, as my tickets are getting nowhere with DH.

If anyone is generous enough to host the MySQL database, please get in touch, but mind you, it needs to be at a decent speed and more reliable than what's been going on.

Post #2 · Posted at 2009-01-22 08:18:58am 5.8 years ago

Offline musicfan32787
musicfan32787 Avatar Badge Member
748 Posts
United States
Reg. 2009-01-19
140.4pts
Log in to send this user a private message
"Google Chrome = Win."
Another reason to stop using DreamHost. From what you're saying, I think you should consider switching to PowWeb. They are well known and have a good reputation, from what I read in an article. Check out their hosting package if you want to consider switching hosts.

EDIT: While we're on the topic of MySQL databases, with PowWeb you get 75.
http://images1.wikia.nocookie.net/uncyclopedia/images/7/73/IPwnYou.JPG You just got pwned by the iPod.

Post #3 · Posted at 2009-01-26 06:35:21am 5.8 years ago

Offline al2k4
al2k4 Avatar Badge Admin
8,023 Posts
United Kingdom
Reg. 2006-05-01
1133.6pts
Log in to send this user a private messageWindows Live Messenger: alanhmlam2k[at]hotmail.comAOL Instant Messenger: alanhmlamSkype: alanhmlamFacebookTwitter: al2k4Google+TwitchHitbox
Xbox Gamer Tag: al2k4PlayStation Network: al2k4Nintendo Network ID: alanhmlamSteam: alanhmlamOrigin: alanhmlam3DS Friend Code: 3540-0871-4839Game Center Nickname: al2k4CROSS×BEATS User ID: 64014374GREE Username: al2k4
Seems to be a trend. Every 6 hours I think, it dies for half an hour. It died today at 4pm and 10pm local time (just 30 minutes ago).

If people can help me log when it goes down and when it goes back up, I'll really appreciate it. I'm keeping a record on the first post.

Post #4 · Posted at 2009-01-27 12:37:05pm 5.8 years ago

Offline silenttype01
silenttype01 Avatar Badge Member+
7,780 Posts
United States
Reg. 2007-01-19
681.3pts
Log in to send this user a private message
PlayStation Network: Racsotype013DS Friend Code: 1564 3161 8478
"DINGDONG♥HEARTS"

Post #5 · Posted at 2009-01-27 01:04:03pm 5.8 years ago

Offline Kyzentun
Kyzentun Avatar Badge Member
2,986 Posts
United States
Reg. 2008-02-20
244.1pts
Log in to send this user a private message
"I read Barefoot Boy too much."
Quote: silenttype01
2009-01-27, 04:20 GMT

Duration: 19 minutes approx
The server was off smoking a bowl.
silenttype01: Kyzentun is never harsh. He says it how it is. AAA #1 AAA #2 AAA #3 AAA #4 AAA #5 AAA #6 AAA #7
http://zenius-i-vanisher.com/ddrsig/2574_2.png?t=1253980692http://i26.photobucket.com/albums/c113/lordtoon/User%20Names/Kyzentun.pnghttp://i109.photobucket.com/albums/n48/shahllen/User%20Banners/Kyzentun.png
The 7 Jump D Challenge 7 (see song title)
GENERATION 24: The first time you see this, copy it into your sig on any forum and add 1 to the generation. Social experiment.

Post #6 · Posted at 2009-01-31 12:48:45pm 5.8 years ago

Offline silenttype01
silenttype01 Avatar Badge Member+
7,780 Posts
United States
Reg. 2007-01-19
681.3pts
Log in to send this user a private message
PlayStation Network: Racsotype013DS Friend Code: 1564 3161 8478
"DINGDONG♥HEARTS"
2009-01-29, 04:00 GMT
Duration: 15 minutes


2009-01-31, 04:00 GMT Duration: 30 minutes.

I'm pissed at Dreamhost. This is the the third time to happen at this time, so the pattern is every 6 hours.Evil

Post #7 · Posted at 2009-01-31 01:45:31pm 5.8 years ago

Offline musicfan32787
musicfan32787 Avatar Badge Member
748 Posts
United States
Reg. 2009-01-19
140.4pts
Log in to send this user a private message
"Google Chrome = Win."
Switch to PowWeb, if it isn't too much of a hassle. Who ISN'T pissed at DH?
http://images1.wikia.nocookie.net/uncyclopedia/images/7/73/IPwnYou.JPG You just got pwned by the iPod.

Post #8 · Posted at 2009-01-31 03:57:18pm 5.8 years ago

Offline Kyzentun
Kyzentun Avatar Badge Member
2,986 Posts
United States
Reg. 2008-02-20
244.1pts
Log in to send this user a private message
"I read Barefoot Boy too much."
OMG, ZIV is down! How will I ever survive?!
Seriously just do something else for a while. I've never understood why people get irritated over occasional short downtime. Go play some game and check back later.
silenttype01: Kyzentun is never harsh. He says it how it is. AAA #1 AAA #2 AAA #3 AAA #4 AAA #5 AAA #6 AAA #7
http://zenius-i-vanisher.com/ddrsig/2574_2.png?t=1253980692http://i26.photobucket.com/albums/c113/lordtoon/User%20Names/Kyzentun.pnghttp://i109.photobucket.com/albums/n48/shahllen/User%20Banners/Kyzentun.png
The 7 Jump D Challenge 7 (see song title)
GENERATION 24: The first time you see this, copy it into your sig on any forum and add 1 to the generation. Social experiment.

Post #9 · Posted at 2009-01-31 03:59:59pm 5.8 years ago

Offline silenttype01
silenttype01 Avatar Badge Member+
7,780 Posts
United States
Reg. 2007-01-19
681.3pts
Log in to send this user a private message
PlayStation Network: Racsotype013DS Friend Code: 1564 3161 8478
"DINGDONG♥HEARTS"
A site shouldn't have this much downtime when it's running smoothly.

And since each downtime I experience is approx 30 min, I watch some Eureka Seven in the meantime.Happy


Post #10 · Posted at 2009-02-01 12:46:36am 5.8 years ago

Offline roy2009xedit
roy2009xedit Avatar Badge Member
5,221 Posts
United States
Reg. 2008-02-10
232.6pts
Log in to send this user a private message
"jubeat knit one, purl two"
It doesn't bother me. Downtime is at 4:00 and 10:00, so I just adapt my schedule to avoid them.
http://i26.photobucket.com/albums/c113/lordtoon/Random/roy2009xedit.pnghttp://i128.photobucket.com/albums/p198/Oni-91/Kawaii%20Rangers/037.png

Post #11 · Posted at 2009-02-05 10:43:59am 5.7 years ago

Offline al2k4
al2k4 Avatar Badge Admin
8,023 Posts
United Kingdom
Reg. 2006-05-01
1133.6pts
Log in to send this user a private messageWindows Live Messenger: alanhmlam2k[at]hotmail.comAOL Instant Messenger: alanhmlamSkype: alanhmlamFacebookTwitter: al2k4Google+TwitchHitbox
Xbox Gamer Tag: al2k4PlayStation Network: al2k4Nintendo Network ID: alanhmlamSteam: alanhmlamOrigin: alanhmlam3DS Friend Code: 3540-0871-4839Game Center Nickname: al2k4CROSS×BEATS User ID: 64014374GREE Username: al2k4
Looks like they fixed it, though they tried to put the blame on me again on their latest ticket. Ah well, least it's fixed for now.

Post #12 · Posted at 2009-02-07 07:05:41am 5.7 years ago

Offline hooky
hooky Avatar Badge Member
2,255 Posts
United States
Reg. 2007-07-28
263.4pts
Log in to send this user a private messageSkype: hookyboysbFacebookTwitter: hookyboysbGoogle+YouTubeTwitch
Steam: hookyboysb3DS Friend Code: 4167-4577-0698
Quote: Title
MySQL Server On The Break, I mean, Fritz
I see what you did there.
http://i26.photobucket.com/albums/c113/lordtoon/User%20Names/hooky.png
21:47:14 · Blinded_No_More: Well, I'm calling someday... -Akiba Koubou Mix- for X3
12:38:32 · Blinded_No_More: nuclear allergy
14:14:29 · Chewi☆: hold on let me find the bread


X2 Jackets
DDR2010 Jackets
DDRII Jackets

Post #13 · Posted at 2009-02-07 07:20:28am 5.7 years ago

Offline PyroManiacX
PyroManiacX Avatar Badge Member
3,758 Posts
United States
Reg. 2007-09-23
315.3pts
Log in to send this user a private messageWindows Live Messenger: Ask meAOL Instant Messenger: Ask meSkype: Ask me
Xbox Gamer Tag: X3PHJACK3LWii Friend Code: Ask meSteam: ThatOneJackal
"Not dead yet!"
For some reason when I try to get on here with AOL, I get a 402 Forbidden Error, but IE its good Confused
http://i26.photobucket.com/albums/c113/lordtoon/Song%20Title/MDCXCII.pnghttp://i26.photobucket.com/albums/c113/lordtoon/User%20Names/PyroManiacX.pnghttp://i849.photobucket.com/albums/ab54/zivrewards/ZIV%20Award%20Committee/PyromaniacX.png

Post #14 · Posted at 2009-02-21 06:24:20am 5.7 years ago

Offline al2k4
al2k4 Avatar Badge Admin
8,023 Posts
United Kingdom
Reg. 2006-05-01
1133.6pts
Log in to send this user a private messageWindows Live Messenger: alanhmlam2k[at]hotmail.comAOL Instant Messenger: alanhmlamSkype: alanhmlamFacebookTwitter: al2k4Google+TwitchHitbox
Xbox Gamer Tag: al2k4PlayStation Network: al2k4Nintendo Network ID: alanhmlamSteam: alanhmlamOrigin: alanhmlam3DS Friend Code: 3540-0871-4839Game Center Nickname: al2k4CROSS×BEATS User ID: 64014374GREE Username: al2k4
Gah and again. My host will get a bashing from me tonight.

Post #15 · Posted at 2009-02-21 07:02:27am 5.7 years ago

Offline Silver Spirit
Silver Spirit Avatar Badge Member
5,125 Posts
United States
Reg. 2008-09-14
347.1pts
Log in to send this user a private messageSkype: five.three.twoTwitter: HT_MasuokaTumblr
Nintendo Network ID: daichi.shijimaSteam: Biotonic3DS Friend Code: 2578-3309-2697CROSS×BEATS User ID: 33229320
Really? Everything's fine on my end.

Post #16 · Posted at 2009-03-03 01:58:53am 5.7 years ago

Offline al2k4
al2k4 Avatar Badge Admin
8,023 Posts
United Kingdom
Reg. 2006-05-01
1133.6pts
Log in to send this user a private messageWindows Live Messenger: alanhmlam2k[at]hotmail.comAOL Instant Messenger: alanhmlamSkype: alanhmlamFacebookTwitter: al2k4Google+TwitchHitbox
Xbox Gamer Tag: al2k4PlayStation Network: al2k4Nintendo Network ID: alanhmlamSteam: alanhmlamOrigin: alanhmlam3DS Friend Code: 3540-0871-4839Game Center Nickname: al2k4CROSS×BEATS User ID: 64014374GREE Username: al2k4
It happened one hour ago, that's why lol.

Bump: Requested move and they've moved the database to another server now. Let's hope this server is not as bad as the last one.

Post #17 · Posted at 2009-03-03 02:25:36am 5.7 years ago

Offline musicfan32787
musicfan32787 Avatar Badge Member
748 Posts
United States
Reg. 2009-01-19
140.4pts
Log in to send this user a private message
"Google Chrome = Win."
Excellent.
http://images1.wikia.nocookie.net/uncyclopedia/images/7/73/IPwnYou.JPG You just got pwned by the iPod.

Post #18 · Posted at 2009-03-06 11:10:13pm 5.7 years ago

Offline al2k4
al2k4 Avatar Badge Admin
8,023 Posts
United Kingdom
Reg. 2006-05-01
1133.6pts
Log in to send this user a private messageWindows Live Messenger: alanhmlam2k[at]hotmail.comAOL Instant Messenger: alanhmlamSkype: alanhmlamFacebookTwitter: al2k4Google+TwitchHitbox
Xbox Gamer Tag: al2k4PlayStation Network: al2k4Nintendo Network ID: alanhmlamSteam: alanhmlamOrigin: alanhmlam3DS Friend Code: 3540-0871-4839Game Center Nickname: al2k4CROSS×BEATS User ID: 64014374GREE Username: al2k4
Looks like the problem hasn't gone away.

The new MySQL server is getting bombarded with tons queries too and makes everything all that much slower...

Post #19 · Posted at 2009-03-07 01:54:14am 5.7 years ago

Offline musicfan32787
musicfan32787 Avatar Badge Member
748 Posts
United States
Reg. 2009-01-19
140.4pts
Log in to send this user a private message
"Google Chrome = Win."
Has this ever happened in past years?
http://images1.wikia.nocookie.net/uncyclopedia/images/7/73/IPwnYou.JPG You just got pwned by the iPod.
Thread Locked | Back To Forums

0 User(s) Viewing This Thread (Past 15 Minutes)

©2006-2014 Zenius -I- vanisher.com -5th style- II
Web Server: 1% · Database: 4%
This page took 0.103 seconds to execute.
Theme: starlight · Language: englishuk
Reset Theme & Language