…MySQL conference 2012 I will give one tutorial: Percona XtraBackup: install, usage, tricks….. MySQL and SSD: usage and tuning. This talk I’ve been giving for…MySQL, XtraBackup, XtraDB Cluster, etc. More interesting, by the time of conference we will have published our new book: High Performance MySQL…
Post: Seeking volunteers for Percona documentation
April 29, 2010 By 5 Comments
… editor on the book High Performance MySQL, will take on the volunteer role.) You should have some understanding of MySQL and Percona’s extensions….com/docs/wiki/percona-xtradb:features:start) * Release notes * Installation instructions for XtraBackup Eventually we’ll also upgrade our user guides, a…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… useful for several reasons. For one thing, it has a lot of information on the box’s hardware, including RAID controllers, installed memory… read these, there’s a full explanation in our book, High Performance MySQL 2nd Edition (it’s not in the first edition). From… a high-performance system is virtually every query.) If it’s not possible to use a patched binary, we can use MySQL Proxy…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
…for Enterprise managing a lot of relatively small MySQL installations or managed hosting provider. For large MySQL web MySQL installations… the local system performance independently from anything else. Performance This is perhaps the…is again if it is high enough to pay for the price premium ? …
Page: Consulting for MySQL
July 31, 2006 By
… issues. High Performance Application Architecture Design If you application architecture is flawed there is only limited gain you can achieve by MySQL Server… for MySQL We act as your remote MySQL DBA – manage users, make sure server runs well on day to day basis, install security updates, perform…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
… tried to show the minimal installation required for XtraDB cluster. Unfortunately enough…How does latency and bandwidth affect performance? Is it practical to … that you can achieve a high throughput despite the response time…-in mysql replication are independent from each other. Q: I installed …
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
… can make a substantial difference for the database and application performance. Over time msl patch grew… patched MySQL installed in the system. Locate where the original mysqld binary is with: (garfield:~/work/mysql…(1/log_slow_rate_limit) session. With high traffic coming to your database, the slow…
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
…MySQL 5.5 continues to support various character sets same as previous MySQL versions. Moreover utf8 character set continues to cause significant performance… with MySQL. Our focus on compatibility is indeed so high …install. Thank you for your questions and for attending. See you at our other MySQL…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…mysql-5.5.30-linux2.6-x86_ | /mnt/nfs/dist/mysql-5.6.10-linux-glibc2. | | PERFORMANCE_SCHEMA_MAX_COND_INSTANCES | 1000 | 836 | | PERFORMANCE…installations innodb_buffer_pool_instances is now 8 instead of 1 optimizing for…
Post: Announcing Percona XtraDB Storage Engine: a Drop-in Replacement for Standard InnoDB
December 16, 2008 By 25 Comments
… hardware, and includes a variety of other features useful in high performance environments. Percona XtraDB includes all of InnoDB’s ACID-compliant… into MySQL-5.1.30 RPMS * as separated shared library, to use as drop-in plugin for existing MySQL-5.1.30 installation http://www.percona.com/mysql/5.1.30/binary/percona-xtradb…
