… the filesystem level. The InnoDB indexes were built using ALTER TABLE fast index creation (merge sort). For the MyISAM tests I… innodb_buffer_pool_instances=16 metadata_locks_hash_instances=32 table_open_cache_instances=8 sort_buffer_size=128k read_rnd_buffer… innodb_undo_logs=32 innodb_old_blocks_time=0 table_open_cache=2048 table_definition_cache=16384 innodb_flush_method=O_DIRECT key…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
… Server 5.6 series. All of Percona’s software is open-source and free, all the details of the release can…. Incorrect schema definition for the User Statistics tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS, THREAD_STATISTICS, and USER_STATISTICS…. Bug fixed #1186831. Reduced the overhead from the Handle Corrupted Tables check as it was missing branch predictor annotations. Bug fixed…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 4 Comments
… bug fixes in it. All of Percona’s software is open-source and free, all the details of the release can…. Incorrect schema definition for the User Statistics tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS, THREAD_STATISTICS, and USER_STATISTICS… tracking is enabled. Bug fixed #1184517. The INNODB_CHANGED_PAGES table couldn’t be queried if the log tracker wasn’t…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… the new features regarding replication in MySQL 5.6. They open up a lot of opportunities to make the life of… slave; and let’s create a new table on the master: mysql> create table test.t (id int not null auto_increment primary key); Executing SHOW TABLES FROM test on both slaves shows that the table has been created everywhere. So once…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
… the 5.5 series. All of Percona’s software is open-source and free, all the details of the release can… the MySQL 5.6 version, which removed MyISAM internal temporary table mutex contention. Bug fixed #1179978. Release notes for Percona Server…
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
… enlighten me here. – audit_record_objs : List of database objects (tables, according to the docs) for which you want events written…”,”query”:”Connect”} In conclusion, the plugin API seems to be opening new possibilities of extending MySQL’s behavior in a way…
Comment: What Are Full, Incremental, and Differential Backups?
May 22, 2013 By 9 Comments
… weeks. Can you give an example in a table? I am doing a project with Open university, and would appreciate your help!
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… been deprecated. Feature has been removed because the upstream DROP TABLE implementation has been improved. (Laurynas Biveinis) Bugs Fixed: Due to… the upstream bug #63144. CREATE TABLE or CREATE TABLE IF NOT EXISTS statements on an existing table could wait on a metadata lock… if there is a transaction that executed a query which opened that table. Bug fixed #1127008 (Sergei Glushchenko). Fix for bug #1070856…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… been deprecated. Feature has been removed because the upstream DROP TABLE implementation has been improved. (Laurynas Biveinis) Bugs Fixed: Due to… the upstream bug #63144. CREATE TABLE or CREATE TABLE IF NOT EXISTS statements on an existing table could wait on a metadata lock… if there is a transaction that executed a query which opened that table. Bug fixed #1127008 (Sergei Glushchenko). Fix for bug #1070856…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… Percona Software Repositories. Percona XtraBackup is the world’s only open-source, free MySQL hot backup software that performs non-blocking… crash when preparing the 5.6 backup with partitioned tables. Bug fixed #1169169. Tables that were dropped between taking a full backup…. If there are thousands of tables and slow IO then XtraBackup can spend a lot of time opening all the tablespaces. Optimization…
