4 messages in com.mysql.lists.bugsRe: 2GB kernel filesize limit and myi...| From | Sent On | Attachments |
|---|---|---|
| Martin MOKREJŠ | 23 Nov 2001 08:07 | |
| Martin MOKREJŠ | 23 Nov 2001 09:34 | |
| Martin MOKREJŠ | 23 Nov 2001 09:59 | |
| Michael Widenius | 23 Nov 2001 18:36 |
| Subject: | Re: 2GB kernel filesize limit and myisam tables![]() |
|---|---|
| From: | Martin MOKREJŠ (mmok...@natur.cuni.cz) |
| Date: | 11/23/2001 09:59:03 AM |
| List: | com.mysql.lists.bugs |
On Fri, 23 Nov 2001, Martin MOKREJŠ wrote:
Hi, just a follow-up when I tried to repair the table I started the repair command. It was repaired OK, I run check table command and after a minute typed into the screen buffer next commands (because I thought it will give status OK. But no, because there was record pointing outside the table but the reported status was anyway OK (weird). I re-run the check table and it me *only* OK. So how did that record pointing outside got fixed? Or why did the first check table run report something untrue? Was the reason for that that I between those two CHECK TABLE commands switched the databases?
mysql> check table intergenome_data;
mysql>
mysql> check table intergenome_data;
+------------------------------+-------+----------+---------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text
|
+------------------------------+-------+----------+---------------------------------------------------------------+
| Bhalodurans.intergenome_data | check | warning | Table is marked as crashed
|
| Bhalodurans.intergenome_data | check | error | Size of datafile is:
2147483647 Should be: 2147486672 |
| Bhalodurans.intergenome_data | check | error | Corrupt
|
+------------------------------+-------+----------+---------------------------------------------------------------+
3 rows in set (0.01 sec)
mysql> repair table intergenome_data;
use Clostridium_acetobutylicum_ATCC824;
check table intergenome_data;
+------------------------------+--------+----------+---------------------------------------------------------+
| Table | Op | Msg_type | Msg_text
|
+------------------------------+--------+----------+---------------------------------------------------------+
| Bhalodurans.intergenome_data | repair | info | Found block that points
outside data file at 2147463992 |
| Bhalodurans.intergenome_data | repair | status | OK
|
+------------------------------+--------+----------+---------------------------------------------------------+
2 rows in set (23 min 1.01 sec)
Soorry, this output is from REPAIR TABLE, not from CHECK TABLE yet! I'm idiot. So you can ignore this follow-up post.
-- Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs MIPS / Institute for Bioinformatics <http://mips.gsf.de> GSF - National Research Center for Environment and Health Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany tel.: +49-89-3187 3616 , fax: +49-89-3187 3585




