…conflicts this actually may be good because it is simplier – you do not have…for rows to be unlocked. But wait why is it waiting if it suppose to…; +—-+———–+ | id | names | +—-+———–+ | 1 | Mysql | | 2 | Solid | | 3 | MyISAM | +—-+———–+ Session1: mysql> begin; Query OK, 0 …
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…_ENGINE_SUBSTITUTION value by default which is good change as trying to create Innodb table but getting MyISAM because Innodb was disabled for some reason was very error prone gotcha. Note this is as far as…. Very welcome change ! thread_cache_size is enabled by default, though I wonder why default value is 9. In any case very welcome…
Post: MyISAM Scalability and Innodb, Falcon Benchmarks
October 12, 2007 By 10 Comments
…MyISAM tables. We saw that several times in synthetic benchmarks but never in production, that’s why we did not escalate MyISAM…good enough for performance gotcha illustration purposes. The benchmark shows following results for MyISAM…. The problem in this case is key buffer contention which unlike …
Post: Rendundant Array of Inexpensive Servers
August 21, 2008 By 15 Comments
…long time (in particular if you’re using MyISAM tables) which can cause the error to propagate…- it is paranoid and this is how you want your data storage to be. This is also why Sun is so… of hard drive failure and this is good because recovering database servers is not fully automated in most cases….
Post: How much space does empty Innodb table take ?
December 16, 2008 By 7 Comments
… for MyISAM. This is ignored space which needs to be allocated in main tablespace for Innodb data dictionary. But that one is pretty small. This is the good reason to avoid having very small Innodb tables – they will take much more space than MyISAM… 32 pages so It is surprising why all of them take 5MB (because 4MB are free) What is clear however is what if some…
Post: Multi Column indexes vs Index Merge
September 19, 2009 By 31 Comments
…). Lets see why it is the case. MySQL indexes are (with few exceptions) BTREE indexes – this index type is very good to be able… is covering index) MySQL gets a “row pointer” which can be primary key value (for Innodb tables) physical file offset (for MyISAM tables) or something else. It is important internally storage engine can use that value…
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 15 Comments
…why application falls behind and why we see those lag spikes: Slave Server Load – MySQL Replication goes in single thread so it is…the Slave expect lag spike. For example MyISAM slaves used for long reporting queries …adapt to lag time rather than break is very good idea. Especially it will be handy…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 141 Comments
… SELECTS: 1 million Since this is a predominantly SELECTed table, I went for MYISAM. My my.cnf variables were … execute in 0.00 seconds. The problem was: why would this table get so fragmented or come …re fine. MySQL, I have come to realize, is as good as a file system on steroids and nothing more…
Comment: Air traffic queries in MyISAM and Tokutek (TokuDB)
November 10, 2009 By 26 Comments
… think I explained why I took TokuDB. It has interesting index structure which may make it more suitable than MyISAM and InnoDB, and you actually can see that from queries time. Load time is not good for TokuDB, but…-once as in original post), it took over 9h for MyISAM, but for TokuDB the same 5.5h
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
…as plugins. Two aspects why I’m especially interested about it is Sphinx which is currently implemented as …problem. There are fair amount of issues with MyISAM and generally on MySQL level which needs to…is very good sign. There is still fair amount of work to do to straighten up this process so good…
