June 18, 2013

Post: How Percona does a MySQL Performance Audit

…I should write a blog post that will both answer their question, so I can just reply “read all … at the server beforehand, so we can ask more intelligent questions and skip obvious things. This call is … further work about 6 months after Peter helped a client. Now, if Peter worked with the client 6 …

Post: Heikki Tuuri answers to Innodb questions, Part II

I now got answers to the second portions of the questions you asked Heikki. If you have not seen the first part it… believe this is a somewhat trivial question, but it’s hard to find a good answer to it while googling.“What… engineer. We do not have much resources for scalability research. Peter Zaitsev, Vadim Tkachenko, Yasufumi Kinoshita, and Mark Callaghan from outside…

Post: devops webinar - follow up Q&A

… got. As promised during the webinar, these are the answers of the questions you asked. Q: Does Percona provide plugin for cacti? A…. This is a similar problem as in the story of Peter and the Wolf Q: Did you hear about Liquibase, for… when Terry asked the question during the call but I pronounce it usually using the French pronunciation. So to answer your question, Liquibase is…

Post: How Percona strives to remain neutral and independent

…little bias as possible (but see also Peter‘s post on bias) based on …– lying by omission, so to speak. The answer is that vendors might not be …the sales process. For example, they might ask us to participate in a product …work is uncompromised. If you have any questions or comments, I invite you to …

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

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

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… execute 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: Why do you need many apache children ?

Peter! Very interesting stuff. I was wondering if you could comment (either in this post or perhaps in another) about a question I get quite a bit in my seminars. I often get asked whether it is better to use persistent connections (specifically for MySQL) and my answer has been the following…