…. After that, a segment always reserves whole 64 page extents. Thus, the answer to the question is: for small tables, everything can reside… per second. PZ: Not what this answers question exactly. So is it activated as soon as 128 pages must be flushed ? If so…. 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
… HT: A query thread normally posts about 64 page read requests per a readahead. The InnoDB …is a somewhat trivial question, but it’s hard to find a good answer to it while googling… do not have much resources for scalability research. Peter Zaitsev, Vadim Tkachenko, Yasufumi Kinoshita, and Mark …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… I should write a blog post that will both answer their question, so I can just reply “read all about …But that’s a huge job; it will take many pages, and I’m not going to write that much. … some further work about 6 months after Peter helped a client. Now, if Peter worked with the client 6 months …
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
…predictable performance. I refer you to Peter‘s post, Performance Optimization and Six…MySQL. The post also answers the question of whether we are going … 5.5 code line. The answer: Yes, we are. My benchmarks …innodb_flush_neighbor_pages=0 , to disable flushing of neighborhood pages (not available …
