…_file_size=4G innodb_file_per_table innodb_stats_on_metadata=off innodb_file_format=barracuda innodb_log_buffer_size=32M innodb_buffer_pool_instances=16 metadata_locks_hash_instances=32 table_open_cache_instances=8 sort_buffer_size=128k read_rnd_buffer_size=8M join_buffer_size…
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
… reporting any bugs at http://bugs.percona.com/ key_buffer_size=52428800 read_buffer_size=131072 max_used_connections=13 max_threads=2002 thread_count… It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 4432877 K bytes of memory Hope that…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… = 16M binlog_cache_size = 16M max_heap_table_size = 64M sort_buffer_size = 4M join_buffer_size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache…_table_size = 64M serverid = 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…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… tmp_table_size = 64M server-id = 10 #*** MyISAM Specific options 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 = 10G #myisam_max_extra_sort_file_size…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… away from this spherical read-only cow and throw some data updates into the mix, limitations of read-only transactions become obvious…_buffer_size = 16M innodb_buffer_pool_size = 52G innodb_log_file_size = 2000M innodb_log_files_in_group = 2 innodb_file_per_table = true innodb_read… To warmup server and load data and indices to the buffer pool we use following queries: select avg(id) from sbtest…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… of data size of datadir ~10GB). We used this dataset to check server behavior when data fully fits buffer pool(size of buffer pool…_log_file_size = 2000M innodb_log_files_in_group = 2 innodb_flush_log_at_trx_commit = 1 innodb_log_buffer_size=128M innodb_max_dirty_pages_pct=80 innodb_file_format=barracuda innodb_file_per_table innodb_read_io_threads…
Post: Testing the Micron P320h
April 16, 2013 By 7 Comments
… block size in use here is 16KiB, these numbers equate to over 110,000 write IOPS and almost 205,000 read IOPS… results vary, depending upon the usual factors (read/write ratio, working set size, buffer pool size, etc.) but overall the card is extremely quick… to the original FusionIO and the Intel i910 with assorted buffer pool sizes: And in this graph we look at the card…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
…file cache and pre-allocate the innodb buffer pool with the innodb_buffer_pool_populate option. That solves most of…files of 5GB since the backup size is about 28GB and the file upload size limit is 5GB. So, …starting at 10:03:36. Also, the server is reading a lot (~150MB/s) but doing very little …
Comment: MySQL and Percona Server in LinkBench benchmark
May 11, 2013 By 18 Comments
…_capacity = 20000 innodb_io_capacity_max = 100000 innodb_read_ahead_threshold = 0 innodb_change_buffer_max_size = 1 innodb_lru_scan_depth = 2000
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… N is the buffer size. In MySQL 5.6 the buffer size used by MRR can be controlled by the variable read_rnd_buffer_size, while MariaDB introduces a different variable to control the MRR buffer size mrr_buffer_size. Both buffer sizes default to 256K…
