… secondary keys from deferred key creation optimization. Bug fixed #1081016 (Alexey Kopytov). Percona Server for MySQL was built with YaSSL which could… from Percona’s Debian repositories. Bug fixed #1015506 (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because…
Post: MySQL alternative Percona Server 5.1.68 -14.6 now available
April 19, 2013 By 3 Comments
… secondary keys from deferred key creation optimization. Bug fixed #1081016. When mysqldump was used with –innodb-optimize-keys and –no-data options… package from source and Debian installation. Bug fixed #1032139. Percona Server was missing help texts in the MySQL client because the help…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… secondary keys from deferred key creation optimization. Bug fixed #1081016 (Alexey Kopytov). Percona Server for MySQL was built with YaSSL which could… from Percona’s Debian repositories. Bug fixed #1015506 (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
…InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool dumps …a lot of time opening all the tablespaces. Optimization has been implemented and XtraBackup now avoids …backup to fail. Bug fixed #1169726. For the Debian and the Linux binaries, the –version message …
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… lot of time opening all the tablespaces. Optimization has been implemented and XtraBackup now avoids … dependency has been changed from abstract mysql to real /usr/bin/mysql file, because rpm packages from … to fail. Bug fixed #1169726. For the Debian and the Linux binaries, the –version message …
Post: Find unused indexes
June 30, 2012 By Leave a Comment
…the information on INDEX_STATISTICS table. mysql> SELECT * FROM INDEX_STATISTICS; +————–+————+————–+———–+ | TABLE_SCHEMA | …indexes. This is an example: root@debian:/var/log# pt-index-usage slow… before, is an estimation from the optimizer and sometimes the real query …
Post: Find and remove duplicate indexes
June 20, 2012 By 9 Comments
…of our database: They make the optimizer phase slower because MySQL needs to examine more query … the tool on the ‘test’ database: root@debian:~# pt-duplicate-key-checker –database=test # ######################################################################## # test.t # …
Comment: Percona builds with Percona patchsets
February 3, 2009 By 35 Comments
… and a Debian and/or Ubuntu user, I am primarily interested in Percona patches because of the easier database optimization (microslow, anyone?). I am too lazy to build mysql with the Percona patchset, for the… I would gratefully install it if it was readily available. Debian users like me are probably a fraction of your customers…
Comment: MySQL - to use or not to use
May 29, 2007 By 10 Comments
… many new and great featured, mostly those the guys claiming MySQL is a “toy database” used as argument. This with Subqueries… upgrade where: – MySQL 4.1 has been out of life for a long time now, and no recent debian packages where provided, with 4.1.14 being the newest – I want to use profiling to check for possible optimizations…
