… have prefix compression for its indexes, as MyISAM has which in certain cases makes them 10 …. Insert buffer for delete. For Insert operation Innodb uses nice tecnique called Insert Buffer which speeds up inserts …see it is too bad even with 4 concurrent queries). The problem seems to be at …
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
…architecture makes performance characteristics different to both MyISAM and InnoDB/XtraDB. Tests show that PBXT… an early stage) out performed InnoDB with INSERTS and UPDATES (but not SELECTS). That …key acceptance criteria are things like backup, concurrency, ACID compliance and crash recovery. As a…
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
… keep in memory much more records then InnoDB / MyISAM. Actually in internal cache records are stored in … than available memory. For the last 10M rows inserted, InnoDB averaged 1,555 rows/sec while TokuDB…’t get benefit of multi-core boxes running concurrent threads. Tokutek plans to fix this in one …
Comment: INSERT ON DUPLICATE KEY UPDATE and REPLACE INTO
October 26, 2011 By 15 Comments
… fields that I need in the log). The trigger uses INSERT ON DUPLICATE KEY UPDATE to achieve that. The problem is… reason in the code for that. I was wondering if INSERT … UPDATE might lock for read access (or lock only the… something simmilar) while checking for key value existence, as inserts in myisam are concurrent with reads, and then try to lock for write…
Post: Fix of InnoDB/XtraDB scalability of rollback segment
January 18, 2009 By 9 Comments
… sysbench write workload (benchmark emulates intensive insert/delete queries). By our results the problem is in concurrency on rollback segment, which by…] #mysqld options in alphabetical order user=root default_table_type=MYISAM innodb_buffer_pool_size=6G innodb_data_file_path=ibdata1…
Comment: Why MySQL could be slow with large tables ?
September 24, 2008 By 141 Comments
…) (where the pair id1, id2 forms the primary key) using INSERT … ON DUPLICATE KEY UPDATE cnt = cnt + 1. Obviously, the resulting…, help to increase “key_buffer_size”? Also, which storage engine (MyISAM?, InnoDB?) is supposed to work faster in this scenario (and…) available? Could I maybe disable some concurrency related checks (as I have exactly one process inserting into the table, which I could…
Post: Trying Archive Storage Engine
November 12, 2006 By 7 Comments
… this case. Original Table: *************************** 1. row *************************** Name: requests_061111 Engine: MyISAM Version: 9 Row_format: Dynamic Rows: 8048913 Avg_row_length… got this table by converting MyISAM table rather than incremental insertions. I also compared it to compressed MyISAM – this would take 1250MB so…. May be this is because server is loaded and having concurrent IO which randomizes otherwise sequential IO. It would be interesting…
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 … will see records in B which were modified/inserted after you started transaction. [-] Isolation Modes So … This is also why Falcon has Optimistic locking concurrency which can give you problems if you …
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
…9.85-beta.tar.gz Compilation parameters: For MyISAM / InnoDB ./configure –prefix=/usr/local/mysqltest/mysql- –…for 1, 4, 16, 64, 128, 256, 512 concurrent threads. 3. For each thread perform a warm… is also interesting to check PBXT performance on INSERT/UPDATE queries taking into account PBXT way …
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’, ’0…timeout=3600 key_buffer_size=32M # Only for MyISAM which isnt used. sort_buffer_size=2M …400M # Approx 20% of buffer pool innodb_thread_concurrency=64 # Default is 8 wich is a way…
