…repaired, each may allocate myisam_sort_buffer_size and MySQL could crash or go swapping. Second…has to be one insert at the time. Happily inserts in MyISAM are …if you need to run some bulk operations. For example running full …adjust that or you can simply set low_priority_updates option. Anyway …
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… compression page settings by looking at compressed page size distribution you can tell which page size will be … insert cases – in fact if the insert is single value insert or the number of values in the bulk…areas in Innodb than buffer-pool which had it locking relaxed in latest MySQL 5.0 Hopefully …
Post: How many partitions can you have ?
December 5, 2009 By 19 Comments
…(1000001) ); I used MySQL 5.1.41 for my tests increasing buffer pool to 1G and log file size to 128M so all… UPDATE path on INSERT OF DUPLICATE KEY UPDATE (adding ON DUPLICATE KEY UPDATE set c=c+1 to my bulk inserts) the regression became even larger. 1 partition insert took 50 seconds to…
Comment: Should you move from MyISAM to Innodb ?
January 21, 2009 By 59 Comments
… perform bulk inserts (i.e. values (),(),(),…). I set the innodb_buffer_pool_size to 1G (having 4G ram) which seems to be the highest buffer allowed. if exeeded, mysql does not…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…with read-ahead depth here. These settings mean there can be quite … which Mysql is the main one with “innodb_buffer_pool_size=20480Mâ€) while the bulk…buffer_pool_size Q36: There have been several MySQL bugs opened about multi-core scalability (concurrent queries, autoincrement, concurrent inserts…
