June 19, 2013

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: 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: 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!

Comment: Call for papers: Percona Live London

…, promoters, and members who come together to share with us of their upcoming live performances. If you’re in the mood… interface, search within distance, date, or by type or genre of shows you are interested in.

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

… tremendous interest and adoption.  There’s plenty of talks that explain the fundamentals of PXC, but we’re starting to reach a… necessarily be exhaustive, but to cover key topics that administrators of PXC will commonly ask about.  You can register for the…

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

…master is dying/dead. Yes, there are wrappers/scripts around this to make life easier, however, wouldn…which SSTs with node1 (based on gcomm://node1 of node2) through Xtrabackup SST (state snapshot transfer). …. Xtrabackup SST is used there. SST matters a lot because not only is it used during initial…

Comment: Sphinx search performance optimization: attribute-based filters

… 1200 tables each with hundreds of thousands of records, for we use sphinx based on attributes, but memory consumption is exaggerated, so we…

Post: Call for papers: Percona Live London

… know it was a rare opportunity to learn from some of the most accomplished system architects and developers in the business… is the showcase event for Europe’s growing MySQL community of developers, business managers, technology evangelists, DBAs and entrepreneurs. Download the…

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.

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

… output of SHOW PROCESSLIST that might be a sign that trouble is brewing. Or if you watch your MySQL server’s memory… see network latency wreaking havoc with MySQL’s internal understanding of what’s happening on the system below. Having never experimented…_db under strace, I saw that it was getting a lot of “bad file descriptor” errors. I was able to get the…