… A drop in replacement for MySQL, downloads are available here and from the Percona Software Repositories. Based on MySQL 5.1.69, … read any bitmap files. Bug fixed #1184427. Incorrect schema definition for the User Statistics tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… 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… -> File-based positioning Conclusion Enabling GTID-based replication can be tricky if your application does not easily tolerate downtime or read-only…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
… 3rd, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.6.11, including all the bug… thus does not need to read any bitmap files. Bug fixed #1184427. Query to the INNODB_CHANGED_PAGES table would cause server to… dependencies issues. Bug fixed #1186831. Reduced the overhead from the Handle Corrupted Tables check as it was missing branch predictor annotations. Bug…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…: Is it possible to replicate only some tables from master to slave, and if so, how? A…not that familiar with, I’d suggest reading over the manual’s description of how… information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db …
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; # And then check the number of records from the t table s1> select count(*) from… other one is from s0 (for s0 which is crashed, the server UUID can be read in the auto.cnf file in the…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… Also accessing pages from the buffer pool should be faster than getting them from the OS…mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb_log_file_size=4G innodb_file_per_table…hash_instances=32 table_open_cache_instances=8 sort_buffer_size=128k read_rnd_buffer_…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…file_size = 2000M innodb_log_files_in_group = 2 innodb_file_per_table = true innodb_read…mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql…
Post: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
… in MySQL?” and “What is the minimum maximum number of columns in MySQL?”. Before you read on, …further into the FRM file. What is an FRM file? It’s the FoRM file from UNIREG. It’s …bugs with small static rows in MySQL */ reclength=max(file->min_record_length(table_options),reclength); if (info_length…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
…dependency has been changed from abstract mysql to real /usr/bin/mysql file, because rpm packages from Oracle no longer satisfied mysql dependency which is required… Bug fixed #1169971. innobackupex would still run with FLUSH TABLES WITH READ LOCK even if xtrabackup would fail when copying logs. …
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… 7, 2013. Downloads are available from our download site here. For …files, that can be imported by ALTER TABLE IMPORT TABLESPACE on MySQL and Percona Server 5.6 as described in Exporting and Importing Tables…innobackupex would still run with FLUSH TABLES WITH READ LOCK even if xtrabackup would fail…
