… 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 …
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… 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…
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.
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
… for all, who attended my webinar, I got many questions and I wanted to take this opportunity to answer them. Q: Even ntp… 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: 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!
Post: Accessing Percona XtraDB Cluster nodes in parallel from PHP using MySQL asynchronous queries
March 6, 2013 By 2 Comments
…to Peter‘s recent post, “Investigating MySQL Replication Latency in Percona XtraDB Cluster,” in which a question was…question: If we have N nodes, can we send queries to nodes to be executed in parallel? To answer…using an example from PHP docs. So there is my example on how to access Percona XtraDB …
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… 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…
