… cache can be invaluable. Enter MySQL 5.6 with the memcached plugin… As part of the standard MySQL 5.6 GA distribution, there is a memcached plugin included in the base plugin directory (/usr/lib64/mysql/plugin/libmemcached…) Centos 6.4 Single core VM 528M RAM Host-Only network 1 Box with http/php, 1 box with memcache or mysql started PHP…
Post: How to create a new (or repair a broken) GTID based slave with Percona XtraBackup
May 9, 2013 By 3 Comments
… is taken: innobackupex: MySQL binlog position: filename ‘mysql-bin.000002′, position 1232, gtid_executed c777888a-b6df-11e2-a604-080027635ef5:1-4 2- Apply the… to mysql:mysql. 4- Start the new slave from that GTID position: slave1 > SET GLOBAL gtid_purged=”c777888a-b6df-11e2-a604-080027635ef5:1-4“; slave1… slave has retrieved a new transaction with number 5, so transactions from 1 to 5 are already on this slave. That’s all…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
…NAME | SPACE | +————–+—–+——–+——+——–+———+————–+——-+ | sakila/actor | 741 | 4 | 1 | 0 | 0 | | 738 |…4. Load dumps of the dictionary tables into some MySQL server. Use LOAD DATA INFILE constraints_parser generates mysql…_ID`, `POS`, `COL_NAME`); 5. Now …
Comment: MySQL and Percona Server in LinkBench benchmark
May 11, 2013 By 18 Comments
… 16 around 8000 4 around 5000 mysql-5.6.11 (wo 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… innodb_read_ahead_threshold = 0 innodb_change_buffer_max_size = 1 innodb_lru_scan_depth = 2000
Comment: State of the art: Galera - synchronous replication for InnoDB
April 23, 2013 By 15 Comments
…/o on it that I have seen when running mysql 5.1 or mariadb 5.5 on the same hardware in a master/slave. I… in 11-14 seconds. This is all on centos 6.4, adaptec raid controller with six 300G SAS drives in a… –number-of-queries=100000 MariaDB-Galera-server-5.5.29-1.x86_64 mysql-5.1.67-1.el6_3.x86_64 MariaDB-server-5.5.30-1.x86_64
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
…permission to continue replication. This setting traditionally defaulted to 0.5, meaning the queue had to fall below 50% of the…be: mysql> set global wsrep_provider_options=”gcs.fc_limit=500; gcs.fc_master_slave=YES; gcs.fc_factor=1.0″; Working…myclu P 3 3 node3 Sync T/T 0 4 0 3 0 4.3K 0.0 0 109 0 0 …
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… 156 27143 27637 8 7 80 5 0 Fri Mar 22 10:03:28 UTC 2013 1 4 291992 219104 138832 7262820 0…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… cache storage device. EXT4 is the filesystem, and CentOS 6.4 the operating system, although the pre-release modules I received… tool used was sysbench 0.5 and the version of MySQL used was Percona Server 5.5.30-rel30.1-465. Each test was allowed…-interval=1 –rand-type=pareto \ –forced-shutdown=1 –max-time=7200 –max-requests=0 –percentile=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…,mid,id) ). Also please note the transaction produces 4 INSERTs and workload is very write intensive. So…Server-5.5.30-rel30.2-500.Linux.x86_64/lib/mysql/libjemalloc.so [mysqld] gdb datadir=/mnt/data/mysql …size = 256M innodb_flush_log_at_trx_commit = 1 innodb_buffer_pool_size = 36G innodb_log_file_…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
… use case for PARTITIONing (“uneven reads”, Re: #1); let me rephrase the use case — * The …Re #4) There are _no_ parallel queries (within a single connection) anywhere in any ‘free’ variant of MySQL. … at worst, hit the disk only 5 times. (Usually 4 of the 5 are cached from previous queries.) (Re …
