… MariaDB as a first-class member of the MySQL family of databases. Finally, High Performance MySQL, Third Edition mentions MariaDB in many places… Oracle has made to the MySQL 5.5 release. This should help MariaDB be faster and more scalable, as well as adding… of MySQL that suit different needs and personalities, with different characteristics, and feature and performance improvements are moving rapidly forward for the MySQL…
Post: Percona Toolkit 2.1 with New Online Schema Change Tool
April 5, 2012 By 9 Comments
… downtime. As you know, MySQL locks tables for most ALTER operations, but pt-online-schema-change performs the ALTER without any locking… tool, one of the most painful things anyone experiences with MySQL is significantly alleviated. If you’ve ever delayed a project… upgrades I’ll show how to use it to forecast scalability and performance The new Percona Toolkit release is available for download…
Comment: Percona white paper: Forecasting MySQL Scalability
April 17, 2012 By 6 Comments
Hi Baron, Your first paper – Forecasting MySQL Scalability with the Universal Scalability Law was really very interesting. I actually read it first, … got to see you gave one session on – Extracting Scalability and Performance Metrics from TCP Traffic in Surge Conference 2011. Is there…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… your concerns are at this stage. Is it the current performance, future performance, scalability, ability to recover from disasters? We also want to…=/var/db/mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql.sock consult…
Post: Followup on performance metrics: slides, video
July 11, 2011 By 6 Comments
… extract an amazing amount of information about a system’s performance, scalability, queueing, and more by just measuring request arrivals and completions… into a more complete description of how to analyze MySQL’s performance and scalability through nothing more than TCP/IP packet headers. I…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
… they have” on MySQL UC2008 Scalability Panel ? Indeed disks MAY be the most important part in your system performance or it may not… the case. There are whole classes of systems where Disk performance is not that important – consider for example systems where most… you have to consider a lot of topics – security, manageability, performance. I tend to advice different things depending on what is…
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
Recently I have had a chance to check out MySQL Performance on “Memory Appliance” by Violin Memory which can be used … queries/sec with multiple threads which corresponds to even worse scalability. Disabling adaptive hash index could take us to 14.500… which did not seems to give any significant performance benefit, may be even reducing performance few percents. I also tried running with…
Post: Percona's Sessions at the O'Reilly MySQL Conference and Expo
April 7, 2011 By Leave a Comment
… and Fixing MySQL Performance Problems (Monday Tutorial) Percona Server: secret features MySQL and SSD: Usage Patterns Achieving PCI Compliance with MySQL The Aspersa System Administrator’s Toolkit Percona Server and XtraBackup: painless operations Forecasting MySQL Performance and Scalability Summary tables, aggregate…
Post: Friends of Percona Get 20% Off at the MySQL Conference!
February 24, 2011 By 5 Comments
… and Fixing MySQL Performance Problems (Monday Tutorial) Percona Server: secret features MySQL and SSD: Usage Patterns Achieving PCI Compliance with MySQL The Aspersa System Administrator’s Toolkit Percona Server and XtraBackup: painless operations Forecasting MySQL Performance and Scalability Summary tables, aggregate…
Post: Meet MySQL Performance Blog guys on MySQL Users Conference
April 14, 2008 By Leave a Comment
Percona, the company maintaining MySQL Performance Blog has a good presence on the conference this year. … have: Sphinx: High Performance Full Text Search for MySQL (Andrew) EXPLAIN Demystified (Baron) The MySQL Query Cache (Baron) Investigating Innodb Scalability Limits (Peter,Vadim…
