June 19, 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: Call for papers: Percona Live London

… artists, venues, promoters, and members who come together to share with us of their upcoming live performances. If you’re in… place to begin your search. At TicTune you can search for upcoming local live performances. These live performances are usually found… restaurants, clubs, bars, theaters, festivals and much more. With an easy-to-use interface, search within distance, date, or by type or…

Comment: What technologies are you running alongside MySQL?

Lucene/Solr for Searching Memcached for Caching a lot of stuff Varnish for caching too, but that’s a bit different

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

Hm, yeah, I just tried it on my F18 system (kernel 3.9) and got the same error. Apparently this is a 2.6.x hack only, or maybe there is some other workaround for newer kernel versions that I’m not aware of.

Comment: What technologies are you running alongside MySQL?

Lucene/Solr for Searching Memcached for Caching a lot of stuff MongoDB as a job queue

Comment: How to load large files safely into InnoDB with LOAD DATA INFILE

I used to be recommended this blog via my cousin. I am not certain whether this put up is written by means of him as no one else know such exact about my trouble. You are incredible! Thank you!

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

… required for most). Finally, the HAProxy. HAProxy is one of the loadbalancers recommended for use with PXC. The other one is glb. HAProxy is used with xinetd on the node along with a script which checks PXC for its…

Post: Call for papers: Percona Live London

… actively using MySQL, Percona Server, MariaDB, Drizzle or (fill in the blank) in production? Are you managing multiple environments? Are you working with MySQL… content for MySQL newcomers as well as the veterans. We’re also looking for sponsors. This is the showcase event for Europe’s growing MySQL

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

… where it’s easier to find folks with PXC in production and such the need for more advanced talks has arisen. As… focus instead more on some key questions/issues/pain-points for those with PXC in production already.   As such, I’m giving… administrators of PXC will commonly ask about.  You can register for the webinar here.

Comment: Sphinx search performance optimization: attribute-based filters

… works well for highly selective attributes. If attributes only have few distinct values (e.g status, gender, group_id 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.