… promised Heikki Tuuri to answer Innodb Questions. Heikki is a busy man so I got answers to only some of the questions but as people… tests by Peter Zaitsev, O_DIRECT works well to remove double buffering. In distant future, I would like to have the memlock… of the primary key. PZ: Thanks Heikki, Remember we’re waiting you to answer second portion of the questions. UPDATE: Second Part of the answers is…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
I now got answers to the second portions of the questions you asked Heikki. If you have not seen the first part it can be… a somewhat trivial question, but it’s hard to find a good answer to it while googling.“What is the good way… have assigned Inaam as the InnoDB scalability engineer. We do not have much resources for scalability research. Peter Zaitsev, Vadim Tkachenko, Yasufumi…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… thought I should write a blog post that will both answer their question, so I can just reply “read all about it… work? Peter‘s report 6 months ago was a small encyclopedia!” The mistake here was that the consultant didn’t show all the things… there really isn’t any such thing. Post your questions in the comments, and I’ll try to answer them as time permits.
Post: devops webinar - follow up Q&A
November 6, 2012 By 5 Comments
… reduce the attention your operation team could pay to them. This is a similar problem as in the story of Peter and the Wolf… the name when Terry asked the question during the call but I pronounce it usually using the French pronunciation. So to answer your question, Liquibase is probably the…
Comment: Should you move from MyISAM to Innodb ?
January 16, 2009 By 59 Comments
On the MySQL Performance Blog, Peter Zaitsev’s question is, should you move from MyISAM to Innodb? Peter and his readers lay out the criteria he think are at play when answering this question for yourself. — Log Buffer #131
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
… Peter Z two guides but cannot really convert the gained knowledge to solve our situation. Lesser questions but probably as well important. b. The question really is how do you determine the memory consumption per connection in average? This leads to the next question c. Can we have a limit of 600 connections when every connection consumes X mb. If the answer to…
Comment: Duplicate indexes and redundant indexes
September 22, 2006 By 38 Comments
Hi Peter, thanks for your reply. In the mean while, I found out that at least in MySQL, the prefix redundancy problem just… I think it does not answer my question. My question was – would the optimizer somehow benefit if we would mark the longer index also as… great if you could think a bit about my original question regarding UNIQUE indexes. But either way: thanks!
Comment: COUNT(*) vs COUNT(col)
April 11, 2007 By 45 Comments
… of the story. No, it doesn’t cache the row count. Wish it were that simple. The whole situation is more complex. The points Peter…). Now one must also ask the question whether or not it is a valuable thing to know the accurate number of rows in… the performance of counting all the rows in a table. This discussion is a good example of Peter‘s other comments today … simple answers…
Comment: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
Peter, This is the case when benchmarks have little value as it is very … you cases with no difference as well as huge difference. The problem with utf8 is mainly when it comes to in… things can happen. The question is whenever moving to UTF8 is REQUIRED when you upgrade to MySQL 5.5 and the answer is – not…
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 attendees…’s why there’s fewer of them. Thanks for the compliment on the booth. I’ve already harassed Jay about this … there… and it works very well, but that requires people at the booth who can answer technical questions.
