…whole table if you a) choose your aggregation to match the order of your common queries and b) … star schemas. The problem is that MySQL doesn’t tend to perform well on a data warehousing workload. …seen this approach scale well. Use The Best Technologies You Can MySQL is not the end-all and be-…
Post: The Optimization That (Often) Isn't: Index Merge Intersection
December 14, 2012 By 6 Comments
…performance win, perhaps. Sometimes it is. Other times, it is a major performance killer. It’s fairly straightforward to tell when MySQL…if we stopped after retrieving the 17k rows matching user_type=2, we’d save …actually a problem) but probably not the best way to go for a permanent solution…
Comment: Full text search for all MySQL Storage Engines
June 29, 2006 By 37 Comments
… they will perform somewhat bad when you need a sort by date). The reported index size on disk is including mysqls own…, sort them by date and finally pick up the 200 best matches (desc by date or asc by date). As you can… conversations I have had with the developer and hopefully the performance will increase aswell. In my case it would be much…
Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 3, 2008 By 15 Comments
… did it couple of weeks ago so MySQL 5.0.67, MySQL 5.1.29 and Innodb Plugin 1….online Maximum performance for each number of cores was taken though it was reached with number of sessions matching …. The RW-Lock patch is best in this case. It shows increased performance while decreased CPU usage. Note …
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
…MySQL Performance optimization tasks but there are number of things you need to know. First let me clarify what MySQL… parsing) before cache lookup, so they have to match byte by byte for cache hit to happen…complex queries producing small result set will be offering best speed up. So when it is good …
Post: Percona and the MariaDB Foundation
December 19, 2012 By 3 Comments
…, empowering users to get the best performance and lowest downtime possible. We focus on compatibility with Oracle MySQL, High Quality, and small but… pick the best innovations which match our project goals for inclusion in Percona Server and other Percona software, wherever in the MySQL Ecosystem…
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
…have had a chance to check out MySQL Performance on “Memory Appliance” by Violin Memory which can be… filesystem and SysBench tool. Using 16K read sizes (matches Innodb page size) I could get 1.2GB/sec… much data in buffer pool as possible for best performance. Hopefully some time in the future I get …
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
…questions on how to tackle application performance. These questions are: Should we …two. Implementing memcache may look like best idea from economic standpoint until … think our services is a good match for a lot of companies …he market offering services around MySQL and LAMP and MySQL is one of them…
Post: Percona's Commitments to MySQL Users
November 5, 2010 By 10 Comments
…and to our customers’ goals. And we think the best way to do that is by adhering to …for MySQL, for those whose needs are not met by the official MySQL server from Oracle. It offers more performance, … customers. Our pricing model has always been to match value for the customer with Percona’s costs …
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
…will be depend on the number of rows that match the condition ‘key_column=x’. You can see …captured when performing the benchmark on IO bound workload, mentioned above. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5….part of the optimizer’s job to select the best query execution plan. I had noted a similar …
