June 19, 2013

Post: Percona XtraBackup 2.0.7 for MySQL available for download

… release of Percona XtraBackup 2.0.7 for MySQL on May 6, 2013. Downloads are available from our download site here and Percona Software… in the 2.0 series. New Features: This version of Percona XtraBackup has implemented full support for new MySQL 5.6 features (GTID… IMPORT TABLESPACE on MySQL and Percona Server 5.6 as described in Exporting and Importing Tables guide. Bugs Fixed: xtrabackup_56 binary was…

Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download

… 2.1.0-rc1 on May 7, 2013. Downloads are available from our download site here…0 series at the time of writing). New Features: This version of Percona XtraBackup has implemented full support for new MySQL 5… messages are never printed by xtrabackup_56. Bug fixed #1169971. innobackupex would still …

Post: Percona Server 5.1.56-12.7

5.1.56-12.7 is now available for download. It is based on MySQL 5.1.56 and is the current stable release in the 5… Import feature, importing .ibd files created on MySQL 5.0 or Percona Server versions prior to 5.1.7 could crash the server. (Yasufumi Kinoshita) Bug #735423 – File ownerships and permissions are now changed after running mysql

Post: TPC-H Run on MySQL 5.1 and 6.0

…. It can be downloaded here So let us first take a look at MySQL 5.1.23 vs 6.0.4 results for 10GB… MySQL 5.1 time so if it is less than 1 MySQL 6.0 is faster if more than 1 slower: Query MySQL 5.0.23 MySQL 6.0… time to 3 hours to give MySQL more time to complete the queries: Query MySQL 5.0.23 MySQL 6.0.4Ratio Query13784.453737.540.99…

Post: Updated msl (microslow) patch, installation walk-through!

… GLOBAL. Downloads msl patch for MySQL 5.0.45 msl patch for MySQL 5.0.51a msl patch for MySQL 5.0.54a msl patch for MySQL 5.0.56 msl patch for MySQL 5.0.45 with InnoDB extensions msl patch for MySQL 5.0.51a…

Post: What is stored InnoDB buffer pool

…_TABLE_0 | | 56 | 0 | 56 | 24 | 2816 | 0 | 0 | 58 | 17855 | index | CLUST_IND | | SYS_IBUF_TABLE_0 | | 57 | 0 | 57 | 286 | 0 | 0 | 0 | 59 | 4 | ibuf_free_list | | | | | 58 | 0… source code also available to download P.S. There is Jeremy Cole’s patch for InnoDB plugin MySQL 5.1, and main idea…

Post: Identifying the load with the help of pt-query-digest and Percona Server

… atomically, not just for new connections as in MySQL. This is very helpful for measurement as otherwise …and memory consuming, so ideally you would want to download the “slow query log” to another machine and …56 0 # Rows affecte 1.34k 0 65 0.07 0 1.35 0 # Rows read 105.76k 0 1000 5.39 9.83 32.69 0

Post: New patches, new builds

…| 820296 | 56 | 168 | | art104.forum104 | 771121 | 63 | 189 | | art111.article111 | 44100332 | 16411 | 164110 | | art93.thread_stats93 | 442440 | 9495 | 18990 | … For 5.0-…5.1 release Contains build-in InnoDB plugin, so there is no more needs to download InnoDB separately, install it and run mysql

Post: Percona XtraDB Cluster (PXC): what about GRA_*.log files ?

…. You can download one here :GRA-header We can verify it easily: file /tmp/GRA-header /tmp/GRA-header: MySQL replication log….log: MySQL replication log [root@node2 mysql]# mysqlbinlog -vvv GRA_3_3-bin.log /*!40019 SET @@session.max_insert_delayed_threads=0*/; /*!50003…_TYPE=0*/; DELIMITER /*!*/; # at 4 #120715  9:45:56 server id 1  end_log_pos 107     Start: binlog v 4, server v 5.5