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: How to load large files safely into InnoDB with LOAD DATA INFILE
June 18, 2013 By 29 Comments
Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!
June 17, 2013 By Leave a Comment
… (PXC), and also to solicit use cases from the readers. One of the prominent usages in the production environment that we….1 is required for most). Finally, the HAProxy. HAProxy is one of the loadbalancers recommended for use with PXC. The other… and clustercheck with a single serving process (we are adding one in 5.5.31), looking for optimizations with HAProxy to…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… (and I can investigate further), but I believe the adaptive hash index is improving performance of InnoDB significantly during the hot run, as hash indexes are faster than a b-tree index. Also accessing… InnoDB both cold and hot. SSB Flight #4 There is one query in this flight, Q4.3, which is faster using…
Comment: Converting Character Sets
June 12, 2013 By 22 Comments
… a column that has a data type of VARCHAR or one of the TEXT types, CONVERT TO CHARACTER SET will change…
Post: Percona MySQL University @Portland next Monday!
June 12, 2013 By Leave a Comment
… Monday, June 17. The latest in a series of FREE one-day educational events, we are pleased to feature 10 technical…
Post: How people are using MySQL... from 1 user to 100 million (upcoming conference talk)
June 11, 2013 By Leave a Comment
… deployment and scaling scenarios, when it makes sense to use one or an other, and common pitfalls we typically see in…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… well for this, but can quite slow on larger schemas. One of the downsides to mysqldump is the need to scan… to grant access to another “backup” server. As noted by one of my colleagues (thanks Bill Karwin!), the cumbersome part of…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… combination with heartbeat or pacemaker or something similar, and if one of the servers in the DRBD pair is having issues… 4? Two of those NICs should be directly connected from one machine to another and configured with Linux network interface bonding… (admittedly, not that much – I have personally only worked with one customer that’s using 5.6), is that I question…
Comment: MySQL Query Patterns, Optimized - Webinar questions followup
June 5, 2013 By 2 Comments
Hi Oleksii, thanks for viewing my webinar and your comments. I use the short index names because the alternative would require the font size on the slides to be very small. I know that abbreviated index names are harder to understand, but hopefully the tradeoff is the right one.
Comment: MySQL Query Patterns, Optimized - Webinar questions followup
June 5, 2013 By 2 Comments
… and even unusual things like tuples P.S. just an one small thing, yes, I understand – there is just an example…
