June 20, 2013

Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A

… attended my webinar, I got many questions and I wanted to take this opportunity to answer them. Q: Even ntp has a… full data is copied when you SST again. Q: Thanx Peter, I loved the webinar!  Especially the fact that that everything… am glad you liked it:). Thanks everyone for all these questions, feel free to ask additional ones in comments.

Comment: When would you use SAN with MySQL ?

Thanks, Peter. It is always very nice to get your question answered as blog post – I suspected that might happen :^) especially as I’m not the only one with this question these days..

Comment: COUNT(*) vs COUNT(col)

… that simple. The whole situation is more complex. The points Peter makes about use of indexes, covering indexes and NOT NULL… one at a time). Now one must also ask the question whether or not it is a valuable thing to know…. This discussion is a good example of Peter‘s other comments today … simple answers are fine as far as they go. But…

Comment: MySQL Upgrade Webinar Questions Followup

Peter, This is the case when benchmarks have little value as … happen. The question is whenever moving to UTF8 is REQUIRED when you upgrade to MySQL 5.5 and the answer is – not…

Comment: Multi Column indexes vs Index Merge

HI Peter I had a question regarding index merge (intersect). Below are two explains that I … 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

Hi Peter. Your Article its too interesting. I have a question, i know that index or many index on a table … few indexes??? how balance it??? I wait for a your answer! Thank u. All regard

Post: How Percona strives to remain neutral and independent

…with as little bias as possible (but see also Peter‘s post on bias) based on our knowledge …unfair situation — lying by omission, so to speak. The answer is that vendors might not be ready with …name and work is uncompromised. If you have any questions or comments, I invite you to use the comment…

Post: MySQL 5.5.8 and Percona Server: being adaptive

…also stable and predictable performance. I refer you to Peter‘s post, Performance Optimization and Six Sigma. In …between them and MySQL. The post also answers the question of whether we are going to have releases … on the MySQL 5.5 code line. The answer: Yes, we are. My benchmarks here are based …

Comment: Heikki Tuuri answers to Innodb questions, Part II

peter created an interesting post today on Heikki Tuuri answers to Innodb questions, Part II.Here’s a short outline:We improved the…

Comment: MySQL on OSCON

Peter, First, I think your headcounts are a bit pessimistic because … well, but that requires people at the booth who can answer technical questions.