… table other transaction could modify the row and commit before transaction which is running INSERT .. SELECT statement. This would make this transaction to… to one of INSERT … SELECT you may execute this transaction in READ-COMMITTED isolation mode. Other workarounds are less general purpose. For… case write is done to MyISAM table so we’ll not see any write activity. Other transaction which happes to be simple…
Post: MySQL Storage Engines - PBXT
May 14, 2007 By 6 Comments
…. Paul was for a while comparing PBXT to MyISAM with multi versioning and transactions and this is valid comparison for good and… lose committed transactions if power goes down) furthermore in case of crash database may become corrupted, just as with MyISAM, and you… applies to multi-versioning – if you’re using consistent reads isolation mode this consistent reads is per database not global. We…
Post: Commodity Hardware, Commodity Software and Commodity People
June 15, 2007 By 9 Comments
… would just strip it but continue working, you can copy (MyISAM) table while server is running and it would typically work… giving you errors sometimes. No transactions means you do not have to deal with deadlocks or learn isolation modes. Perfect solution for… give you many storage engines to play with (many with transactions an some with clustering) with support of partitioning stored procedures…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…keynotes. Today let me start with most popular transactional storage engine for MySQL – Innodb. Innodb Storage … INFILE be optimized same way as for MyISAM tables by separate phase of building Indexes ? … cases can be removed for READ-COMMITED isolation mode which will start offering more performance …
Comment: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
… some are environment related – log flushing on transaction commit, size of log files etc. Regarding …emphasize it in current Limits section though. Isolation Modes: Innodb, Oracle, PostgreSQL also support …so concurrency increases – on low concurrency even MyISAM with table level locks does just fine…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…SaaS hosted application for data mining stock market transactions,” or whatever the case may be we’ve…an indication that it’s time to convert MyISAM tables to InnoDB. (But then again, it might…one of these factors (schema, queries, indexing) in isolation, because they are tightly bound together, and …
Comment: Stored Function to generate Sequences
April 3, 2008 By 17 Comments
If you change sequence name from varchar to char you’ll get fixed-width table (slightly faster). It’s probably important that sequences are in MyISAM table that doesn’t support transactions – otherwise different threads would be isolated (I in ACID) and could come up with the same sequence value!
