June 19, 2013

Comment: Call for papers: Percona Live London

… members who come together to share with us of their upcoming live performances. If you‘re in the mood to enjoy a…, this is the place to begin your search. At TicTune you can search for upcoming local live performances. These live performances are… much more. With an easy-to-use interface, search within distance, date, or by type or genre of shows you are interested in…

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: What technologies are you running alongside MySQL?

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

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

… to make life easier, however, wouldn’t it be nice if this was…locking period from its use (which means the donor is blocked for a shorter while). By using Xtrabackup for SST, youused with xinetd on the node along with a script which checks PXC for its sync status. As referenced in that post, you can

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…. These stories are gold! And you owe it to the MySQL community to share them. Don’t worry about being fancy. Some…

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

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

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

….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…

Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL

Why does the mysql client says it’s 5.1.70? Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 138 Server version: 5.1.70-rel14.7-log Percona Server (GPL), 14.7, Revision 572

Comment: Data mart or data warehouse?

Great article. Did you do a part 3-6? I did not see them in your posts. I would appreciate an email if you did. Thanks.