… our clients to convert their current database from MyISAM …ATTEMPS) { $res = $this->query($query); if(!$res && ( $this->errno== ‘1205‘ || $this->errno == ’1213′ ) ) continue; else break; } } … } … There is the standard script mysql_convert_table_format in the MySQL distribution, but it requires …
Post: Test Drive of Solid
September 22, 2006 By 5 Comments
… test2 values (1,’Mysql‘),(2,’Solid’),(3,’MyISAM’); mysql> begin; mysql> update test2 set names=’mysql‘ where id=1; Session 2: mysql> begin; mysql> update test2… here – but not – just waiting… In 30 sec Session1: ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction So as… under sysbench and got next (1 client): mysql> begin; Query OK, 0 rows affected (0.00 sec) mysql> UPDATE sbtests set k=k…
