terzo giorno...

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

mysql> repair table profile;
+-------------+--------+----------+-----------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+-------------+--------+----------+-----------------------------------------------------------+
| vas.profile | repair | info | Found block with too small length at 249722308; Skipped |
| vas.profile | repair | info | Found block with too small length at 829560912; Skipped |
| vas.profile | repair | info | Found block with too small length at 883060448; Skipped |
| vas.profile | repair | info | Wrong block with wrong total length starting at 885037444 |
| vas.profile | repair | info | Found block with too small length at 886036144; Skipped |
| vas.profile | repair | info | Found block with too small length at 894905684; Skipped |
| vas.profile | repair | info | Found block with too small length at 895981896; Skipped |
| vas.profile | repair | info | Found block with too small length at 898681688; Skipped |
| vas.profile | repair | info | Found block with too small length at 905343804; Skipped |
| vas.profile | repair | info | Found block with too small length at 907800072; Skipped |
| vas.profile | repair | warning | Number of rows changed from 14497441 to 14497431 |
| vas.profile | repair | status | OK |
+-------------+--------+----------+-----------------------------------------------------------+
12 rows in set (5 min 51.93 sec)

mysql> optimize table profile;
+-------------+----------+----------+---------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+-------------+----------+----------+---------------------------------------------------------+
| vas.profile | optimize | info | Found block with too small length at 666642136; Skipped |
| vas.profile | optimize | warning | Number of rows changed from 14497477 to 14497475 |
| vas.profile | optimize | status | OK |
+-------------+----------+----------+---------------------------------------------------------+
3 rows in set (8 min 35.56 sec)

mysql>

posted by io @ 3:37 PM