June 20, 2013

Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4

May 29, 2013 By 2 Comments

…MySQL [p_mysql] (unmanaged) p_mysql:0 (ocf::percona:mysql): Master percona1 (unmanaged) p_mysql:1 (ocf::percona:mysql): Slave percona2 (unmanaged) p_mysql:2 (ocf::percona:mysql…

Filed Under: MySQL, Percona Software Tagged With: ,

Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer

March 29, 2013 By 10 Comments

… set (search results, recent users, recent posts, etc) Full page output (relatively static pages…how one would start the memcached plugin: mysql> install plugin daemon_memcached soname ‘libmemcached.so’;… standard memcached instance and a minimally tuned MySQL 5.6 instance running the memcached plugin…

Filed Under: MySQL Tagged With: , , , ,

Post: Virident vCache vs. FlashCache: Part 1

May 16, 2013 By 3 Comments

… benchmarks for the use case where the MySQL working set is significantly larger than the …is superior. Winner: vCache. Ease of post-setup modification / advanced installation. Many of the FlashCache device parameters … I’d vote in the other direction. Stay tuned for part two of this series, wherein …

Filed Under: Benchmarks, Hardware and Storage, MySQL Tagged With: , , , , ,

Post: Which Linux distribution for a MySQL database server? A specific point of view.

December 8, 2011 By 38 Comments

…install, configure, tune, start/stop 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…

Filed Under: Insight for DBAs, MySQL

Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A

October 28, 2012 By 4 Comments

…cnf settings again? A: Sure, see this post or webinar recording. Q: Fault tolerance: … and built-in mysql replication are independent from each other. Q: I installed Percona as …specific recommandations for Zabbix, but general InnoDB tuning recommendations apply here, in large zabbix deployments…

Filed Under: MySQL, XtraDB Cluster

Post: How Percona does a MySQL Performance Audit

November 24, 2008 By 17 Comments

…popular service). I thought I should write a blog post that will both answer their question, so I …work with systems that are at any level of tuning, from completely untuned to a system that’s …a /var/lib/mysql and an /etc/my.cnf, and the server is installed in /customsoftware/mysql with a different …

Filed Under: Insight for Developers Tagged With:

Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark

March 11, 2013 By 7 Comments

…performance differences and are documented in the post. This blog post is not a definitive conclusion about … both servers from source (cmake -gui .; make; make install) Only changes from defaults was that both …: Default config for MySQL 5.5 and MySQL 5.6, no tuning at all Config 2: MySQL 5.6 with…

Filed Under: MySQL Tagged With: , , , , ,

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

…respect to InnoDB full-text search in this one post, but I think there’s a lot of …same data sets, and then finally in the third installment, we’ll look at query performance. In the event…used the community editions of MySQL 5.5.30 and MySQL 5.6.10 with no tuning whatsoever (with one exception…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

…the like. We are using MySQL 5.5.30 and MySQL 5.6.10 with no configuration tuning other than to set … type Uh… Does this mean that my next blog post should be entitled, “When is a VARCHAR Not Really …be happy that you did. In the third and final installment of this series, we will take a look at …

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: Paul McCullagh answers your questions about PBXT

November 20, 2009 By 2 Comments

…to is best described visually – see this post for more info. What were the ….09) supports the MySQL Backup API which was originally implemented in MySQL 6.0. This …tuning parameters, in particular, just the cache values. On the other hand, I aim to provide expert tuning parameters for installations…

Filed Under: Insight for Developers, MySQL Tagged With: , , , , ,
« Older Posts