Miguel, SO MySQL does indeed behave differently depending on whether ISOLATION is set to READ …? I’m just confused by the statement in the article: “it behaves as if you use READ COMMITTED for all write… spite of your chosen transaction isolation level” That statement makes it sounds like no matter which level you set ISOLATION to…
Post: Tokyo Tyrant - The Extras Part I : Is it Durable?
November 10, 2009 By 5 Comments
… tchdbput will flush it ). I did not test with async, in fact to the best of my knowledge it does not look like tyrant supports async, even though cabinet does.  Which means the… written out to disk without calling msync was very flaky indeed. I had anywhere from 5 seconds of missing data…
Comment: Percona turns two today !
August 1, 2008 By 13 Comments
Thanks Colin ! Indeed it does not feel that long when you’re busy 
Post: RAID and Scale Out Discussions
June 12, 2007 By 3 Comments
… solved with commodity hardware and commodity people. RAID can be indeed slower than direct disks. For example for BoardReader now indexing… which make it possible. The boxes we use indeed even have RAID available which is used for OS hard drive. Indeed using RAID…. As it does not use many CPUs and many hard drives very efficiently in many cases so going much higher does not buy…
Post: How multiple disks can benefit for single client workload ?
April 26, 2008 By 4 Comments
… drives does not help if you have single query (or stream of queries) which you need to deal with. This is indeed… though people often forget to account for it. If we take 15K RPM Hard Drive it does 250 rotations per second (4ms per… well. So as you might see tuning IO subsystem can indeed be fun – there is a lot to deal with not…
Post: UNION vs UNION ALL Performance
October 5, 2007 By 13 Comments
…. But So is UNION ALL indeed faster than UNION DISTINCT (the UNION is shortcut for UNION DISTINCT) ? Indeed it is. I did not… it indeed should be. So why UNION ALL is faster than UNION DISTINCT ? The first informed guess would be – because UNION ALL does… temporary table can only be seen in SHOW STATUS – EXPLAIN does not want to tell you this shameful fact: mysql> explain…
Comment: Is DRBD the right choice for me?
July 8, 2009 By 17 Comments
… things 1) When you want application to be up often does not only applies to failures but also minimizing scheduling downtime…. 2) Anders: The switch to the slave is not instant – it indeed needs to catch up but in well configured systems (in… of the seconds. 3) Anders: Indeed it is possible for master to remain in tact after failure. It would be reasonable to run…
Post: Add an option to Fail on Innodb Initialize failure, Please ?
October 11, 2007 By 9 Comments
… it is the time to return to it again. During MySQL 5.0 release cycle the change was made so now MySQL does… file is corrupted, and indeed you still can get this error message in such case, but now it is used for completely… and think it is indeed .frm corruption – trying to restore .frm from backup or other servers and being extremely frustrated as it does not…
Post: How Percona strives to remain neutral and independent
March 21, 2011 By Leave a Comment
… a specific benchmark, and you want us to validate that it does. When we publish the results, we will reveal that the… the product and its suitability for various use cases, including all known downsides. For example, if your product does extremely well on… by the vendors. After the evaluation is over, we may indeed endorse the solution, but to the extent we can, we…
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
… positives. mk-table-checksum is a tool to do it. It turned out replication indeed had an issue replicating triggers. The problem should….0 to 5.1 replication to see if it runs properly. It turns out it does not because of the old bug which I… where hiring external consultant it especially makes sense. The team, even if it includes skilled MySQL DBA typically does not need to go…
