What causes a MySQL database to hang ?? - GoFuckYourself.com

halfpint · 06-25-2009, 12:04 PM

I was activating signed up members on my dating site which is hosted with phatservers and the database just hung the index page is now just a white page and when I try and check or repair the database it gets so far and just hangs and I havent got a recent backup with all the recent registered members ..shit

Anybody know what the cause is or any way to fix this

sarettah · 06-25-2009, 12:23 PM

Quote:

Originally Posted by halfpint

I was activating signed up members on my dating site which is hosted with phatservers and the database just hung the index page is now just a white page and when I try and check or repair the database it gets so far and just hangs and I havent got a recent backup with all the recent registered members ..shit

Anybody know what the cause is or any way to fix this

Are you trying to do the check/repair through phpmyadmin or are you in on ssh?

halfpint · 06-25-2009, 12:23 PM

Im on the phpmyadmin

who · 06-25-2009, 12:25 PM

Ask for your server to be restarted.

sarettah · 06-25-2009, 12:30 PM

Quote:

Originally Posted by halfpint

Im on the phpmyadmin

I was having issues with a table last week. It was taking so long to check or repair that phpmyadmin was timing out.

In the front screen of phpmyadmin you can look at the processes running. If you have made several attempts at the check/repair you probably have multiple threads out there waiting for each to complete.

If you do I would get rid of all but the active process.

Once that process finishes, what I did was wrote a quick little php script to do the check table and repair table if necessary. In the script, at the start I turned off the server timeout.

The check table in my case took 6 hours to run but with the server timeout suspended it eventually reported back to the browser when it was done.

Good Luck

boneless · 06-25-2009, 12:39 PM

by any chance you got a log file on there thats like massive in size?

halfpint · 06-25-2009, 01:40 PM

I have managed to find the table that is causing the problem

Its saying it is 8.7MB in size but I cant browse it and I also have this warning at the bottom of the tables "1 May be approximate. See FAQ 3.11" I have no idea what that means

When I download the table and open it with worpad it is empty. I dont know whether to just delete the table as I cant repair / check or optimize it and I have no idea what it contains either

06-25-2009, 01:50 PM

Hit up Moose and the fellas they should be able to help you...

Sarettah, wtf you got in that database that takes it 6 hours to check/repair?

halfpint · 06-25-2009, 01:52 PM

Quote:

Originally Posted by Killswitch

Hit up Moose and the fellas they should be able to help you...

Sarettah, wtf you got in that database that takes it 6 hours to check/repair?

yeah think I will I cant figure this one out and I hate pestering the tech guys ..lol

sarettah · 06-25-2009, 01:53 PM

Quote:

Originally Posted by Killswitch

Hit up Moose and the fellas they should be able to help you...

Sarettah, wtf you got in that database that takes it 6 hours to check/repair?

Well, we had 22 million urls in it.

I have since created a more efficient solution

rowan · 06-25-2009, 01:55 PM

You can't view mysql tables with a word processor, they're in a proprietary binary format. DON'T go deleting any tables until you're 100% sure they're corrupted to hell and back (which is probably unlikely)... and even then I'd rename them and keep them anyway.

Do you have SSH access? Or is Phat a fully managed host? If you have SSH, try this...

mysql -u <username> -p
... enter your password ...
use <database_name>
check table <table_name> <-- repeat as many times as necessary
If any tables show up errors,
repair table <table_name>

rowan · 06-25-2009, 01:58 PM

Also, show processlist when logged into mysql will display what's happening... this may give you a hint why things seem to be "stuck"

MySQL may also be writing an error log, in my setup it is located in the database directory and named <hostname>.err ... eg if your server is called www.mydomain.com the error log will be called www.mydomain.com.err

Here's an example of a line showing a problem with a table...

090601 13:35:35 [ERROR] /usr/local/mysql/libexec/mysqld: Table './sdqueue/pre_urlqueue_e9' is marked as crashed and should be repaired

halfpint · 06-25-2009, 02:02 PM

Thanks Rowan and all the other guys for helping out and giving suggestions. Im gonna let the tech guys have a look at it now before I go deleting anything and completly screw things up

halfpint · 06-25-2009, 03:08 PM

Good old Phatservers has fixed the problem it seems the database got corrupted

Thanks Phatservers for a great fast service

06-25-2009, 03:35 PM

Quote:

Originally Posted by halfpint

Good old Phatservers has fixed the problem it seems the database got corrupted

Thanks Phatservers for a great fast service

Word, Phat knows their shit, I'd rather let them do it than fuck anything up even more than it is.

halfpint · 06-25-2009, 03:49 PM

Quote:

Originally Posted by Killswitch

