…-vars is used to set both of these (or any) system variables. For a quick intro to metadata locks and how they… removed. We also removed several options that probably nobody ever used, and changed/renamed other options to be more logical. The… intervals. Now –no-stalk means only that: don’t stalk, just collect, respecting –interval and –iterations as usual. So to collect…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
…replication. This may sound counter-intuitive at first: how would synchronous replication get behind? As I’…be taken for applications to avoid using Donor/Desynced nodes, particularly when using a blocking SST method …”, in which case flow control will kick in just as soon as the fc_limit is exceeded….
Post: Percona XtraDB Cluster for MySQL and encrypted Galera replication
May 3, 2013 By 2 Comments
… 1 12:08 key.pem These are just examples of how you might do it. Just take care to not expose your private… set the above settings? Yes, according to Codership, IST transfers use the same socket settings as regular group communication (gcomm). Will… source contribution in this space for encrypted versions of (or just enhancements to) the current SST scripts.
Comment: Why use encrypted backup with Percona XtraBackup 2.1 for MySQL?
April 10, 2013 By 2 Comments
…We just released our first alpha of Percona XtraBackup for MySQL 2.1″ Is anybody even still using MySQL 2.1? Or do you actually mean “We just released our first alpha of Percona… 2.1 for MySQL” which would make more sense. Just thinking about how google is going to index your page. You product…
Post: Moving to MySQL 5.6? We can help
April 12, 2013 By Leave a Comment
… up to date knowledge on MySQL 5.6, show you how to verify your application, and plan for a successful migration… and best practices. Just go to Percona Training for the full list of upcoming workshops. If you use discount code mpb10 you… Santa Clara, California, April 22-25. We have discounts available, just drop us line and we can help you out.
Post: Testing the Micron P320h
April 16, 2013 By 7 Comments
… 32 virtual cores. This is the same machine which was used in my previous benchmark run. A small handful of additional…, and for the sysbench fileIO tests, the EXT4 filesystem was used. The card itself is the 700GB model. So let’s… 128 write threads we have maximum throughput with latency just over 3ms. How well does it perform with MySQL? Exact results vary…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
…, we will not be making APT and YUM repositories available, just base deb and RPM packages This is an Release Candidate…-quality, generally available release, the current stable version should be used (currently 2.0.7 in the 2.0 series at….6 with the GTID mode enabled. Example of how this information can be used to create/restore a slave can be found…
Post: Just how useful are binary logs for incremental backups?
July 21, 2009 By 6 Comments
….7 days). So what are the solutions? If you are using all InnoDB tables, an XtraBackup incremental backup should be much faster than using binary logs. You can understand Vadim’s excitement when… announced this feature a few months ago. If you are using multiple storage engines, then your options are to either try…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… | Aborted_clients | 205174 | | Aborted_connects | 29 | | Binlog_cache_disk_use | 0 | | Binlog_cache_use | 9630066 | | Bytes_received | 38563413074 | | Bytes_sent | 216162991863 | …can then tell me how much total gain I can get from it. Queries are not just “bad” or “good” …
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
… significantly) And finally, testing with a 4G buffer pool shows how the system performs when the data fits completely into the…: Using where 2 rows in set (0.00 sec) After running the query, see how many pages were read from disk versus how….00 sec) Here are my modified versions of the queries (just to use ANSI JOIN syntax): — Q1.1 select sum(lo_extendedprice…
