…of the time it may take to complete this statement. Lets look at what the problem is. As of MySQL 5.5…
Comment: How to recover a single InnoDB table from a Full Backup
March 22, 2012 By 7 Comments
Hello All – I have created a backup of my mysql database using the innobackupex-1.5.1 command. I have the innodb_file_per_table directive… restore using the copy-back command. I am able to get the database in my /var/lib/mysql folder. But I am able to view/access ONLY MYISAM table – but none of the InnoDB tables. Is…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
…command and some inline searches, I was able to pinpoint the position of…
Post: Percona Server 5.1.56-12.7
April 18, 2011 By Leave a Comment
Percona Server version 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.1 series. New Features Expanded the applicability of InnoDB fast…) Bugs Fixed Bug #631667 – The mysql binary is now built with readline support so that command line browsing is possible. (Ignacio Nin…
Post: Percona Server 5.1.52-12.3
December 13, 2010 By 2 Comments
… of MySQL 5.1. The release also includes the HandlerSocket plugin, which provides NoSQL features in Percona Server. Functionality Added or Changed Percona Server 5.1… API on FreeBSD. (Oleg Tsarev) Bug #673426 – Use of some system variables as command-line options caused a crash or undefined behavior…
Post: Percona Server 5.1.52-rel11.6
November 23, 2010 By 2 Comments
…. The main purpose of this release is to update the current Percona stable release to the latest version of MySQL 5.1. Functionality Added or Changed  Percona Server 5.1.52-rel11.6 is now based on MySQL 5.1.52.  New… and .DEB packages. (Aleksandr Kuzminsky) Bug #673426 – Use of some system variables as command-line options caused a crash or undefined behavior…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
MySQL 5.5 and Percona Server 5.5 do not solve all scalability problems even for read only workloads. Workloads which got a lot of… Percona Server 5.1.56-12.7 and Percona Server 5.5.11-20…mysql_select,handle_select,execu te_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_command…
Post: Percona Server 5.1.49-rel12.0
September 15, 2010 By 6 Comments
… Percona Server 5.1.49-rel12.0 is based on MySQL 5.1.49. New features added: error_pad – Implements error code compatibilities with MySQL 5.5. (Oleg… segment between restarts of the server. (Yasufumi Kinoshita) Option syslog was added to the mysql server. If enabled, all commands run on the…
Post: Percona XtraBackup 1.6.4
December 19, 2011 By 9 Comments
…recent MySQL and Percona Server versions. We now build against: MySQL 5.1.59, MySQL 5.5.17, Percona Server 5.1.59-13.0 and Percona Server 5.5….a value of -1. Bug Fixed#884737 (Alexey Kopytov) The documentation for innobackupex (including –help) erroneously mentioned an –ibbackup-binary command line …
Post: Microslow patch for 5.1.20
July 18, 2007 By 3 Comments
… the patch to work you must of course enable slow logging with –slow-query-log parameter. MySQL 5.1 has this nice feature which… for your logs to the plain old-fashioned files. In MySQL 5.1 it’s done by setting –log-slow-queries=slow.log… restarted with SLAVE STOP and SLAVE START commands. The change in functionality is more of a bugfix than anything else. long_query…