Word, Phat knows their shit, I'd rather let them do it than fuck anything up even more than it is.

They sure do, and they fixed it real quick

XSV · 06-25-2009, 03:49 PM

Quote:

Originally Posted by halfpint

yeah think I will I cant figure this one out and I hate pestering the tech guys ..lol

For future reference, don't waste a minute, that's what we are here for.

You have an

, we

you.

halfpint · 06-25-2009, 03:56 PM

Quote:

Originally Posted by XSV

For future reference, don't waste a minute, that's what we are here for.

You have an

, we

you.

Thanks you guys rock

06-25-2009, 04:39 PM

Quote:

Originally Posted by XSV

You have an

, we

you.

Cheesiest use of smilies EVAR!

06-25-2009, 12:04 PM	#1
halfpint GFY's Halfpint Industry Role: Join Date: Jun 2007 Location: UK Posts: 15,223	What causes a MySQL database to hang ?? I was activating signed up members on my dating site which is hosted with phatservers and the database just hung the index page is now just a white page and when I try and check or repair the database it gets so far and just hangs and I havent got a recent backup with all the recent registered members ..shit Anybody know what the cause is or any way to fix this __________________ Get FREE website listings on Cryptocoinshops.net

06-25-2009, 12:23 PM	#3
halfpint GFY's Halfpint Industry Role: Join Date: Jun 2007 Location: UK Posts: 15,223	Im on the phpmyadmin __________________ Get FREE website listings on Cryptocoinshops.net

06-25-2009, 12:39 PM	#6
boneless Confirmed User Industry Role: Join Date: Dec 2002 Location: in your head Posts: 3,625	by any chance you got a log file on there thats like massive in size? __________________ icq:148573096 skype:dabone2 email:boneless(a)mgpteam(.)com

06-25-2009, 01:40 PM	#7
halfpint GFY's Halfpint Industry Role: Join Date: Jun 2007 Location: UK Posts: 15,223	I have managed to find the table that is causing the problem Its saying it is 8.7MB in size but I cant browse it and I also have this warning at the bottom of the tables "1 May be approximate. See FAQ 3.11" I have no idea what that means When I download the table and open it with worpad it is empty. I dont know whether to just delete the table as I cant repair / check or optimize it and I have no idea what it contains either __________________ Get FREE website listings on Cryptocoinshops.net

06-25-2009, 01:55 PM	#11
rowan Too lazy to set a custom title Join Date: Mar 2002 Location: Australia Posts: 17,393	You can't view mysql tables with a word processor, they're in a proprietary binary format. DON'T go deleting any tables until you're 100% sure they're corrupted to hell and back (which is probably unlikely)... and even then I'd rename them and keep them anyway. Do you have SSH access? Or is Phat a fully managed host? If you have SSH, try this... mysql -u <username> -p ... enter your password ... use <database_name> check table <table_name> <-- repeat as many times as necessary If any tables show up errors, repair table <table_name> Last edited by rowan; 06-25-2009 at 01:56 PM..

06-25-2009, 12:25 PM	#4
who So Fucking Banned Join Date: Aug 2003 Location: ICQ #23642053 Posts: 19,593	Ask for your server to be restarted.

06-25-2009, 01:50 PM	#8
Killswitch - BANNED FOR LIFE Guest Posts: n/a	Hit up Moose and the fellas they should be able to help you... Sarettah, wtf you got in that database that takes it 6 hours to check/repair?

06-25-2009, 01:58 PM	#12
rowan Too lazy to set a custom title Join Date: Mar 2002 Location: Australia Posts: 17,393	Also, show processlist when logged into mysql will display what's happening... this may give you a hint why things seem to be "stuck" MySQL may also be writing an error log, in my setup it is located in the database directory and named <hostname>.err ... eg if your server is called www.mydomain.com the error log will be called www.mydomain.com.err Here's an example of a line showing a problem with a table... 090601 13:35:35 [ERROR] /usr/local/mysql/libexec/mysqld: Table './sdqueue/pre_urlqueue_e9' is marked as crashed and should be repaired

06-25-2009, 02:02 PM	#13
halfpint GFY's Halfpint Industry Role: Join Date: Jun 2007 Location: UK Posts: 15,223	Thanks Rowan and all the other guys for helping out and giving suggestions. Im gonna let the tech guys have a look at it now before I go deleting anything and completly screw things up __________________ Get FREE website listings on Cryptocoinshops.net

06-25-2009, 03:08 PM	#14
halfpint GFY's Halfpint Industry Role: Join Date: Jun 2007 Location: UK Posts: 15,223	Good old Phatservers has fixed the problem it seems the database got corrupted Thanks Phatservers for a great fast service __________________ Get FREE website listings on Cryptocoinshops.net