…=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb_log_file_size=4G innodb_…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…:53:56 mysqld_safe mysqld from pid file /var/lib/mysql/srv-d2-mysql02.pid ended in an another environment I…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…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
…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
…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…max-requests=0 –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-selects=1 …
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…. Percona Server 5.5 outperforms MySQL in about 2x times. Both MySQL 5.5.30 and MySQL 5.6.11 demonstrate notable drops…_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… does it perform with MySQL? Exact results vary, depending upon the usual factors (read/write ratio, working set size, buffer pool size, etc.) but overall… on a standard TPCC-MySQL test to the original FusionIO and the Intel i910 with assorted buffer pool sizes: And in this graph…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
…MySQL process using the numactl utility, drop the file cache and pre-allocate the innodb buffer pool with the innodb_buffer… 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
… doublewrite) 64 around 13000 16 around 12000 4 around 6000 — mysql-5.6-dev (doublewrite) 64 around 16000 16 around 12000 4 around 5500 mysql-5.6-dev (wo doublewrite) 64 around 20000 16 around…_capacity = 20000 innodb_io_capacity_max = 100000 innodb_read_ahead_threshold = 0 innodb_change_buffer_max_size = 1 innodb_lru_scan_depth = 2000
Post: read_buffer_size can break your replication
June 6, 2012 By 12 Comments
… are based on the read_buffer_size value so they are never larger than the max_allowed_packet 
Therefore, a read_buffer_size value larger than max_allowed_packet can break your replication while importing data to MySQL. This bug affects…
