MySQL Locking Up
- by Ian
I've got a innodb table that gets a lot of reads and almost no writes (like, 1 write for every 400,000 reads approx).
I'm running into a pretty big problem though when I do INSERT into the table. MySQL completely locks up. It uses 100% cpu, and every single other table (in other databases even) have their statuses set to "Locked" until the INSERT is done. This is a big problem because MySQL stays locked up for up to 4 minutes.
I'm using version 5.1.47 (rpm from mysql.com).
Any ideas?