… It has exactly one table. MYISAM table with the following activity: Per day: 1. INSERTS: 1,000 2. UPDATES:…var/log/mysql-slow.log sql-mode=TRADITIONAL concurrent_insert=2 low_priority_updates=1 The problem was… my experience. I know some big websites are using MySQL, but we had neither the budget to…
Post: Quick comparison of MyISAM, Infobright, and MonetDB
September 29, 2009 By 30 Comments
… loading the data with SQL statements. I wanted to see how fast MyISAM vs. MonetDB would interpret really large INSERT statements, the kind… quite useful. However, I’m not quite sure it’s useful for “general-purpose” database use — there are a number of limitations (concurrency, for…
Post: My Innodb Feature wishes
May 4, 2006 By 30 Comments
…. In many cases then difference in Performace with MyISAM and Innodb is huge for read only…. Insert buffer for delete. For Insert operation Innodb uses nice tecnique called Insert Buffer which speeds up inserts for…with large number of CPUs (in this bug you can see it is too bad even with 4 concurrent…
Post: MySQL Slow query log in the table
May 31, 2007 By 1 Comment
… had in previous versions. We rarely would use this feature as it is incompatible with our slow query analyses patch and tools… MyISAM, disable concurrent inserts and run long reporting query on the log file query execution is still proceeds. I have not checked if concurrent insert…
Comment: INSERT ON DUPLICATE KEY UPDATE and REPLACE INTO
October 26, 2011 By 15 Comments
I’m using a trigger on an innodb table that “dumps” any updates to the table to a myisam table holding a… selected fields that I need in the log). The trigger uses INSERT ON DUPLICATE KEY UPDATE to achieve that. The problem is… something simmilar) while checking for key value existence, as inserts in myisam are concurrent with reads, and then try to lock for write access…
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
…with Falcon if rows were inserted in different times a lot of scattered reads will be needed. Think about typical use… is also why Falcon has Optimistic locking concurrency which can give you problems if …Does row ever split into multiple parts like with MyISAM or always stored as single piece ? These…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
…/08/innodb-vs-myisam-vs-falcon-benchmarks-part-1) The difference is I used new sysbench with Lua scripting … for 1, 4, 16, 64, 128, 256, 512 concurrent threads. 3. For each thread perform a warm…It is also interesting to check PBXT performance on INSERT/UPDATE queries taking into account PBXT way to…
Comment: Using MyISAM in production
May 1, 2008 By 36 Comments
…, I agree with you on some points. But with innodb we use repeatable-read concurrency with update if not rows been updated then insert kind of… nothing was as succesful as with MyISAM even it is doing its job not by parallel ( but inserts are faster works and/or…
Post: Test Drive of Solid
September 22, 2006 By 5 Comments
… see SELECT FOR UPDATE does not play nicely with OPTIMISTIC concurrency. Generally you would use this statement to ensure rows are locked at…: Deadlock detection (deadlock is correctly detected): insert into test2 values (1,’Mysql’),(2,’Solid’),(3,’MyISAM‘); Session1: mysql> begin; Query OK, 0…
Comment: COUNT(*) vs COUNT(col)
April 11, 2007 By 45 Comments
…rows since only one transaction executes at any time, because MyISAM does table-level locking. After a transaction commits, it is… presence of updates (including deletes and inserts). However, with InnoDB, which uses row-level locking, there are multiple concurrently executing (and as-yet uncommitted…
