…,s1, s3, s4 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 t; +———-+ | count(*) | +———-+ | 2 | +———-+ Great! So again, using GTIDs avoids the tedious work of…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
…. The log tracker thread was unaware of the situation when the oldest untracked log records are overwritten by the new log data… different major versions of Percona Server. Bug fixed #1167109. Fixed the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could…. Fixed the upstream bug #69379 which caused MySQL clients to return bogus error number for host-not-found errors on Ubuntu 13…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… server can easily handle the write load of all the MySQL instances. The original idea was to configure … of snapshots. With LVM, your IO performance drops to 33% after the first snapshot so keeping a large number of… record on disk has a checksum. If a cosmic ray flip a bit on a drive, instead of …
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… on “MySQL Query Patterns, Optimized” for Percona MySQL Webinars. If you missed it, you can still register to view the recording and my… can produce an infinite variety of queries. The query optimizer analyzes queries for common patterns the MySQL designers know can be improved… there’s a gap of id’s between 47000 and 50000 with no movies, but your random number generator picks values in…
Post: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
… be two sets of polls: “What is the maximum number of columns in MySQL?” and “What is the minimum maximum number of columns in MySQL?”. Before you… the maximum number of columns is this: /* Hack to avoid bugs with small static rows in MySQL */ reclength=max(file->min_record_length(table…
Post: Finally. How to verify if all MySQL records were recovered
April 25, 2013 By Leave a Comment
… nearly every recovery case the same question arises: How many MySQL records were recovered and how many were lost. Until now there… how many records an InnoDB page stores. The index page has a header PAGE_N_RECS – this is a number of records the page stores. Obviously it doesn’t count any deleted records. The second method to confirm how many records are…
Post: Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo
April 15, 2013 By 1 Comment
… MySQL Conference but want to take advantage of the keynotes, BOFs, and Community Networking Reception, I’m pleased to offer a limited number of $5 Expo Only passes. Use discount code “KEY” when registering for the Percona Live MySQL Conference. Hurry, though… conference and we’ll announce when and where the keynote recordings and breakout session slide decks can be found.
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… Server for MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL performance can be found in this blogpost. (Ignacio Nin) This release of Percona Server for MySQL has fixed a number of…). The log tracker thread was unaware of the situation when the oldest untracked log records are overwritten by the new log data…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… Server for MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL performance can be found in this blogpost. (Ignacio Nin) This release of Percona Server for MySQL has fixed a number of…). The log tracker thread was unaware of the situation when the oldest untracked log records are overwritten by the new log data…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL…of the above examples you can imagine plenty of concurrent clients attempting to modify the same record…, each autocommit is retried only the number of times specified by this variable (default …
