…=0 –num-threads=32 –rand-type=pareto run and InnoDB options are: [mysqld_safe] numa-interleave malloc-lib=/usr/local/Percona-Server-5.5.30-rel30.2-500.Linux.x86_64/lib/mysql/libjemalloc.so [mysqld] gdb datadir=/mnt/data/mysql #for SSD… = 0 query_cache_type = 0 ft_min_word_len = 4 #default_table_type = InnoDB thread_stack = 192K tmp_table_size = 64M server-id…
Post: Percona XtraBackup 2.1.0 for MySQL alpha now available
April 2, 2013 By Leave a Comment
… Perl’s DBD::MySQL package for server communication instead of spawning the MySQL command line client. Support for InnoDB 5.0 and InnoDB 5.1-builtin has been removed from Percona XtraBackup for MySQL. After…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… support for MySQL 5.6 and Percona XtraDB Cluster We started beta support for MySQL 5.6 in 2.1.8 when 5.6 was still beta. Now that MySQL 5.6 is GA, so… have four base versions of MySQL (5.0, 5.1, 5.5, and 5.6), plus at least four major forks (Percona Server, MariaDB, Percona XtraDB Cluster, and…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
… Perl’s DBD::MySQL package for server communication instead of spawning the MySQL command line client. Support for InnoDB 5.0 and InnoDB 5.1 builtin… position. This could trigger a bug if the server being backed up was standalone server (neither master nor slave in replication) and… #1175860. xtrabackup –stats option would not work with server datadir if the server isn’t running and logs were in a separate…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
…, enough to cause serious issues to the pacemaker setup the server is one of the nodes. That caused resource failovers. Resource…? The push to S3 was especially puzzling since MySQL was not involved. The server was running with nearly 7GB of free memory… 2013 2 1 291992 224892 138848 7254284 0 0 148504 476 24190 24233 8 6 81 5 0 Fri Mar 22 10:03:24…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
…and a minimally tuned MySQL 5.6 instance running the memcached…true, ‘lifetime’ => 3600, ‘automatic_serialization’ => true ); $memcacheOpts = array( ‘servers‘ =>array( array( ‘host’ => ’192.168.57.51′,…0.347181 ms per/cmd 0.3208 ms min per/cmd 0.4159 ms max per/cmd 0.0951 ms range per/cmd InnoDB MySQL…
Comment: Is MySQL 5.6 slower than MySQL 5.5?
March 27, 2013 By 23 Comments
…_amd64.deb 564 PTS mysql-5.6.10-debian6.0-x86_64.deb 538 PTS 1 core, 64 threads: mysql-server-core-5.5_5.5.29-0ubuntu0.12…_amd64.deb 575 PTS mysql-5.6.10-debian6.0-x86_64.deb 572 PTS 2 cores, 64 threads: mysql-server-core-5.5_5.5.29-0ubuntu0.12.04.2_amd64.deb 911 PTS mysql-5.6.10-debian6.0-x86_64.deb 918…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
…/lib/mysql/ibdata1 3. Recover SYS_TABLES, SYS_INDEXES, SYS_COLUMNS and SYS_FIELDS from indexes 0-1, 0-3, 0-2 and 0-4… dumps of the dictionary tables into some MySQL server. Use LOAD DATA INFILE constraints_parser generates mysql>LOAD DATA INFILE ‘/path/to/SYS… supported. If a field was of DECIMAL(5,2) type sys_parser will generate DECIMAL(5,0). It has to be corrected manually
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… systems. The benchmark tool used was sysbench 0.5 and the version of MySQL used was Percona Server 5.5.30-rel30.1-465. Each test… –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… query_cache_size = 0 query_cache_type = 0 ft_min_word_len = 4 thread_stack = 192K tmp_table_size = 64M serverid = 101…
Post: How to create a new (or repair a broken) GTID based slave with Percona XtraBackup
May 9, 2013 By 3 Comments
… process is pretty straightforward. 1- Take a backup from any server on the replication environment, master or slave: # innobackupex /destination/ In…/ 3- Move the backup to the destination server and put the content on the mysql‘s datadir. Follow the usual restore procedure… TO MASTER_HOST=”10.0.1.1″, master_user=”msandbox”, master_password=”msandbox”, MASTER_AUTO_POSITION = 1; 5- Check the replication status…
