… we have: Sphinx: High Performance Full Text Search for MySQL (Andrew) EXPLAIN Demystified (Baron) The MySQL Query Cache (Baron) Investigating Innodb Scalability Limits… information you would hear on the talk. We’re also better prepared this year from Business side than last year – we…
Post: How we work on High Performance MySQL Second Edition
November 12, 2007 By 12 Comments
… of hard editorial work. Due to these problems, to get better book and get the book out faster we wanted to… could also add value to the Book. I always liked Barons blog posts which were often very explanatory easy to understand… good writer but also fast writer. Another strong point of Baron are having experience working with a lot of other database…
Post: Percona's Commitments to MySQL Users
November 5, 2010 By 10 Comments
…over. MySQL has never progressed so rapidly towards better features, better performance, and better quality. We applaud the great work coming … Chief Executive Officer Vadim Tkachenko, Chief Technology Officer Baron Schwartz, Chief Performance Architect Tom Basil, Chief Operating Officer Bill Schuler…
Post: How InnoDB handles REDO logging
February 3, 2011 By 19 Comments
Xaprb (Baron) recently blogged about how InnoDB performs a checkpoint , I thought it might be useful to explain … allows you to control the transaction log record size, as better performance may be gained with 4096 byte records with newer media…
Comment: Derived Tables and Views Performance
January 15, 2009 By 16 Comments
Baron: You know what your right. Somehow in the past I … to be pieces of the aggregate. Was able to get better performance at the time on multiple queries in a row (first…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 28 Comments
…or miss takes. If you approach application performance optimization from the standpoint of response time …useful you can do with Key_reads: [baron@localhost ~]$ mysqladmin ext -ri10 | grep Key_reads | … there are many unscientific approaches that are better than ratio-based tuning. Counter ratios suck…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… you can look at the system to predict in performance, the model baron has published for example is good for measuring scalability… per Query and compare it to estimated (or benchmarked) system performance to provide our estimates. If we’re running Innodb with… of hardware will take you to reach appropriate performance, what kind of hardware provides better balance of CPU vs IO utilization as…
Post: MySQL versions shootout
October 10, 2011 By 6 Comments
As part of work on “High Performance MySQL, 3rd edition”, Baron asked me to compare different MySQL version in some simple … is nothing unexpected, staring with InnoDB-plugin, MySQL scale much better on multi-cores, there is gain up to 1.7x… MySQL 4.1 couple years ago, I have seen biggest performance hit comes from query parser. In MySQL 5.0 grammar…
Post: Sphinx 0.9.8 is released just in time for OSCON 2008
July 20, 2008 By 2 Comments
As you probably already seen in a post by Baron, Sphinx Release 0.9.8 is finally out, just in … build in full text search uses) you can get performance another 20-100% better though search result quality will be reduced. Or… can just disable ranking. Another interesting point is Sphinx grouping performance. For example on the same 15M document collection counting number…
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
…. In reality only two queries (from 22) have significantly better execution time (about them in next posts), but I …Using Index condition’, what I was able to find is Baron‘s bug with no mention in MySQL 6.0 …KEY (li_shp_dt_idx) (full table scan will be performed in this case) then we got: 1 min 39….
