…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…
