… the answers I have so far. Plus we may get some interesting follow up questions out of this. I had added my comments to some of the questions. HT will stand for Heikki Tuuri in the answers…. What are your suggestions here? HT: According to tests by Peter Zaitsev, O_DIRECT works well to remove double buffering. In…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… my comments for some of the answers under PZ and will use HT for original Heikkis answer. Q26…the first file in a log file group. My questions are: What is always being written to …do not have much resources for scalability research. Peter Zaitsev, Vadim Tkachenko, Yasufumi Kinoshita, and Mark …
Comment: Duplicate indexes and redundant indexes
September 22, 2006 By 38 Comments
Hi Peter, thanks for your reply. In the mean while, I found … an intersting case too, but I think it does not answer my question. My question was – would the optimizer somehow benefit if we would mark… would be great if you could think a bit about my original question regarding UNIQUE indexes. But either way: thanks!
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… should write a blog post that will both answer their question, so I can just reply “read all …. Examining MySQL configuration Then I’ll look at my.cnf quickly for anything weird: [percona@db1 ~]$ grep -v … further work about 6 months after Peter helped a client. Now, if Peter worked with the client 6…
Comment: MySQL on OSCON
July 27, 2007 By 13 Comments
Peter, First, I think your headcounts are a bit pessimistic because of the size of the rooms. My talk had about 60… well, but that requires people at the booth who can answer technical questions.
Comment: How simple answer are you looking for ?
April 11, 2007 By 5 Comments
… answer or a single answer to anything. Just take a look at my latest set of slides… on slide 2, I say “The answer to every question is… it depends.” Cheers, and see you soon at the conference, Peter!
Comment: Why do you need many apache children ?
February 5, 2007 By 15 Comments
… 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… use persistent connections (specifically for MySQL) and my answer has been the following (based on my understanding of Apache): If you are talking…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
…also stable and predictable performance. I refer you to Peter‘s post, Performance Optimization and Six Sigma. In… them and MySQL. The post also answers the question of whether we are going to have releases… MySQL 5.5 code line. The answer: Yes, we are. My benchmarks here are based on Percona Server…
Comment: Sphinx: Going Beyond full text search
July 26, 2007 By 18 Comments
Peter, thanks for the answer on SphinxSE. We’ll probably implement native sphinx. My new question, do you know if sphinx allows the index to be read in reverse? Michael
