I’ve been helping customers deploy and maintain MySQL (and variants) for the last couple of years and it … consulting customers, but widely from different forums and blogs – how should I install MySQL on my server and what pros and cons… be as easy as stopping MySQL, updating symlinks or your my.cnf basedir, starting MySQL and running mysql_upgrade. Unlike package managers, you…
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
… I decided to post them as a Blog Post. Q: Can you go directly MySQL 5.0 to 5.5 for MyISAM… getting any significant development since MySQL 4.1, so in-place upgrade of MySQL 5.0 to MySQL 5.5 should be rather…_index_creation feature, as I just wrote this option can help creating tables a lot faster. You can also use pt…
Post: Percona Live MySQL Conference and Expo 2013 - News from the Committee - Part 1
November 8, 2012 By Leave a Comment
… a member of the committee for the “big” MySQL conference: Percona Live MySQL Conference and Expo 2013 in Santa Clara, CA. Personally… of the various committee members that helps form a strong group that is representative of the MySQL community at large. I do… and lots of practical MySQL experience Great products in the MySQL ecosystem I’ve been asked to keep blogging on the committee’s…
Post: Using XtraBackup on NFS for MySQL backups
December 9, 2010 By 6 Comments
XtraBackup works great for backing MySQL up to an NFS volume, but there is a gotcha … more than that — we’ve blogged before about that. Let us know if you want help with that.) You can solve this…
Post: How Percona strives to remain neutral and independent
March 21, 2011 By Leave a Comment
… companies in the MySQL ecosystem are Percona customers, including hardware manufacturers, software…into agreements that restrict our ability to help the prospect solve their problems in the…with the values discussed previously in this blog post. A partnership relationship usually implies some…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… date_id column. There will be another blog post about the usage and performance of the…avaialble data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact’… results. There is a helpful utility (included in the image) to help configure the cluster and …
Post: Advanced index analysis with mk-index-usage
November 11, 2010 By 2 Comments
… Maatkit has a useful feature in mk-index-usage to help you determine how indexes are used in more flexible ways…, but it’s often helpful to ask more sophisticated questions about index usage. I’ll use this blog‘s queries and indexes… set up an SSH tunnel from my laptop to the MySQL Performance Blog server — another 30 seconds. Now I’m set up…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…. What about partitioning in MySQL 5.1? I know there are some cases when it can help a lot, and we… a three-part article on data archiving on my own blog a while back. The benefits of purging and archiving… save that work by either using MySQL 5.1′s row-based replication, or in MySQL 5.0 and earlier, doing the…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…service). I thought I should write a blog post that will both answer their question,…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql… solutions, all of which we can frequently help customers set up much more efficiently and…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
… be helpful.  I am still getting a really solid # of hits in memcached, but the # of writes in MySQL coupled… data in the database is silly. Yes the guy who blogs on bigdbahead.com and is writing this on the mysqlperformanceblog… to be helpful. I am still getting a really solid # of hits in memcached, but the # of writes in MySQL coupled with…
