In the last episode (May 15), Dan Buettner said:
> Hi Edoardo -
> I think you've been misinformed; MyISAM tables do not support
> simultaneous read and write operations. MyISAM is a multiple
> reader/single writer, table locking design. You may want to switch
> to InnoDB tables for that functionality.
MyISAM tables do allow concurrent inserts and selects, by appending the
newly-inserted records to the end of the table:
Some things to try would be setting concurrent_insert=2 (to force
concurrent inserts even if there are holes in the table) or setting
low_priority_updates=1 ( to keep inserts from trying to lock the table
when there are pending selects ). If those don't help, then you may be
forced to switch to InnoDB, or maybe set up replication and run your
reporting queries on the slave.