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

X

halfpint

GFY's Halfpint

Join Date: Jun 2007

Posts: 15223
Share

Post
#1

What causes a MySQL database to hang ??

06-25-2009, 11:04 AM

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
Tags: None
sarettah

see you later, I'm gone

Join Date: Oct 2002

Posts: 14378
Share

Post
#2

06-25-2009, 11:23 AM

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?

All cookies cleared!
Comment
halfpint

GFY's Halfpint

Join Date: Jun 2007

Posts: 15223
Share

Post
#3

06-25-2009, 11:23 AM

Im on the phpmyadmin

Get FREE website listings on Cryptocoinshops.net
Comment
who

So Fucking Banned

Join Date: Aug 2003

Posts: 19593
Share

Post
#4

06-25-2009, 11:25 AM

Ask for your server to be restarted.
Comment
sarettah

see you later, I'm gone

Join Date: Oct 2002

Posts: 14378
Share

Post
#5

06-25-2009, 11:30 AM

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

All cookies cleared!
Comment
boneless

Confirmed User

Join Date: Dec 2002

Posts: 3625
Share

Post
#6

06-25-2009, 11:39 AM

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

icq:148573096 skype:dabone2 email:boneless(a)mgpteam(.)com
Comment
halfpint

GFY's Halfpint

Join Date: Jun 2007

Posts: 15223
Share

Post
#7

06-25-2009, 12: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

Get FREE website listings on Cryptocoinshops.net
Comment
Killswitch - BANNED FOR LIFE
Share

Post
#8

06-25-2009, 12: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?
Comment
halfpint

GFY's Halfpint

Join Date: Jun 2007

Posts: 15223
Share

Post
#9

06-25-2009, 12:52 PM

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

Get FREE website listings on Cryptocoinshops.net
Comment
sarettah

see you later, I'm gone

Join Date: Oct 2002

Posts: 14378
Share

Post
#10

06-25-2009, 12:53 PM

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

All cookies cleared!
Comment
rowan

Too lazy to set a custom title

Join Date: Mar 2002

Posts: 17393
Share

Post
#11

06-25-2009, 12: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>

Last edited by rowan; 06-25-2009, 12:56 PM.
Comment
rowan

Too lazy to set a custom title

Join Date: Mar 2002

Posts: 17393
Share

Post
#12

06-25-2009, 12: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
Comment
halfpint

GFY's Halfpint

Join Date: Jun 2007

Posts: 15223
Share

Post
#13

06-25-2009, 01: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

Get FREE website listings on Cryptocoinshops.net
Comment
halfpint

GFY's Halfpint

Join Date: Jun 2007

Posts: 15223
Share

Post
#14

06-25-2009, 02:08 PM

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
Comment
Killswitch - BANNED FOR LIFE
Share

Post
#15

06-25-2009, 02:35 PM

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.
Comment
halfpint

GFY's Halfpint

Join Date: Jun 2007

Posts: 15223
Share

Post
#16

06-25-2009, 02:49 PM

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

Get FREE website listings on Cryptocoinshops.net
Comment
XSV

Confirmed User

Join Date: Sep 2001

Posts: 1214
Share

Post
#17

06-25-2009, 02:49 PM

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.

Managed - E3 QC 2 x 500 GB SSD's / 32 GB RAM / 100 Mbps On Gig Port + 10 TB CDN Traffic $299/mo

** NEW MANAGED 10 TB CDN SERVERS FROM $199 PER MONTH - 50% Off Trial Code: AMNOCDEAL**

DIY DEAL: Unmanaged Root Server Plans - 50% OFF For Life! • Windows + Linux • Coupon Code: SUMMERDED16
Comment
halfpint

GFY's Halfpint

Join Date: Jun 2007

Posts: 15223
Share

Post
#18

06-25-2009, 02:56 PM

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

Get FREE website listings on Cryptocoinshops.net
Comment
Killswitch - BANNED FOR LIFE
Share

Post
#19

06-25-2009, 03:39 PM

Originally posted by XSV

You have an , we you.

Cheesiest use of smilies EVAR!
Comment

Previous template Next

Working...