As you probably already seen in a post by Baron, Sphinx Release 0.9.8 is finally out, just in … full-text ranking altogether, for example when you’re sorting by price, you can just disable ranking. Another interesting point is… (so no temporary table or sorting is needed for group by). Note that with Sphinx you can easily run the process…
Comment: InnoDB Flushing: a lot of memory and slow disk
April 1, 2011 By 57 Comments
Patrick Casey, throttling is preferrable to “panic flush routines”. The panic flush routine causes the 0-throughput ranges seen in the chart posted by Baron. Those are to be avoided. The optimal solution would be a smooth throttling.
Comment: InnoDB Flushing: a lot of memory and slow disk
March 31, 2011 By 57 Comments
Patrick Casey, throttling is preferrable to “panic flush routines”. The panic flush routine causes the 0-throughput ranges seen in the chart posted by Baron. Those are to be avoided. The optimal solution would be a smooth throttling.
Post: How we work on High Performance MySQL Second Edition
November 12, 2007 By 12 Comments
Baron have been updating you a lot about chapter by chapter progress so I should not repeat it, instead I …. Finally we were joined by Baron who could also add value to the Book. I always liked Barons blog posts which were often very… presentations blog posts etc. Baron or Arjen use it to write most of chapters which get further in depth review by me and…
Post: Working on "High Performance MySQL, Second Edition", how you can help?
August 31, 2007 By 20 Comments
As you may already have seen announcement by Baron we’re working on major rewrite of High Performance MySQL … over half a year now and were later joined by Arjen Lentz and Baron I think we make a great team and… in reviewing one or more chapters. We’ll keep you posted as book progresses when we have any more information
Post: InnoDB Flushing: a lot of memory and slow disk
March 31, 2011 By 57 Comments
… may have seen in the last couple of weekly news posts that Baron mentioned we are working on a new adaptive flushing… of our research. We set these goals: Provide stable throughput by avoiding big jumps in flushing pages. Make the algorithm independent…. We have made good progress, and I will keep you posted on our ideas and results.
Comment: What does Handler_read_rnd mean?
June 25, 2010 By 15 Comments
…_rnd_next is incremented by N+1. The reason for the extra 1 is the EOF test mentioned by Baron. The query execution… inserting rows into the small table. Inserting a row followed by SELECT * does increment Handler_read_rnd_next. However, the second… study the source code to see what is up. Will post once I know.
Comment: What does Using filesort mean in MySQL?
December 20, 2009 By 27 Comments
…Salle: Your Post #8 I see you insert two records in the table ‘… not very clear. Moreover I get the behaviour as explained by Baron. Am I missing something? >>> (root@localhost) [test] CREATE TABLE t1… Warnings: 0 (root@localhost) [test] EXPLAIN SELECT * FROM t1 ORDER BY id\G *************************** 1. row *************************** id: 1 select_type: SIMPLE table: t1…
Post: Spreading .ibd files across multiple disks; the optimization that isn't
December 25, 2010 By 23 Comments
Inspired by Baron‘s earlier post, here is one I hear quite frequently – “If you enable …
Comment: About This Blog
March 27, 2009 By 48 Comments
[...] The MySQL Performance Blog, and this post in particular, The perils of InnoDB with Debian and startup scripts, by Baron Schwartz answered our question. [...]
