MySQL08 People, over here :)

[marcc]

I am getting a lot of "too many connections" errors. I submitted the problem to support. Anybody else get this on 08?

[Plankje]

Hi,

Yes I'm getting them as well.
I suppose the database is the reason of being my site often to be very very slow.

I always thought it was the PHP,
but I'm using a cache system now as well Zend Optimizer.
Still very slow most of the times.

www.mozeskriebel.com

Regards
Marco

[Mastaq]

What's going on here? My database hasn't been able to connect for 3 days now.. My message boards have been down for that many days. And I'm getting a lot of angry users contacting me. I don't know what to tell them at this point. I thought it was a problem I could fix. Now I know that I can't. I tried getting help in the chat room but nobody could help. This is pretty much my last resort. I'm on SQL08 and my site is http://battle-grounds.com/forum I have been running with PowWeb since this past November. This is the first real major problem I've had. Please help. :confused:

[mjp]

What's going on here? My database hasn't been able to connect for 3 days now..The error message I see when I check your link is typically dispalyed when there is an error in the config script. It isn't the same as an error from the server re: connections being rejected or busy server errors.

[dumbledory2]

i use mercuryboard and it was fine an hour ago...but now it's giving me an error and it's not working. i'm on mysql08. im starting to think there's some problems with it as there are with mysql09.

i'm getting the following error:
Can't open file: 'mb_posts.MYI' (errno: 145)
--------------------------------------------------------------------------------

Query Error [1016]:
This type of error is reported by MySQL.

Query:
SELECT f.forum_id, f.forum_parent, f.forum_name, f.forum_position, f.forum_description, f.forum_topics, f.forum_replies, f.forum_lastpost, t.topic_id as LastTopicID, t.topic_title as user_lastpost, t.topic_edited as LastTime, t.topic_replies, m.user_name as user_lastposter, m.user_id as user_lastposterID FROM mb_forums f LEFT JOIN mb_posts p ON p.post_id = f.forum_lastpost LEFT JOIN mb_topics t ON t.topic_id = p.post_topic LEFT JOIN mb_users m ON m.user_id = p.post_author ORDER BY f.forum_parent, f.forum_position

[jeffery]

You should try repairing your tables within phpmyadmin > http://phpmyadmin.powweb.com

[dumbledory2]

nevermind..i think i fixed it - thanks!

[alphadesk]

For future reference ...

Login with https://phpmyadmin.powweb.com/

Then click on the DB name upper left ...

Then on the right below all the rows of tables click Select All ...

Then with the dropdown box select Repair Table ...

[Mastaq]

The error message I see when I check your link is typically dispalyed when there is an error in the config script. It isn't the same as an error from the server re: connections being rejected or busy server errors.
I checked the config file and it didn't have any errors. I've never had this problem in the past.

[Nairou]

I'm getting intermittent connection problems to mysql08 as well. I have a couple phpbb forums, which have been running fine for months, and they are down at the moment due to mysql08:

Warning: mysql_connect(): Can't connect to MySQL server on 'mysql08.powweb.com' (60) in /www/r/rocftp/htdocs/rocmod/db/mysql4.php on line 48

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

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

Could not connect to the database


I have made no changes to my config or forum files. This isn't the first time I've gotten this error, it usually goes away after an hour or so, but it is annoying and becoming more frequent.

[alphadesk]

All mysql servers should be coming back up now or shortly ... if yours is still down please get with support or post in a new thread with domain name.

And mine on mysql08 never went down :D

[dumbledory2]

OK...i've had to repair tables MANY times over now. Because I keep getting the same error. Then I repair my tables as someone suggested ^ but then I get the error again and I have to, once again, repair tables which seems to be only temporary. What's the deal?

[Guido]

How much torture do the admins think we need to endure? More peeps are viewing and posting in the MySQL thread than any other right now.

We are all experiencing the same corrupt file issues and getting the same lame repair instructions. Like we're all stupid children.

I'm down - on mysql08 - same issues - no information useless or otherwise...

Jaysus

[dumbledory2]

Ok...now not even REPAIRING my tables works. My programs are just giving me errors all the time now!!!!!!!!!!!!! :mad: :mad: :mad: :mad: :mad: