Mysql> repair table Xs;
+ --------- + -------- + ---------- +
| Table | op | msg_type | msg_text |
+ --------- + -------- + ---------- +
| Lina. Xs | repair | status | OK |
+ --------- + -------- + ---------- +
1 row in SET (0.00 Sec)
mysql> show profiles;
+ ---------- + ------------ + duration +
| query_id | duration | query |
+ ---------- + ------------ + duration +
| 1 | 0.00469700 | ALTER TABLE xs modify age int not null default 3 |
| 2 | 0.00023300 | drop table Xs |
| 3 | 0.00527100 | create table Xs (name varchar (12 ), age int default 5) |
| 4 | 0.00030300 | insert into Xs values ('A', 4) |
| 5 | 0.00403400 | alter table Xs alter column age set default 3 |
| 6 | 0.00088200 | repair table Xs |
+ ---------- + hour ----------------------------------------------------- +
6 rows in SET (0.00 Sec)
Mysql> show profile for query 6;
+ ---------------------- + ---------- +
| Status | duration |
+ ---------------------- + ---------- +
| Startling | 0.000151 |
| Opening tables | 0.000024 |
| System lock | 0.000008 |
| Table lock | 0.000034 |
| Repair with keycache | 0.000533 |
| Saving state | 0.000112 |
| Query end | 0.000004 |
| Freeing items | 0.000014 |
| Cleaningup | 0.000002 |
+ ---------------------- + ---------- +
9 rows in SET (0.00 Sec)
Repair table in 5.1