…/doc/refman/5.6/en/innodb-memcached-setup.html As a quick benchmark, I ran some batches of fetch and store against both a standard memcached instance and a minimally tuned MySQL 5.6 instance running the… MySQL Select (same table): Fetching [1,000,000] items: 441573 ms total 0.441573 ms per/cmd 0.4327 ms min per/cmd…
Post: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
… for entering data and a separate UI for generating reports. This evolved into the SQL based MySQL, with MySQL 1.0 being released…’,'N’,'M’,’0‘,’1‘,’2′)\n”; } chop $sql; chop $sql; $sql.=”);”; print $sql; This gets you a 46kb CREATE TABLE statement and a…_ERR_TO_BIG_ROW); } Which is curiously gone from MySQL 5.6, it’s replaced by the following set of defines…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… on Percona’s Cisco UCS C250 test machine, and both the vCache and FlashCache tests used the same 2.2TB Virident FlashMAX… 0.5 and the version of MySQL used was Percona Server 5.5.30-rel30.1-465. Each test was allowed to run for 7200 seconds, and… four configurations, but configuration C avoids the spikes and produces a very constant and predictable result. vCache vs. FlashCache – the basics Once…
Post: How to create a new (or repair a broken) GTID based slave with Percona XtraBackup
May 9, 2013 By 3 Comments
… 1232 c777888a-b6df-11e2-a604-080027635ef5:1-4 Now it contains both, binary log coordinates and GTID information. That information is also…-33-33/ 3- Move the backup to the destination server and put the content on the mysql’s datadir. Follow the… > CHANGE MASTER TO MASTER_HOST=”10.0.1.1“, master_user=”msandbox”, master_password=”msandbox”, MASTER_AUTO_POSITION = 1; 5- Check the replication status: slave1…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… is glad to announce the release of Percona XtraBackup 2.1.0-rc1 on May 7, 2013. Downloads are available from our… Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool dumps can be produced and loaded for faster server… by ALTER TABLE IMPORT TABLESPACE on MySQL and Percona Server 5.6 as described in Exporting and Importing Tables guide. Bugs Fixed: Percona…
Comment: SimCity outages, traffic control and Thread Pool for MySQL
March 21, 2013 By 16 Comments
… falling over on 5.0.27. Of course now it’s common to see much higher numbers from NDB and 5.5.x clusters with… thread pool offering far more sanity and stability than life back in the days of MySQL 5.0.x. On that end, I…/wordpress/2013/03/01/building-a-mysql-private-cloud-step-1/ — this will be a series of posts over time (as…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… case #2 and focused only on case #1. Which is the perfect case for read-only transaction optimization in MySQL 5.6, because… tests Percona Server scalability is somewhere in between of MySQL 5.5 and MySQL 5.6. In order to understand more about differences between…=5000 query_cache_type=OFF performance_schema=0 warmup To warmup server and load data and indices to the buffer pool we use…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…) and by the end of 5 hours averages at 2700 tps. With TokuDB we also see a drop, and by end of 5 hours…=0 –num-threads=32 –rand-type=pareto run and InnoDB options are: [mysqld_safe] numa-interleave malloc-lib=/usr/local/Percona-Server-5.5… #myisam_max_extra_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root…
Comment: Percona Server 5.5.30 with TokuDB for MySQL
April 29, 2013 By 26 Comments
… and tested correctly in the CMake files: TOKUFRACTALTREE_LIB linked by target “tokudb” in directory /data/tmp/mariadb-5.5.30-tokudb-7.0.1/storage/tokudb TOKUPORTABILITY_LIB linked by target “tokudb” in directory /data/tmp/mariadb-5.5.30-tokudb-7.0.1…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…: set innodb_flush_log_at_trx_commit to something besides 1 and suddenly you can update much faster. I see this tuning… your application has that logic (I usually get less than 5 people who do out of 100). But, what to do… 1, above), how about maintaining the counter in memcache or redis and only flushing to the database periodically? if( $last_count % 100 == 0…
