SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 07:02 AM
| ||||
| ||||
 30 % of my databases dissapeared Hey guys, I have a big Problem. About 30 % of my databases just disappeared around 6pm today. I do not have any clue how this happened. Is can just guess the time it happened from my munin graphs. The only thing that might be a clue are the following files in my data directory: h1314631:~# ll /data/mysql/#sql_1a03_3.MY* -rw-rw---- 1 mysql mysql 0 2007-10-10 21:20 /data/mysql/#sql_1a03_3.MYD -rw-rw---- 1 mysql mysql 1,0K 2007-10-10 21:20 /data/mysql/#sql_1a03_3.MYI h1314631:~# cat /data/mysql/#sql_1a03_3.MYI %?????????????????????????????G ??e ?eA???? ??e 3e The date does not match, but I'm wondering where they come from anyways. There are about 1200 of them with about 5000 databases left, from 7500! Where could I get a clue about what happened? Regards, Samy      |
|
02-28-2008, 07:02 AM
| |||
| |||
| Re: 30 % of my databases dissapeared Hey, Thanks for the very fast reply. Of course I forgot that I'm running Linux Debian Etch with mysql 5.0.45 from backports. We have a 20GB quota set for MySQL. Before the crash about 9GB where used, now it's down to 5GB. I will unmount the disk and check the XFS filesystem and report back here! Regards, Samy Michael Dykman schrieb: > What system are you on? What is your disk capacity? It looks like > the disk got corrupted.. How *that* happened is hard to say, but > know what host OS/hardware you are on would give us a first clue. > > - michael > > > On Dec 6, 2007 2:42 PM, Samuel Vogel <samy-delux@gmx.de> wrote: > >> Hey guys, >> >> I have a big Problem. About 30 % of my databases just disappeared around >> 6pm today. I do not have any clue how this happened. Is can just guess >> the time it happened from my munin graphs. >> >> The only thing that might be a clue are the following files in my data >> directory: >> h1314631:~# ll /data/mysql/#sql_1a03_3.MY* >> -rw-rw---- 1 mysql mysql 0 2007-10-10 21:20 >> /data/mysql/#sql_1a03_3.MYD >> -rw-rw---- 1 mysql mysql 1,0K 2007-10-10 21:20 >> /data/mysql/#sql_1a03_3.MYI >> h1314631:~# cat /data/mysql/#sql_1a03_3.MYI >> %?????????????????????????????G >> >> >> ??e ?eA???? >> ??e >> >> 3e >> >> The date does not match, but I'm wondering where they come from anyways. >> There are about 1200 of them with about 5000 databases left, from 7500! >> >> Where could I get a clue about what happened? >> >> Regards, >> Samy >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: http://lists.mysql.com/mysql?unsub=mdykman@gmail.com >> >> >> > > > > |
|
02-28-2008, 07:02 AM
| ||||
| ||||
| Re: 30 % of my databases dissapeared Ok, I ran xfs_check and the filesystem is all well. Does anybody else have an idea? Regards, Samy Samuel Vogel schrieb: > Hey, > > Thanks for the very fast reply. > Of course I forgot that I'm running Linux Debian Etch with mysql > 5.0.45 from backports. > > We have a 20GB quota set for MySQL. Before the crash about 9GB where > used, now it's down to 5GB. I will unmount the disk and check the XFS > filesystem and report back here! > > Regards, > Samy > > Michael Dykman schrieb: >> What system are you on? What is your disk capacity? It looks like >> the disk got corrupted.. How *that* happened is hard to say, but >> know what host OS/hardware you are on would give us a first clue. >> >> - michael >> >> >> On Dec 6, 2007 2:42 PM, Samuel Vogel <samy-delux@gmx.de> wrote: >> >>> Hey guys, >>> >>> I have a big Problem. About 30 % of my databases just disappeared >>> around >>> 6pm today. I do not have any clue how this happened. Is can just guess >>> the time it happened from my munin graphs. >>> >>> The only thing that might be a clue are the following files in my data >>> directory: >>> h1314631:~# ll /data/mysql/#sql_1a03_3.MY* >>> -rw-rw---- 1 mysql mysql 0 2007-10-10 21:20 >>> /data/mysql/#sql_1a03_3.MYD >>> -rw-rw---- 1 mysql mysql 1,0K 2007-10-10 21:20 >>> /data/mysql/#sql_1a03_3.MYI >>> h1314631:~# cat /data/mysql/#sql_1a03_3.MYI >>> %?????????????????????????????G >>> >>> >>> ??e ?eA???? >>> ??e >>> >>> 3e >>> >>> The date does not match, but I'm wondering where they come from >>> anyways. >>> There are about 1200 of them with about 5000 databases left, from 7500! >>> >>> Where could I get a clue about what happened? >>> >>> Regards, >>> Samy >>> >>> -- >>> MySQL General Mailing List >>> For list archives: http://lists.mysql.com/mysql >>> To unsubscribe: http://lists.mysql.com/mysql?unsub=mdykman@gmail.com >>> >>> >>> >> >> >> >> > > |
 |
« REPLICATION
|
MySql on Leopard »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 05:10 AM.
