… user to lock records for edit/update, so the transaction is not interrupted until the transaction is finished/committed? A example of…
Comment: Announcement of Percona XtraDB Cluster 5.5.20 GA release
May 9, 2012 By 10 Comments
I deleted comment from someone with name “mr unhappy”. The comment did not provide constructive feedback. If you have problem … and we are doing our best to answer on questions about XtraDB Cluster in our mailgroup http://groups.google.com/group/percona-discussion
Post: Testing Intel SSD 520
May 1, 2012 By 7 Comments
… PCIe cards. Of course PCIe still provides better numbers, but the question is how much MySQL can use. In his keynote Mark… they use are highly underutilized. With the performance variance we see it is a good question how does it affect MySQL performance…=d.createElement(s);js.id=id;js.src=”//platform.twitter.com/widgets.js”;fjs.parentNode.insertBefore(js,fjs);}}(document,”script”,”twitter…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… rows, the cost of querying will go up by another factor of ten (it will be 100 disk seeks to answer a… IOstat. Tim’s measurements (http://www.tokutek.com/2012/01/1-billion-insertions-%E2%80%93-the-wait-is-over/) on a newer… http://tokutek.com/downloads/iiBench-1.0.3.1.tar.gz One of the advantages of the newer version of iiBench (the python version…
Comment: Multi Column indexes vs Index Merge
May 10, 2012 By 30 Comments
HI Peter I had a question regarding index merge (intersect). Below are two explains that I executed for the same SQL query with… was using a single index. I would greatly appreciate your answer. First explain —————– explain SELECT LinksTbl2.id, LinksTbl2.title, LinksTbl2.url…
Comment: Multi Column indexes vs Index Merge
May 8, 2012 By 30 Comments
Hi Peter. Your Article its too interesting. I have a question, i know that index or many index on a table … it true? And if is it, how could i balance the choice??? too many indexes and high performance select or high… few indexes??? how balance it??? I wait for a your answer! Thank u. All regard
Post: Announcement of Percona XtraDB Cluster 5.5.23
May 14, 2012 By 11 Comments
… IP addresses for a new node, it will connect to the first available Binaries are available from downloads area or from… Linux) 5 and 6, and Debian packages. Downloads: http://www.percona.com/downloads/Percona-XtraDB-Cluster/ Documentation Codership Wiki General Discussion group…
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
… non response time critical activities are overloading the system causing user experience to degrade. The first thing you need to know it… the response times will increase and user experience will suffer. So what you can do to prevent this problem from happening ? The answer is easy. Throttle the side load so it does not consume too much…
Comment: Testing Intel SSD 520
May 3, 2012 By 7 Comments
…, If that is the case, that is really stupid step from Intel. On this page http://www.intel.com/content/www/us/en/solid… I just figured that Intel 520 uses compression. http://www.intel.com/content/www/us/en/solid-state-drives/ssd-520-tech-brief…
Post: Zero-Downtime Schema Changes In MySQL
May 3, 2012 By 2 Comments
… of questions, and did not have enough time to answer all of them, so let me try to answer some of the remaining questions here. Q: Isn’t it possible to take all the locks required in the beginning to…
