… used 6.2x less disk space than InnoDB, and 5.5x less disk space than MyISAM. For tests I used …bigger than available memory. For the last 10M rows inserted, InnoDB averaged 1,555 rows/sec while TokuDB …can’t get benefit of multi-core boxes running concurrent threads. Tokutek plans to fix this in one …
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
… storage engines, it certainly can be applied for MyISAM and Innodb. I remember there were plans to… were inserted in different times a lot of scattered reads will be needed. Think about typical use of…. This is also why Falcon has Optimistic locking concurrency which can give you problems if you have…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
…MyISAM vs Falcon (http://www.mysqlperformanceblog.com/2007/01/08/innodb-vs-myisam-vs-falcon-benchmarks-part-1) The difference is I used…, 4, 16, 64, 128, 256, 512 concurrent threads. 3. For each thread perform…also interesting to check PBXT performance on INSERT/UPDATE queries taking into account PBXT…
Post: Trying Archive Storage Engine
November 12, 2006 By 7 Comments
… got this table by converting MyISAM table rather than incremental insertions. I also compared it to compressed MyISAM – this would take 1250MB so… having concurrent IO which randomizes otherwise sequential IO. It would be interesting to know which buffer size Archive storage engine using for…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…’Com_ha_read’, ’0′ ‘Com_help’, ’0′ ‘Com_insert‘, ’17889656′ ‘Com_insert_select’, ’11′ ‘Com_kill’, ’47′ ‘Com_load’, ‘…3600 key_buffer_size=32M # Only for MyISAM which isnt used. sort_buffer_size=2M query_cache_size=…400M # Approx 20% of buffer pool innodb_thread_concurrency=64 # Default is 8 wich is a …
Comment: Why MySQL could be slow with large tables ?
September 24, 2008 By 141 Comments
… the pair id1, id2 forms the primary key) using INSERT … ON DUPLICATE KEY UPDATE cnt = cnt + 1. … “key_buffer_size”? Also, which storage engine (MyISAM?, InnoDB?) is supposed to work faster in … I maybe disable some concurrency related checks (as I have exactly one process inserting into the table,…
Comment: Using MyISAM in production
May 1, 2008 By 36 Comments
… points. But with innodb we use repeatable-read concurrency with update if not rows been updated then insert kind of transactions. At the… was as succesful as with MyISAM even it is doing its job not by parallel ( but inserts are faster works and/or…
Comment: Using MyISAM in production
December 7, 2006 By 36 Comments
… many concurrent threads do you have, how many tables you insert to and how large is data size. Single thread will only use single CPU plus MyISAM has table locks so inserts in…
Post: Performance impact of complex queries
January 17, 2007 By 11 Comments
…even if you just have one such query running concurrently. Lets talk a bit how it is happening… them to the master using mysqldump, or even careful file transfer if you’re using MyISAM tables. Chop it…If you delete things do DELETE … LIMIT 1000 and insert sleep 10; in between. By spreading load this…
Comment: MySQL Server Memory Usage
December 20, 2012 By 21 Comments
… 150M key_buffer = 256M key_buffer_size = 256M myisam_sort_buffer_size = 16M join_buffer_size =… = 10000 read_rnd_buffer_size = 8M bulk_insert_buffer_size = 8M query_cache_limit = 254M… InnoDB #thread_concurrency = 32 innodb_buffer_pool_size = 4096M innodb_lock_wait_timeout = 120 innodb_use_sys_malloc…
