…028481 | | System lock | 0.000009 | | init | 0.000014 | | optimizing | 0.000002 | | statistics | 0.000005 | | preparing | 0.000006 | … example in web applications its typical to see a “sessions” table that is accessed on every… on the same table, and as such I have reported the bug: http://bugs.mysql…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… optimizer improvements effort. 100GB Results are more interesting because this is database size for which you can find results published on TPC Web… and may be MySQL 6.0 performance will improve. Though considering a lot of talks about optimizer improvements in MySQL 6.0 I expected drastically better results. Though may we should not be as surprised by these results – MySQL…
Post: Optimizing slow web pages with mk-query-digest
April 7, 2011 By 14 Comments
… when single mysql connection is used during execution of a request. If you are seeking to reduce the load on the database… most MySQL time and that’s how mk-query-digest groups and orders data by default. Fixing top 10 queries on the… then even better than that would be if it would optimize the queries all together! Unfortunately mk-query-digest won’t…
Post: Performance Optimization and Six Sigma
June 7, 2010 By 6 Comments
… doing with this in MySQL (and general Web performance management) ? Not So good. In most cases organizations focus on performance rather than performance…%. One reason we use rather weak confidence intervals in performance optimization is we need a lot of transactions to get stable… would like to see the technology vendors would focus more on the performance stability in their benchmarks. Way too often you…
Post: Joining Peter for MySQL Consulting
September 4, 2006 By 2 Comments
… September I’m leaving MySQL to partner with Peter on practice as well as work with him on some Web projects. I really enjoyed working under Peter’s guidance while working for MySQL… know how MySQL performs on different platforms and where bottlenecks are to be able to offer leading experience in MySQL Performance Optimization. If you…
Page: Presentations
May 3, 2006 By
…if you’re planing on upgrading to MySQL 5.0 Download Optimizing MySQL on Source Code Level MySQL Users Conference 2006, …MySQL Performance. Download MySQL and PHP for Web Applications Open Source Revolution 2002, Stockholm, Sweden Presentation about MySQL Server features and ways Focuses on MySQL…
Post: Announce: Front End Performance Optimization
October 10, 2008 By 8 Comments
… systems, typically web sites, which means we help customers with performance, scalability, high availability as the whole, not just MySQL related issues. Indeed if you look at MySQL driven web site its properties will likely depend on a lot of factors – good web… case. By adding front end optimization services we are able to help to deliver great performing web sites whatever performance limiting factors…
Comment: Why do you need many apache children ?
February 17, 2008 By 15 Comments
… stable large web site( no. 1 social networking site in China). In China, it is really hard to find guru on mysql, optimization because there are so many web sites cheating traffic. Many Chinese web sites does not have real traffic, only cheating alexa traffic and do evil. So there are small guru on optimization, scalability…
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
… replication, caching, using memcached, sphinx, implementing proper web caching etc. These changes are not only… more time and effort you should spend on optimization. Same often applies to HA as higher…are variety of companies on he market offering services around MySQL and LAMP and MySQL is one of …
Post: Commodity Hardware, Commodity Software and Commodity People
June 15, 2007 By 9 Comments
… experience with MySQL Cluster, other may be good with MySQL Cluster but have no idea how to write storage engines or optimize for Falcon storage engine. Relatively simple 1000 page book which would cover pretty much all of MySQL features in… solutions to be developed which operate on more flexible data structures, handle distributed semantics of web better and are expressive in a…
