June 19, 2013

Comment: Call for papers: Percona Live London

June 18, 2013 By 1 Comment

… eating, drinking or simply watching the show, this is the place to begin your search. At TicTune you can search for upcoming…. With an easy-to-use interface, search within distance, date, or by type or genre of shows you are interested in.

Filed Under: MySQL, Percona Live Tagged With:

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

June 18, 2013 By Leave a Comment

… folks with PXC in production and such the need for more advanced talks has arisen. As such, I wanted to shift gears…/pain-points for those with PXC in production already.   As such, I’m giving a webinar entitled Percona XtraDB Cluster Operations… topics that administrators of PXC will commonly ask about.  You can register for the webinar here.

Filed Under: Events and Announcements, Percona XtraDB Cluster Tagged With: , , , , , ,

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

June 18, 2013 By 30 Comments

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!

Filed Under: Benchmarks, Insight for Developers Tagged With: ,

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

June 17, 2013 By Leave a Comment

… run of chef-client is done to update the cnf files with IP address of members (excluding itself). The rationale behind… files are not required and preset it during cluster startup itself. The only caveat is that the node information – IP address or… SST (Note, the wsrep_sst_xtrabackup in 5.5.30 can‘t do those except parallel, the one in 5.5.31…

Filed Under: MySQL, Percona XtraDB Cluster, XtraDB Cluster Tagged With: , , , , , , , ,

Post: Percona MySQL University @Portland next Monday!

June 12, 2013 By Leave a Comment

… integrity And finally, Andrew Ferlitsch will share with how MySQL can be used to provide access to government data. The daylong… and work with MySQL, then this is an event you can‘t afford to miss… :)   So register now! Please also join the…

Filed Under: Events and Announcements, MySQL, Percona MySQL Consulting, Percona MySQL Support, Percona MySQL Training, Percona MySQL University, Percona Remote DBA Tagged With: ,

Post: Call for papers: Percona Live London

June 14, 2013 By 1 Comment

…, November 11-12 at the Millenium Gloucester Conference Center. Login or register as speaker and submit your proposals. Your participation is… you experienced while actively using MySQL, Percona Server, MariaDB, Drizzle or (fill in the blank) in production? Are you managing multiple… owe it to the MySQL community to share them. Don’t worry about being fancy. Some of the most popular talks…

Filed Under: MySQL, Percona Live Tagged With:

Comment: How to change innodb_log_file_size safely

June 13, 2013 By 17 Comments

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

Filed Under: MySQL

Comment: Sphinx search performance optimization: attribute-based filters

June 13, 2013 By 11 Comments

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

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

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

June 17, 2013 By 3 Comments

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

Filed Under: MySQL, Percona Server, Percona Software Tagged With:

Comment: Converting Character Sets

June 12, 2013 By 22 Comments

Approach number 1 is correct. There was no truncation: MEDIUMTEXT is bigger than TEXT. MySQL does this to make sure there’s *no* truncation, as explained in the manual – http://dev.mysql.com… “For a column that has a data type of VARCHAR or one of the TEXT types, CONVERT TO CHARACTER SET will…

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