…to tell what is really happening. Test 3: Phantom rows: Table before test: select * from test2; +—-+——–+ | id | names | +—-+——–+ | 1 | Mysql | | 2 | Solid | | 3 | MyISAM…LOCK IN SHARE MODE) as only actual row versions can be locked. With Innodb we would get “SolidDB2″ as result. mysql…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
…to bypass cache for your Innodb tables but there are other things you need OS cache for – MyISAM tables (mysql…to play with. Finally you can try locking MySQL in memory by using –memlock – just be careful as in…
Post: Performance impact of complex queries
January 17, 2007 By 11 Comments
…how it is happening and how to prevent it. Cache Wiping This is first reason for this to…MySQL Itself employs various strategies to attempt to…tables on the slave and when move them to the master using mysqldump, or even careful file transfer if you’re using MyISAM tables…
Comment: Pitfalls of converting to InnoDB
February 26, 2007 By 16 Comments
…MyISAM you were not getting any because it did not support transactions and used only table level locks which had to…because of how data is accessed. If you want to avoid …No there is no option on MySQL level to solve this problem because only application knows what to do in the case of deadlock. In…
