…low concurrency SSB tests when Peter blogged about the importance of…. Also, while it is labeled on the graphs, it is important to …is faster than InnoDB, but usually only when the buffer pool is cold. Please…work with. MyISAM does not maintain checksum consistency during regular operations and is not…
Post: Percona Live MySQL Conference 2013 wrap-up
… Chair, Shlomi Noach, for working through over 300 …those talks were: Oracle is investing a tremendous…” align=”alignright” width=”300″] Peter Zaitsev kicks off … the conference so it included all significant MySQL server …please check in a few days if the slides you would like to access are not…
Comment: Should you move from MyISAM to Innodb ?
…Please be prepared for a very bad day. It *will* come. 3. I’m not suggesting InnoDB is…application is probably tuned to work with MyISAM. Just as your application would not work …not my intent. I was merely trying to point some issues with regard to your post. As a final suggestion, please read Peter…
Post: How Percona Develops Open-Source Software
…comes from and where it goes. These are all fair points to bring up. Peter, Vadim and I…is ported to a newer server. In a separate category, there’s also work that we do for customers which is not…to create custom MySQL features or builds for you, please contact us. Why We Don’t Grant Commit …
Post: Heikki Tuuri Innodb answers - Part I
…Please use this with care: you MUST use row-based binlogging and replication, and remember that the execution is not…works – it is global MySQL Server option, though it may have problems on Linux if you lock very large portion of physical memory. There is…
Post: Percona welcomes Ryan Lowe and Vladimir Fedorkov
… growing. This time around, I’m pleased to welcome Ryan and Vladimir. Ryan …Peter have known each other and worked together for years in past endeavors. Vladimir can make Sphinx do just about anything, and is…services to our clients? It‘s not all about query optimization.) Vladimir is also the leader …
Comment: mysql-proxy, urgh performance and scalability ?
…Peter points out: It is interesting to look at the overhead curve across different applications. My rule of thumb for 0.7 performance is…it can spend on other queries). Lots of work… for it, but are not quite …It explains the architecture clearly, we are hoping
In case you find any bugs, please…
Comment: MySQL Upgrade Webinar Questions Followup
…Peter: when I did… upgrade required. Please do “REPAIR TABLE `account`” or dump/reload to fix it! this error happens to all my innodb tables, I understand that “repair table” statement does not work with innodb, thus, I had to do a “alter table table_name engine=innodb”, which is…
Comment: Getting MySQL to use full key length
Peter, this ought to work. The EXPLAIN should be like in the second case whether FORCE INDEX clause is present or not. The “use range(index) instead of ref(the-same-index)” heuristics has been in the code since long time. IIRC it had some bug but we’ve fixed quite some time ago. Could you please post the table DDL…

