June 20, 2013

Comment: What technologies are you running alongside MySQL?

Sphinx for searching Memcached for caching MongoDB for analytics Can anyone compare the Lucene and sphinx performance?

Comment: Can't Create Thread: Errno 11 (A Tale of Two Ulimits)

… easy though: # grep proc /proc/8416/limits Max processes 95918 95918 processes # echo -n “Max processes=95917:95918″ > /proc/8416/limits bash…

Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!

… SST (Note, the wsrep_sst_xtrabackup in 5.5.30 cant do those except parallel, the one in 5.5.31… the overhead of status checks, mainly on the node. You can also look this PLMCE talk for HAProxy deployment strategies with… small team. That strongly implies scalability of resources – you scale more with less, and that is how it should be. We…

Post: MySQL Webinar: Percona XtraDB Cluster Operations, June 26

… shift gears from the standard introductory talk and focus instead more on some key questions/issues/pain-points for those with… topics that administrators of PXC will commonly ask about.  You can register for the webinar here.

Post: Call for papers: Percona Live London

… owe it to the MySQL community to share them. Don’t worry about being fancy. Some of the most popular talks…

Comment: How to change innodb_log_file_size safely

@Question: Did your innodb engine startup correctly? Seems to me that you can see any innodb dbs because of this.

Comment: Sphinx search performance optimization: attribute-based filters

… with only 10 groups per 10M records), then you don’t want to use this. Please see “Highly selective columns only” section for examples where it doesn’t work well for us too.

Post: Choosing a MySQL HA Solution - Post-Webinar Q&A

… port. [Don’t try more than 2; the additional work that the kernel has to do in reordering TCP packets can actually result in… we can consider it truly production-ready. I suppose I should state an obvious disclaimer here in that the aforementioned statements reflect…

Comment: Implementing SchemaSpy in your MySQL environment

… you define large schemas, and what do you mean by cant cope? * Is this a concern regarding crashes of the tool… features don’t work past N number of tables? In my experience, the schemas I have under SchemaSpy reach at max approximately… this is generally no more than a couple minutes. I haven’t tried pulling this schema into Workbench so I cant comment as to…

Post: ZFS on Linux and MySQL

… just normal.  We didn’t try too hard to get better performance because we already had more than enough for our purpose and… write filesystem, the snapshots are free, no performance penalty.  You can easily run a server with hundreds of snapshots.  With LVM…