June 19, 2013

Post: Virident vCache vs. FlashCache: Part 2

May 17, 2013 By 3 Comments

…more sense to configure MySQL as if it were using SSD storage or to just use an optimized HDD storage configuration? …_size = 64M server­id = 101 key_buffer_size = 8M read_buffer_size = 1M read_rnd_buffer_size = 4M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size…

Filed Under: Benchmarks, Hardware and Storage, MySQL Tagged With: , , , , , , ,

Post: Ultimate MySQL variable and status reference list

January 8, 2011 By 4 Comments

…amazing MySQL manual, especially the option and…_useblogpercona.commanual bootstrapblogpercona.commanual bulk_insert_buffer_sizeblogpercona.commanual Bytes_receivedblogpercona…..commanual optimizer_prune_levelblogpercona.commanual optimizer_search_depthblogpercona.commanual optimizer_switchblogpercona…

Filed Under: Insight for DBAs, MySQL

Post: MySQL Server Variables - SQL layer or Storage Engine specific.

June 8, 2006 By 14 Comments

…bulk_insert_buffer_size – Used by MyISAM tables only to optimize bulk inserts (multiple value inserts). Really helps if you have really bulk inserts 100-1000+ values per single insert…

Filed Under: Insight for DBAs Tagged With: ,

Post: MySQL Server Memory Usage

May 17, 2006 By 21 Comments

…buffer_size, query_cache_size. If you’re using MyISAM seriously you can also add the size of Operation System cache you would like MySQL… larger – bulk inserts may allocate bulk_insert_buffer_size bytes of memory if done to MyISAM tables. myisam_sort_buffer_size used for ALTER TABLE, OPTIMIZE TABLE, …

Filed Under: Insight for DBAs Tagged With: , ,

Post: Aligning IO on a hard disk RAID – the Benchmarks

June 9, 2011 By 13 Comments

…Optimal WT, RA PhysiclDev Type State Errors Vendor Model Size …MySQL configurations, I didn’t try out different MySQL…size = 16M max_heap_table_size = 64M thread_cache_size = 32 query_cache_size = 0 tmp_table_size = 64M key_buffer_size = 8M bulk_insert_buffer_size = 8M myisam_sort_buffer_size…

Filed Under: MySQL

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

…bulk insert performance. At the very bottom, the page claims that you can speed up bulk…optimize_start_time | | | optimize_end_time | | | stopword_table_name | | | use_stopword | 1 | | table_state | 0 | +—————————+———+ 10 rows in set (0.02 sec) mysql> optimize…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: Predicting how long data load would take

May 24, 2007 By 14 Comments

… set for optimal load speed. Depending on load type MyISAM may benefit from bulk_insert_tree_size increase myisam_sort_buffer_size or key_buffer_size increase. Innodb…_buffer_pool_size and large innodb_log_file_size to perform load effectively Load Options There two main ways to load data in MySQL…

Filed Under: Insight for DBAs Tagged With: ,

Post: MySQL Users Conference - Innodb

May 9, 2007 By 6 Comments

…looking at compressed page size distribution you can tell which page size will be optimal – will allow to …all 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 the…

Filed Under: Events and Announcements Tagged With:

Post: Heikki Tuuri answers to Innodb questions, Part II

November 4, 2007 By 13 Comments

…buffer_pool_size Q36: There have been several MySQL bugs opened about multi-core scalability (concurrent queries, autoincrement, concurrent inserts…OPTIMIZE? HT: Since OPTIMIZE rebuilds the whole table, it may last way too long for your 150 GB table! If you have inserted…

Filed Under: Insight for Developers Tagged With: