forse c'e' qualche problema

11:30am

mysql> check table profile;
+-------------+-------+----------+-------------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+-------------+-------+----------+-------------------------------------------------------------------------+
| vas.profile | check | warning | Table is marked as crashed |
| vas.profile | check | warning | Auto-increment value: 14464546 is smaller than max used value: 14464547 |
| vas.profile | check | error | Found key at page 516835328 that points to record outside datafile |
| vas.profile | check | error | Corrupt |
+-------------+-------+----------+-------------------------------------------------------------------------+
4 rows in set (32.24 sec)

mysql> repair table profile;
+-------------+--------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+-------------+--------+----------+----------+
| vas.profile | repair | status | OK |
+-------------+--------+----------+----------+
1 row in set (5 min 58.21 sec)


7:44pm

mysql> check table vas.profile;
+-------------+-------+----------+---------------------------------+
| Table | Op | Msg_type | Msg_text |
+-------------+-------+----------+---------------------------------+
| vas.profile | check | warning | Table is marked as crashed |
| vas.profile | check | error | Found 14458708 keys of 14458703 |
| vas.profile | check | error | Corrupt |
+-------------+-------+----------+---------------------------------+
3 rows in set (4.58 sec)

mysql>
mysql>
mysql> repair table vas.profile;
+-------------+--------+----------+-----------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+-------------+--------+----------+-----------------------------------------------------------+
| vas.profile | repair | info | Found block with too small length at 845796652; Skipped |
| vas.profile | repair | info | Wrong block with wrong total length starting at 881348260 |
| vas.profile | repair | info | Wrong block with wrong total length starting at 891424188 |
| vas.profile | repair | warning | Number of rows changed from 14458703 to 14458700 |
| vas.profile | repair | status | OK |
+-------------+--------+----------+-----------------------------------------------------------+
5 rows in set (6 min 22.54 sec)

posted by io @ 7:43 PM