View Full Version : MySQL down on Terra +10HRS
It's also down on andromeda.
MySQL on terra has been fixed. MySQL on andromeda was never down:
su-2.05a# mysqladmin -p status
Enter password:
Uptime: 190024 Threads: 1 Questions: 2466284 Slow queries: 7 Opens: 13791 Flush tables: 1 Open tables: 1024 Queries per second avg: 12.979
Originally posted by Starr
MySQL on terra has been fixed. MySQL on andromeda was never down:
su-2.05a# mysqladmin -p status
Enter password:
Uptime: 190024 Threads: 1 Questions: 2466284 Slow queries: 7 Opens: 13791 Flush tables: 1 Open tables: 1024 Queries per second avg: 12.979
My website is hosted on andromeda.
http://www.thekickback.com/
As you can see, you can't even go there because you get the phpBB2 error, cannot connect to database.
Check your settings as there is no problem w/ mySQL on andromeda.
Perhaps you hit the limits we have in place? If so, you need to figure out a way to optimize your mySQL queries.
Originally posted by Starr
Check your settings as there is no problem w/ mySQL on andromeda.
Perhaps you hit the limits we have in place? If so, you need to figure out a way to optimize your mySQL queries.
Hmm.. I'm the only person who has access to the database, and it was working fine until Wednesday night (as told by one of my friends, I didn't encounter the problem until this morning).
There's no possible way my site has hit the limits as I don't have many visitors at all.
I have two things that use mySQL and both of them are giving errors.
Hmm...
The limits are on a user-by-user basis correct? I created another user for my database, and attempted to use one of my scripts with that user, and I still get the error.
I just created a new mySQL user for your database (testing) and was able to connect to it w/ zero problems:
nova# mysql -h andromeda.powweb.com -u testing -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 97209 to server version: 4.0.11a-gamma-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
Originally posted by Starr
I just created a new mySQL user for your database (testing) and was able to connect to it w/ zero problems:
nova# mysql -h andromeda.powweb.com -u testing -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 97209 to server version: 4.0.11a-gamma-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
Eh, stupid me, I accidentily entered the wrong password when I remade my second user. But as far as the first original user goes, it won't connect to it using that account. I tried deleting it and remaking it, changing the password, etc. but it does not work. This is very weird. o_O
I don't mind changing the user name, but I don't know how to change the info in phpBB2...
Figured out how to fix phpbb2, fixed other stuff for a new user name, the original user i had still doesn't work. Doesn't matter, I'm the only one who uses it. I just hope this doesn't happen again.
darc, are you using any mods? I am using phpBB2 also (stock... using a style template, but no mods).
Fearing for the infamous mySQL limits problem, and with no way to measure utilization, I decided to do some stress-testing.
Last night I hammered the hell out of it for an hour, posting a typically-sized (~500 byte) post every 30 seconds or so, until I had around a hundred posts (OK, so that's only 50 minutes ;) ... but I did some other stuff too, during that hour). During this period, I was also re-visiting the recent posts, hoping to drive up the query count.
After about an hour, I stopped all this activity. I had -zero- problems, performance remained good throughout, and I did not hit the limits. My guess is that I didn't get close to the limits at all (and it's JUST a guess, since I can't measure my true utilization).
So if you're having problems with less than that going on, it might well be something else.
Good luck identifying the problem... please let us know if you figure out what is/was the problem!
Regards,
omatic
<shameless plug>
If ya noticed... Ya have not heard too many people mentioning having trouble with Ikonboard and mySQL. ;)
It's coded very well to put as less stress on the server as possible... not querying for every little thing it needs 50 thousand times. hehe.
</shameless plug>
Originally posted by omatic
darc, are you using any mods? I am using phpBB2 also (stock... using a style template, but no mods).
Fearing for the infamous mySQL limits problem, and with no way to measure utilization, I decided to do some stress-testing.
Last night I hammered the hell out of it for an hour, posting a typically-sized (~500 byte) post every 30 seconds or so, until I had around a hundred posts (OK, so that's only 50 minutes ;) ... but I did some other stuff too, during that hour). During this period, I was also re-visiting the recent posts, hoping to drive up the query count.
After about an hour, I stopped all this activity. I had -zero- problems, performance remained good throughout, and I did not hit the limits. My guess is that I didn't get close to the limits at all (and it's JUST a guess, since I can't measure my true utilization).
So if you're having problems with less than that going on, it might well be something else.
Good luck identifying the problem... please let us know if you figure out what is/was the problem!
Regards,
omatic
Yes, I am running lots of mods. My entire web site runs on phpBB2 - every page loaded is a phpBB2 page. But I just made the change to phpBB2 on sunday. I'm probably not going to investigate any further unless I run into another problem.
Originally posted by RadioRob
<shameless plug>
If ya noticed... Ya have not heard too many people mentioning having trouble with Ikonboard and mySQL. ;)
It's coded very well to put as less stress on the server as possible... not querying for every little thing it needs 50 thousand times. hehe.
</shameless plug>
Sorry, I dislike Ikonboard *a lot* - it's not that bad actually, but I wouldn't want it on my site.
vBulletin v3.6.0, Copyright ©2000-2009, Jelsoft Enterprises Ltd.