MySQL downtime? [Archive] - PowWeb Community Forums

kennylucius

3-29-05, 05:38 PM

I have noticed in the last few weeks that the database server has been down much more often than it was before. It seems to last only a few minutes. Has anyone else noticed this, and does anyone know its cause?

I know it can't be my scripts, since this forum goes down as well.

kennylucius

4-1-05, 02:08 AM

The database has been unavailable at 4:31 AM PST for the past several days. Is this scheduled downtime?

mitchind

4-1-05, 11:42 AM

Try opening a request by emailing support@powweb.com

No one here will know the answer - unless you get lucky with a random Admin dropping by.

nli

4-1-05, 12:19 PM

Hello,

Which database are you referring to? I haven't noticed anything being down for days now unless something changed within your scripts.

kennylucius

4-1-05, 02:00 PM

I'm referring to the MySQL database server. I have a script that updates my DB twice an hour, and for the past four days (and perhaps longer) it has failed at 4:30 AM because the MySQL statements return 0 rows affected after multiple tries.

This is not that big of a deal, really. It's just very curious because it happens every morning at 4:30, and never any other time. The script usually takes 2 minutes to run, so it isn't just a momentary hiccup.

If it continues, I'll contact support next week. I just wanted to see if anyone else had noted it.

mitchind

4-1-05, 03:20 PM

I'm referring to the MySQL database server.

I think he needs "which" MySQL server you're on - there's many here.

Go to Member Ops | Packages | MySQL

it looks like mysql##.powweb.com

kennylucius

4-1-05, 03:28 PM

Oops! Of course that what he needs. Duh!

I'm on mysql06.

kennylucius

4-2-05, 11:45 AM

The problem did not occur this morning.

kennylucius

4-4-05, 09:51 PM

The problem occurred again this morning at 4:31 AM. It skipped the weekend. I'll watch a few more days to make sure it's recurring before notifying support.

kennylucius

4-6-05, 11:55 AM

Once again at 4:31 am. That's five times at 4:31 am: 3/30, 3/31, 4/1, 4/4, and 4/6. I think I'll just change my cron job to a different part of the hour.

nli

4-6-05, 12:14 PM

Hi,

That would be advisible for now. I'm running checks on 06 and haven't found anything yet:

Uptime: 1443315 Threads: 16 Questions: 427876681 Slow queries: 31877 Opens: 54096072 Flush tables: 1 Open tables: 128 Queries per second avg: 296.454

I've escalated this to our dev team to see if any of our own maintenance crons run during that hour.

kennylucius

4-7-05, 05:05 PM

I changed the cron time to 4:41 (ten minutes later), and it happened again. I have different scripts running at 21 and 51 which use the same MySQL DB, and they run fine.

Specifically, the script performs a series of REPLACE queries. If the affected records is less than 1, it tries up to four times and then echos an error containing the query.

I'll try moving it to the top half of the hour.

nicjasno

4-8-05, 06:47 PM

RTH10260

4-8-05, 11:22 PM

Well, i receive this error in my forums.

Warning: mysql_connect(): Too many connections in
/www/n/nicjasnocom/htdocs/forum/db/mysql4.php on line 48

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource
in /www/n/nicjasnocom/htdocs/forum/db/mysql4.php on line 330

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource
in /www/n/nicjasnocom/htdocs/forum/db/mysql4.php on line 331
phpBB : Critical Error

Could not connect to the databasePlease start a new thread when you have a different problem. Thank you.

Of the three errors listed, the second and the third are a consequence of the first, so ignore them.

The case of 'too many connections' can be either
- a temporary overload of the MySql server itself (nothing you can do against), or
- your own number of connects per hour was exeeded. For this case there may be a solution, by multiplexing usage thru up to three database usernames rather than a single name. This requires some handcoding to the package. This was recently discussed in another thread, but I cannot locate the link at this time.

check this thread too: http://forum.powweb.com/showthread.php?p=290298#post290298