…to be 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…buffer_pool_size and large innodb_log_file_size to perform load effectively Load Options There two main ways to load data in MySQL…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…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…to IO alignment yourself. In this case offset is correct, but file system is unaware how to…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…to be moved to the hot portion. In MySQL 5.5 and earlier, innodb_old_blocks_time defaults to…buffer pool in pages afterwards: mysql> select sq.*, pages / (@@innodb_buffer_pool_size / 16384) * 100 pct_buffer…optimizing…KEY(C_Name), KEY(C_City), KEY(C_Region), KEY(C_Phone), KEY…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… – choosing innodb_buffer_pool_size Q36: There have been several MySQL bugs opened …how long will this take? Is there a facility we can run to show any table / index fragmentation, without having to run the OPTIMIZE…in an ascending order of the PRIMARY KEY, then InnoDB should have placed the rows in…
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
…sized in the release we tested it is hard to see how small indexes really are. [-] No “using index” Falcon always have to…in MySQL anyway though). Very interesting to see how this one will compare to…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…MySQL AB made new storage engine Falcon available for wide auditory. We cannot miss this event and executed several benchmarks to see how…=root –key-buffer-size=1500M –innodb-buffer-pool-size=1500M –innodb-log-file-size=100M –… very common optimization we use in our practice. READ_KEY_POINT_NO_…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…how to read these, there’s a full explanation in our book, High Performance MySQL 2nd Edition (it’s not in…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
…buffer_size=4M 4M is good for most cases unless you’re piping large blobs to Innodb in…in MySQL 4.1 and now stable enough to use. Also check if your application can run in…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…size distribution you can tell which page size will be optimal – will allow to…in INSERT IGNORE and ON DUPLICATE KEY UPDATE cases. Now In MySQL 5.1+ it is also possible to…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…how do you determine the memory consumption per connection in average? This leads to…tables’, ’102′ ‘Com_optimize‘, ’0′ ‘Com_preload_keys‘, ’0′ ‘Com_…mysql/slow-queries.log max_connections=650 open_files_limit=6144 max_connect_errors=10000 interactive_timeout=3600 wait_timeout=3600 key_buffer_size…
