Tag - MyISAM

Can you Trust CHECK TABLE ?

Take a look at this:

Shell

mysql> repair table a3;
+———+——–+———-+———-+
| Table | Op | Msg_type | Msg_text |
+———+——–+———-+———-+
| test.a3 | repair | status | OK |
+———+——–+———-+———-+
1 row in set (0.10 sec)

mysql> select * from a3 order by i;
+————+
| i […]

Read more

Concurrent inserts on MyISAM and the binary log

Recently I had an interesting surprise with concurrent inserts into a MyISAM table. The inserts were not happening concurrently with SELECT statements; they were blocking and the process list was filling up with queries in Locked status.
My first thought was that the customer had deleted from the table, which leaves “holes” in the […]

Read more