June 18, 2013

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

… topics that administrators of PXC will commonly ask about.  You can register for the webinar here.

Post: Percona MySQL University @Portland next Monday!

… Percona XtraDB Cluster, Percona Xtrabackup and Performance and Improvements and new Features in MySQL 5.6 Garrick Peterson, a member of… 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 cant afford to miss… :)   So register now! Please also join the…

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… for its sync status. As referenced in that post, you can refer a post by Peter Boros (“Percona XtraDB Cluster reference… the overhead of status checks, mainly on the node. You can also look this PLMCE talk for HAProxy deployment strategies with…

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.

Comment: Converting Character Sets

… change the data type as necessary to ensure that the new column is long enough to store as many characters as…

Comment: A common problem when optimizing COUNT()

This paragraph will assist the internet people for creating new webpage or even a weblog from start to end.

Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1

…: Yes [...] The error log tells us why the IO thread has not started: 2013-05-17 13:21:26 …mysql> start slave; and let’s create a new table on the master: mysql> create table test.t (id int not null auto_… file-based replication when gtid_mode is ON? I cant think of any use case, so in practice, you’…

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

…tracker thread was unaware of the situation when the oldest untracked log records are overwritten by the new…page data. Bug fixed #1108613. Percona Server wouldn’t start if the XtraDB changed page tracking …bit signed integers. Fixed so that these values can be 64-bit unsigned integers now. Bug fixed …