June 19, 2013

Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue

April 24, 2013 By Leave a Comment

…support rather than the bundled YaSSL library. Bug fixed #1104977 (Ignacio Nin). Running the DDL statement while variable innodb…(Alexey Kopytov). When mysqldump was used with –innodb-optimize-keys and –no-data options, … only affected clean RPM installations and not upgrades. We have pushed the …

Filed Under: MySQL, Percona Software

Post: Percona Server for MySQL 5.5.30-30.2 now available

April 10, 2013 By 10 Comments

…support rather than the bundled YaSSL library. Bug fixed #1104977 (Ignacio Nin). Running the DDL statement while variable innodb…(Alexey Kopytov). When mysqldump was used with –innodb-optimize-keys and –no-data options, … only affected clean RPM installations and not upgrades. We have pushed the …

Filed Under: MySQL

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

May 7, 2013 By Leave a Comment

…an Release Candidate quality release and is not intended for production. If you want a…dump files). Percona XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL …lot of time opening all the tablespaces. Optimization has been implemented and XtraBackup now avoids…

Filed Under: MySQL, Percona Software Tagged With: , , ,

Post: Percona XtraBackup 2.0.7 for MySQL available for download

May 6, 2013 By 1 Comment

…dump files). Percona XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL …in the full backup directory, and were not removed when incremental backups has been merged…lot of time opening all the tablespaces. Optimization has been implemented and XtraBackup now …

Filed Under: MySQL Tagged With: , , ,

Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released

March 25, 2013 By 2 Comments

… so is our support for it. Check out the Percona Toolkit supported platforms and…we removed –lock-wait-timeout which set innodb_lock_wait_timeout because that now… written once long ago and not updated since.  Now that we …in development while we determine the optimal JSON structure. Version check is …

Filed Under: Percona Software, Percona Toolkit Tagged With: , , , , ,

Post: Improved InnoDB fast index creation

November 6, 2011 By 4 Comments

…index size with the optimization disabled. OPTIMIZE TABLE OPTIMIZE TABLE is mapped to ALTER TABLE … ENGINE=InnoDB for InnoDB tables and thus, …test.t | optimize | note | Table does not support optimize, doing recreate + analyze instead | | test.t | optimize | status | OK | …

Filed Under: Benchmarks, Insight for DBAs, MySQL

Post: Thinking about running OPTIMIZE on your Innodb Table ? Stop!

December 9, 2010 By 18 Comments

…lot better fill factor. The problem is…. OPTIMIZE TABLE for Innodb tables does not get advantage of it for whatever reason…test.a | optimize | note | Table does not support optimize, doing recreate + analyze instead | | test.a | optimize | status | OK | …

Filed Under: Insight for DBAs, MySQL Tagged With: , ,

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

…innodb ADD FULLTEXT KEY (full_name, details), ADD FULLTEXT KEY (details); ERROR 1795 (HY000): InnoDB presently supports…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: InnoDB Flushing: a lot of memory and slow disk

March 31, 2011 By 57 Comments

… actually it does not work, as MySQL is not able to keep the number of dirty pages within the given innodb_max_dirty… with slow disks); and 3) MySQL does not support innodb_log_file_size > 4GB (it is supported in Percona Server). To make things more… mechanism that will limit the rate of changes in memory. Optimize the flushing of sequential neighbor pages in a way thatÂ…

Filed Under: Benchmarks, Hardware and Storage, Insight for DBAs, MySQL

Post: Spreading .ibd files across multiple disks; the optimization that isn't

December 25, 2010 By 23 Comments

…, here is one I hear quite frequently – “If you enable innodb_file_per_table, each table is it’s own .ibd….” There are a few things wrong with this advice: InnoDB does not support these symlinks.  If you run an ALTER TABLE command… is destroyed, and the temporary table is renamed.  Your “optimization” is lost. Striping (with RAID) is usually a far better…

Filed Under: Insight for DBAs, MySQL Tagged With: , , , , , ,
« Older Posts