June 19, 2013

Post: TPC-H Run on MySQL 5.1 and 6.0

… you like. It can be downloaded here So let us first take a look at MySQL 5.1.23 vs 6.0.4 results… is MySQL 6.0 time divided by 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…

Post: Announcing Percona Server 5.5.25a-27.1

… Percona Server 5.5.25a-27.1 on July 21st, 2012 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.25a… with ssl connections count in statistics tables in Percona Server 5.5.24-26.0. Bug fixed #1008278 (Vladislav Lesin). PAM authentication plugin…

Post: MySQL sources from development tree

….com/Hosted.Downloading.html . Once you get it, you can clone latest tree: bkf clone bk://mysql.bkbits.net/mysql-5.0 mysql-5.0 New…-5.0.30-build TAG: mysql-4.1.22 TAG: clone-4.1.22-build TAG: mysql-5.0.28 TAG: mysql-5.0.27 TAG: mysql-5.0.26 So, to get sources for 5

Post: New patches, new builds

… new builds for 5.0.62, 5.0.67 and 5.1.26 versions. One of biggest changes we separated releases of 5.0 into two… flushing 5.1 release Contains build-in InnoDB plugin, so there is no more needs to download InnoDB separately, install it and run mysql… it with MySQL 5.1 RC, at least stable to name whole MySQL-5.1-percona release as RC. Along with previously mentioned patches, to 5.1 we…

Post: How to recover deleted rows from an InnoDB Tablespace

1- Extract all the InnoDB pages from the tablespace: First we need to download… | Compact | +————+ ~/recovery-tool# ./page_parser -5 -f data/salaries…26 | PRIMARY | | 27 | emp_no | +———-+———+ B) InnoDB Table Monitor The index information can also be taken directly from MySQL

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

…vanilla MySQL server, you would see an entry like this in the slow query log: # Time: 111229 3:02:26 #…and memory consuming, so ideally you would want to download the “slow query log” to another machine and run…00 SELECT wp_options # 8 0x4C16888631FD8EDB 0.1160 1.4% 5 0.0232 1.00 0.00 SELECT film # 9 …