… on what is called “FrontEnd”. The meaning of Frontend is not the frontend web server commonly used in many architectures but rather optimization on… 10% fetching data from MySQL database it does not make sense to focus on MySQL optimization. If 90% is spent on other tasks than fetching…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
… load on the system. MySQL Log analyzes with Mk-Log-Parser is a very good start for a ways to generally optimize MySQL load on…) and when there come various wait times – mysql, memcache, sphinx, web services etc. For web applications doing processing in a single thread the… application there is often the question if it is MySQL server causing the problem or if application code needs to be optimized.
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… Queries on MySQL because subqueries optimizer weakness. I’m saying about XA which were released in MySQL 5.0 without consistent work with MySQL close… in MySQL I have created more than hundred of such little projects suggested by MySQL customers and myself based on long MySQL usage for Web…
Post: ORDER BY ... LIMIT Performance Optimization
September 1, 2006 By 93 Comments
… BY in interactive applications with large data sets being sorted. On many web sites you will fine top tags, recently registered users… it is indexed) Force index if needed In some cases MySQL Optimizer may prefer to use different index, which has better selectivity… solution for this problem is ether extending your indexes so MySQL Optimizer does not have to chose between better sort or better…
Post: Database access Optimization in Web Applications.
September 12, 2006 By 10 Comments
… simple approach I often use called to optimize web application performance if problem happens with few pages…. could you do ? Look at the information shown on the page which comes from database. This … For example SELECT COUNT(*) FROM links WHERE domain = ‘mysql.com’; will return only one row while …
Post: MySQL Consulting - Being on your own
February 20, 2007 By 7 Comments
…MySQL and LAMP systems in general, LAMP performance optimization, replication and high availability, scaling, writing whitepapers, helping people with data recoveries, implement MySQL…. Projects Leaving MySQL we wanted not only to work as consultants but also to work on our own Web projects. This …
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…
