… threads) with fast IO (OCZ R4 1.6TB) and 128GB memory. For the hot test, the data fits in the buffer pool…. Notes MySQL version used: 5.6.11, custom compiled to remove performance_schema For the InnoDB tests, a 64GB buffer pool was…=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb_log_file_size=4G innodb_file_per_table…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool dumps can be produced… fixed #1130145. Percona XtraBackup didn’t initialize per-thread data in the log copying thread which could cause XtraBackup to crash. Bug fixed…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…threads (8 cores on a single socket x 2 threads per socket), while the second one use 16 cores (8 cores per socket per…buffer_size = 16M innodb_buffer_pool_size = 52G innodb_log_file_size = 2000M innodb_log_files_in_group = 2 innodb_file_per…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
….11 at 128 threads. Then we loaded 10x dataset – 100M ids (size of datadir ~100GB), size of the buffer pool is the… combination I got ~15k operations per second for MySQL 5.6.11. Conclusion: In CPU-bounds case MySQL performs quite well, though we…_log_buffer_size=128M innodb_max_dirty_pages_pct=80 innodb_file_format=barracuda innodb_file_per_table innodb_read_io_threads = 8…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… / 1000000; While this benchmark doesn’t show any multi-threading or other advanced operation, it is using identical…per/cmd 0.3208 ms min per/cmd 0.4159 ms max per/cmd 0.0951 ms range per/cmd InnoDB MySQL…per/cmd 0.0802 ms range per/cmd Keep in mind that the entire data set fits into the buffer…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…base MySQL configuration (configuration A) appears below: #####fixed innodb options innodb_file_format = barracuda innodb_buffer_pool_size = 4G innodb_file_per_table…rnd_buffer_size = 4M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = …
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… datadir=/mnt/data/mysql #for SSD innodb_flush_neighbor_pages = none innodb_adaptive_flushing_method = keep_average innodb_file_per_table = true… thread_stack = 192K tmp_table_size = 64M server-id = 10 #*** MyISAM Specific options key_buffer_size = 8M read_buffer_size = 1M read_rnd_buffer…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
…is often less than 1MB per thread with default buffers, and you really do not need to increase per thread buffers unless you have complex queries…why: List of rarely considered MySQL Server Memory Requirements Thread buffers can be allocated more than once for each thread. Consider for example …
Post: How is join_buffer_size allocated?
July 5, 2010 By 9 Comments
… examining MySQL configuration, we quite often want to know how various buffer sizes are used. This matters because some buffers (sort_buffer_…of the buffers that are allocated per-thread (i.e. per-connection), this one is allocated per-join-per-thread, in special cases. A join buffer is allocated…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…| | SORT_BUFFER_SIZE | 2097152 | 262144 | | LC_MESSAGES_DIR | /mnt/nfs/dist/mysql-5.5.30-linux2.6-x86_ | /mnt/nfs/dist/mysql-…| 300 | | PERFORMANCE_SCHEMA_MAX_THREAD_INSTANCES | 1000 | 224 | | SOCKET | /tmp/mysql_sandbox5530.sock | /tmp/mysql_sandbox5610.sock | | INNODB_FILE_PER_TABLE | OFF | ON | | …
