…MySQL Cluster technology which is rapidly gaining popularity for building high performance and highly available systems with MySQL. Initially designed for Telecom Applications MySQL…
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 37 Comments
…performance improvements, however these days it is rarely important to MySQL…MYSQL, upgrade MySQL, 10x start/stop MySQL, upgrade MySQL, downgrade MySQL, upgrade MySQL, install a security fix for something, 20x start/stop MySQL, upgrade MySQL, … . Restarting and changing MySQL…the case for any high-…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
… For some this is 15 minutes job for others it is many month projects. Why is that ? Performing MySQL …run SELECT queries on both new and old MySQL installations and check result set, explain plan and execution… of scalability bugs in MySQL history when issues would only happen at high load. You can …
Post: Is your MySQL Application having Busy IO by Oracle Measures ?
January 8, 2012 By 1 Comment
… total numbers for “sharded” MySQL the numbers are not that high – many what would be considered medium scale MySQL installations would get there. With MySQL we… and this whitepapers you can get a lot better performance with multiple MySQL instances on powerful storage. When you move to multiple…
Post: What's required to tune MySQL?
July 27, 2011 By 4 Comments
… would be needed to tune[1] a database for better performance. It is a question that I hear … the likelihood of that happening is not extremely high in the general population. This blog’s articles…so keep in mind that the vast majority of MySQL installations don’t suffer from the variety and severity…
Post: Looking for RAID Controller without Battery Learning problems ?
January 5, 2012 By 7 Comments
…cache with MySQL in practice though. If you’re using it please share your experiences. if you’re looking for more …F (Normal) Installed memory : 512 MB Copyback : Disabled Background consistency check : Disabled Automatic Failover : Enabled Global task priority : High Performance Mode : Default/…
Post: My talks on PL MySQL Conference (+free book inside)
February 14, 2012 By Leave a Comment
…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 ? …
