… 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… ms range per/cmd Fetching [1,000,000] items: 288257 ms total 0.288257 ms per/cmd 0.2843 ms min per/cmd…
Post: Percona Live MySQL Conference 2013 wrap-up
April 29, 2013 By Leave a Comment
… Zaitsev from Percona and the keynote panel on MySQL 5.6 and the future of MySQL in the cloud with all of these… Oracle development discipline MySQL 5.0 and 5.1 were rushed and not properly tested but 5.5 and 5.6 were significantly improved and 5.7 promises to be more of the same The future for the MySQL community…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…_type=0 performance_schema=0 #56only loose-innodb_flush_neighbors=0 loose-metadata_locks_hash_instances=256 innodb_buffer_pool_instances=16 # MySQL 5.5 and 5.6 loose-innodb_io_capacity_max = 15000 #Percona only innodb_adaptive_hash_index_partitions=8 innodb_buffer_pool_instances=1…
Post: Percona XtraBackup 2.1.0 for MySQL beta now available
April 22, 2013 By Leave a Comment
… XtraBackup for MySQL 2.0.6, plus the following: New Features: Percona XtraBackup has implemented basic support for MySQL 5.6, Percona Server 5.6 and MariaDB 10.0…. Release notes with all the bugfixes for Percona XtraBackup for MySQL 2.1.0-beta1 are available in our online documentation. Bugs can…
Comment: Is MySQL 5.6 slower than MySQL 5.5?
March 27, 2013 By 23 Comments
… PS off 1 core, 1 thread mysql-server-core-5.5_5.5.29-0ubuntu0.12.04.2_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…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
… down backup costs while providing unique features for MySQL backup. The new 2.1.1 GA version offers improved performance, enterprise-grade security…’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…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… and focused only on case #1. Which is the perfect case for read-only transaction optimization in MySQL 5.6, because all SELECT…’s tests Percona Server scalability is somewhere in between of MySQL 5.5 and MySQL 5.6. In order to understand more about differences between…(*) from sbtest$i WHERE k like ‘%0%’ SysBench-0.5/lua: POINT_SELECT QPS test sysbench –num-threads=<1..1024> –test=oltp.lua –oltp…
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… 0 0 148504 476 24190 24233 8 6 81 5 0 Fri Mar 22 10:03:24 UTC 2013 2 1 291992 222228 138848 7258064 0 0… 5 0 Fri Mar 22 10:03:26 UTC 2013 3 1 291992 224088 138852 7260196 0 0 172386 156 27143 27637 8 7 80 5 0…
Post: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
… UI for generating reports. This evolved into the SQL based MySQL, with MySQL 1.0 being released in 1995. The FoRM file specified what…(HA_ERR_TO_BIG_ROW); } Which is curiously gone from MySQL 5.6, it’s replaced by the following set of defines… (1024-1)-3*2=1017 which is exactly the same as what I can create. That’s right folks, in MySQL 5.6…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… replication feedback mechanism, unlike anything you find in standard async MySQL replication. It is my belief that the lack of understanding… cluster permission to continue replication. This setting traditionally defaulted to 0.5, meaning the queue had to fall below 50% of the… might be: mysql> set global wsrep_provider_options=”gcs.fc_limit=500; gcs.fc_master_slave=YES; gcs.fc_factor=1.0“; Working…
