… subsequent queries against the temp table fail. Q: Why doesn’t the query optimizer take care the execution decisions? Since they… just running the query in a suboptimal form. Q: Doesn’t the primary key solution for random selection only work when…. Q: Is the tuple comparison independent of sorting order? Wouldn’t it be a problem if the keywords were returned in…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… also for filtering by just the first one. Why can’t MySQL enforce this kind of constraints? For many reasons: the…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… any workaround. However IMO all these bugs don’t mean you should not use GTIDs, you just need to …
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
@Kristian: Good point. I haven’t tried GTIDs in combination with multi-threaded slave yet, as enabling GTIDs only has provided a few surprises. So this hadn’t come to my mind. @Shlomi: Fixed, thanks!
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
@Kristian, Well, the (slave) server *knows* whether it is replicating in parallel or not, so it doesn’t have to always manage the general case. When it knows it uses single thread replication the “last executed” assumption is safe.
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… position needs to be done with care if you don’t want to break replication or corrupt your data. Scenario #2… and s4 are also lagging behind). s2> select count(*) from t; +———-+ | count(*) | +———-+ | 2 | +———-+ # s1 is behind s1> select count(*) from t; +———-+ | count(*) | +———-+ | 0 | +———-+ Can we still use master_auto_position = 1? …
Comment: Is there a performance difference between JOIN and WHERE?
May 29, 2013 By 30 Comments
… that rule — extenuating circumstances and all that — but it shouldn’t be a daily (or even weekly) occurrence.
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
… able to start Corosync and Pacemaker but the node doesn’t join the cluster 
May 23 08:34:12 percona1 corosync[1535]: [MAIN ] parse error in config: Can’t open logfile ‘/var/log/corosync.log’ for reason: Permission denied… servers… let’s put the cluster in maintenance mode (don’t forget you should have done this even before updating the…
Comment: ZFS on Linux and MySQL
May 28, 2013 By 17 Comments
… it) for a 4k block size. lzjb seems interesting, hadn’t heard of it before. @Nils, In a way that is…
Comment: MySQL alternative Percona Server 5.1.68 -14.6 now available
May 28, 2013 By 3 Comments
Hi, I can’t find any 5.1 files in the yum repos. Have they been moved to a new location (for example, I’m checking repo.percona.com/centos/5/os/x86_64/ )? The apt repo seems to be okay though. Thanks!
