June 19, 2013

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

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 …

Post: Percona Server for MySQL 5.5.30-30.2 now available

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 …

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

…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…

Post: Percona XtraBackup 2.0.7 for MySQL available for download

…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 …

Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released

… 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 …

Post: Improved InnoDB fast index creation

…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 | …

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

…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 | …

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

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

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

… 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Â…

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

…, 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…