…, tutorial, and breakout session speakers who presented insights into MySQL and MySQL-related technologies in over 110 sessions across four days. Special… the same The future for the MySQL community remains bright with a total projected market size of nearly US$1 billion within the next few years despite the buzz created by NoSQL alternatives Despite the buzz, MySQL…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… threads. Then we loaded 10x dataset – 100M ids (size of datadir ~100GB), size of the buffer pool is the same – 30GB. So…. Percona Server 5.5 outperforms MySQL in about 2x times. Both MySQL 5.5.30 and MySQL 5.6.11 demonstrate notable drops… we can see small performance drop in MySQL 5.6. In IO-bound cases MySQL still has performance issues around mutexes and…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…_method = O_DIRECT innodb_log_buffer_size = 16M innodb_buffer_pool_size = 52G innodb_log_file_size = 2000M innodb_log_files_in_group… –max-requests=0 –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-selects=1 –oltp…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… a six-hour tutorial about Percona XtraDB Cluster (PXC) for MySQL. I actually had more material than I covered (by design… replication feedback mechanism, unlike anything you find in standard async MySQL replication. It is my belief that the lack of understanding… gets. EDIT: actually the cost of certification depends only the size of the transactions, which translates into number of unique key…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…-time=7200 –max-requests=0 –percentile=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run The base MySQL configuration (configuration A) appears below: #####fixed innodb options innodb_file_format = barracuda innodb_buffer_pool_size = 4G innodb…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… –test=insert_roll.lua –oltp-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql_table_engine=tokudb –oltp_auto_inc=on…-rel30.2-500.Linux.x86_64/lib/mysql/libjemalloc.so [mysqld] gdb datadir=/mnt/data/mysql #for SSD innodb_flush_neighbor_pages…_sort_file_size = 10G #myisam_max_extra_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user…
Comment: TMP_TABLE_SIZE and MAX_HEAP_TABLE_SIZE
April 4, 2013 By 17 Comments
… and drupal, and i converted databases from MyISAM to InnoDB, mysql tunning script gives below results for temp table , server has… safe values ? or can i increase (max_heap_table_size & tmp_table_size) , what values you experts are recomended ? TEMP TABLES Current max_heap_table_size = 128 M Current tmp_table_size = 128 M Of 21559 temp tables, 44…
Post: Testing the Micron P320h
April 16, 2013 By 7 Comments
…/sec. When we calculate in the fact that the block size in use here is 16KiB, these numbers equate to over… it perform with MySQL? Exact results vary, depending upon the usual factors (read/write ratio, working set size, buffer pool size, etc.) but… on a standard TPCC-MySQL test to the original FusionIO and the Intel i910 with assorted buffer pool sizes: And in this…
Comment: Is MySQL 5.6 slower than MySQL 5.5?
March 27, 2013 By 23 Comments
…,it seams to be something whrong … with your build of mysql-5.6! On 64bit Win7 host running 512 MB VirtulBox… monitor ssse3 lahf_lm bogomips : 5756.60 clflush size : 64 cache_alignment : 64 address sizes : 36 bits physical, 48 bits virtual I… (538.76 per sec.) # using skip-performance-schema with standard mysql-5.6.10-debian6.0-x86_64.deb package ! You…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
…, you need to interleave the allocation of memory for the MySQL process using the numactl utility, drop the file cache and… S3. Why? The push to S3 was especially puzzling since MySQL was not involved. The server was running with nearly 7GB… create files of 5GB since the backup size is about 28GB and the file upload size limit is 5GB. So, about 28GB…
