…with DRBD. When you run …get roughly 1.67x the …replicate only some tables from master to slave, and… you use the BLACKHOLE storage engine) in…an external lock manager. You… in AWS, got the volume …errors. I was able to get the server up with –skip-grant-tables and insert a few rows into an InnoDB table…
Post: MySQL Error Message Nonsenses
March 16, 2008 By 7 Comments
…use same error codes for same kind of error complicating automatic handling. When we tested different transactional storage engines we surely saw lock related tables being far from…
Post: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
…when ISAM and friends were the only storage engines…uses memory to execute; so do temporary tables. The following query creates at least 2 temporary tables: select * from ( select * from ( select 1…
Post: Test Drive of Solid
September 22, 2006 By 5 Comments
… from test2 where id=2; ERROR 1213 (40001): Deadlock found when trying to get lock… sec: ERROR 1031 (HY000): Table storage engine for ‘test2′ doesn’t have this option Strange error…use SolidDB instead of Innodb complicated. P.S. After previous experiments I tried SolidDB under sysbench and got next (1…
