… card as storage. By default linkbench dataset has 10M ids(after load of data size of datadir ~10GB)…. 5.5 outperforms MySQL in about 2x times. Both MySQL 5.5.30 and MySQL 5.6.11 demonstrate… 5000 sync_binlog=0 max_connections=5000 table_open_cache=5000 table-definition-cache=1000 query_cache_size=0…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…_packet = 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… myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-tables TokuDB-related options are all defaults, as I understand from…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… creating a vCache device with the default configuration, I started with a baseline HDD configuration for MySQL (configuration A, listed at the…_packet = 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…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…default_storage_engineblogpercona.commanual default_time_zoneblogpercona.commanual default_week_formatblogpercona.commanual defaults_extra_fileblogpercona.commanual defaults_fileblogpercona.commanual defaults…
Post: Binary log file size matters (sometimes)
May 24, 2012 By 6 Comments
… mysql mysql 1073742171 Nov 2 15:15 /var/lib/mysqllogs/db1-bin-log.003229 -rw-rw—- 1 mysql mysql …every time current binary log gets close to max_binlog_size in size, new binary log is created and, if…the size of binary log file from default 1GB (some systems have it set to 100MB in their default…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…binlog-ignore-db=dummyData #binlog-ignore-db=edmunds #binlog-ignore-db=evox #binlog-ignore-db=jato #binlog-ignore-db=kbb binlog-ignore-db=mysql binlog-ignore-db=test #binlog…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…defaults-file=/etc/my.cnf –basedir=/usr –datadir=/var/db/mysql –user=mysql…Binlog_cache_disk_use | 0 | | Binlog…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…binlog_format=ROW log_bin=mysql-bin wsrep_cluster_address=gcomm:// wsrep_provider=/usr/lib/libgalera_smm.so datadir=/var/lib/mysql…default_backend pxc-back frontend stats-front bind *:80 mode http default…
Post: Investigating MySQL Replication Latency in Percona XtraDB Cluster
March 3, 2013 By 13 Comments
… to pretty significant load. sysbench –test=oltp –mysql-user=root –mysql-password=”" –oltp-table-size=1000000 –num-threads=32 –init-rng=on –max…_cluster_name=DPE binlog_format=ROW default_storage_engine=InnoDB innodb_autoinc_lock_mode=2 innodb_locks_unsafe_for_binlog=1 wsrep_sst…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… happens for blobs larger than 16K – is exact size allocated or also segment based allocation is used. …\ hrottling.”, NULL, NULL, 8, 0, 1000, 0); The default is 8, which will work well in most … I do not think so. Sergei Golubchik serialized the MySQL binlog write and the InnoDB log flush with a …
