… glad to announce the release of Percona XtraBackup 2.1.0 for MySQL alpha on April 2, 2013. Downloads are available from our download…, the current stable version should be used (currently 2.0.6 in the 2.0 series at the time of writing). This release contains… notes with all the bugfixes for Percona XtraBackup for MySQL 2.1.0-alpha1are available in our online documentation. Bugs can be reported…
Post: Percona XtraBackup 2.1.0 for MySQL beta now available
April 22, 2013 By Leave a Comment
Percona is glad to announce the release of Percona XtraBackup 2.1.0 for MySQL beta on April 22, 2013. Downloads are available…, the current stable version should be used (currently 2.0.6 in the 2.0 series at the time of writing). This release contains… notes with all the bugfixes for Percona XtraBackup for MySQL 2.1.0-beta1 are available in our online documentation. Bugs can be…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
Percona is glad to announce the release of Percona XtraBackup 2.1.0-rc1 on May 7, 2013. Downloads are available from our…, the current stable version should be used (currently 2.0.7 in the 2.0 series at the time of writing). New Features: This…
Post: Percona Monitoring Plugins 1.0.3 for MySQL now available
April 23, 2013 By 4 Comments
… is glad to announce the release of Percona Monitoring Plugins 1.0.3 for MySQL — high-quality components to add enterprise-grade…-replication-delay to be compatible with pt-hearbeat 2.1.8+ (bug 1103364) * Added 1-second granularity to pmp-check-mysql-deadlocks (bug…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… one more bug fix release (as 2.1.10) then retire. 2.2 is largely backward-compatible with 2.1, but some tools were changed significantly…. Now that we have four base versions of MySQL (5.0, 5.1, 5.5, and 5.6), plus at least four… https://launchpad.net/percona-toolkit/+milestone/2.2.1 for the full list. If you upgrade from 2.1 to 2.2, be sure to re-read…
Post: Why use encrypted backup with Percona XtraBackup 2.1 for MySQL?
April 10, 2013 By 2 Comments
We just released our first alpha of Percona XtraBackup 2.1 for MySQL and with it we included the ability to … but also applies to simple off-site backups. Percona XtraBackup 2.1.0-alpha1 supports industry standard AES encryption and we use an…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
… 1 2 291992 324640 138836 7153440 0 0 143736 132 19318 17425 7 5 76 12 0 Fri Mar 22 10:03:32 UTC 2013 0 2 291984 292988 138840 7183556 0 0 138480 1206 19126 16359 3 5 81 12 0…
Post: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
… reports. This evolved into the SQL based MySQL, with MySQL 1.0 being released in 1995. The FoRM file specified what fields…), MYF(0)); DBUG_RETURN(1); } Which is, of course, obvious! Various parts of this limit are: info_length is roughly 2+strlen(field…) { my $n=cname($_); $sql.=”`$n`”; $sql.=” ENUM(‘Y’,'N’,'M’,’0‘,’1‘,’2‘)\n”; } chop $sql; chop $sql; $sql.=”);”; print $sql; This gets…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
…_ID | MIX_LEN | CLUSTER_NAME | SPACE | +————–+—–+——–+——+——–+———+————–+——-+ | sakila/actor | 741 | 4 | 1 | 0 | 0 | | 738 | +————–+—–+——–+——+——–+———+————–+——-+ SYS_INDEXES This table lists all indexes the table…, SYS_INDEXES, SYS_COLUMNS and SYS_FIELDS from indexes 0-1, 0-3, 0-2 and 0-4 respectively. ./bin/constraints_parser.SYS_FIELDS -4f pages…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… –rand-init=on –report-interval=1 –rand-type=pareto \ –forced-shutdown=1 –max-time=7200 –max-requests=0 –percentile=95 \ –mysql-user=root…_size = 1G innodb_log_files_in_group = 2 innodb_purge_threads = 1 innodb_fast_shutdown = 1 #not innodb options (fixed) back_log = 50… = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len = 4 thread_stack = 192K tmp…
