… Ever-Evolving MySQL Ecosystem” Simone Brunozzi, Senior Technology Evangelist, Amazon Web Services “Databases in the Cloud: Present and Future” Tomas Ulin, Vice… 10.0 & What’s New With the Project” Sergei Petrunia, Optimizer Developer, and Colin Charles, Chief Evangelist, MariaDB, for Monty Program…
Post: Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo
April 15, 2013 By 1 Comment
Comment: Should you move from MyISAM to Innodb ?
March 27, 2013 By 59 Comments
… love coding and the incredible power of using databases! Thanks to this specific article by Peter … well informed decisions about engines and other optimizations. Getting very involved in e-commerce I’… on my radar for future more critical web applications. I’ll be following mysqlperformanceblog.com …
Post: Web Site Optimization: FrontEnd and BackEnd
June 26, 2008 By 12 Comments
… off by client side optimization secondary. Second – The stakes for backend optimization are higher. If you do not optimize your web site on Frontend… back end optimization applies here – if you spend 90% time running PHP code and only 10% fetching data from MySQL database it does not make sense to focus on MySQL optimization. If 90% is spent on…
Post: Database access Optimization in Web Applications.
September 12, 2006 By 10 Comments
This is pretty simple approach I often use called to optimize web application performance if problem happens with few pages. If we… you can use. Just remember avoiding accessing database is the best way you can optimize database access. This applies to anything else – if… retrieved from the database matches information you display Way to often much more information is retrieved from the database than used to…
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
…and risks . First lets talk about optimizing application vs getting better hardware. With application optimization typically you have rather interesting relationship …time one would likely get couple of boxes to spread Web and Database instances and establish may be establish replication mainly to…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
… which will be dedicated for MySQL with large Innodb database using typical Web workload what settings you would adjust and interestingly enough… applications, though the optimal settings of course depend on the workload. Hardware If you have large Innodb database size Memory is paramount…
Post: Optimizing slow web pages with mk-query-digest
April 7, 2011 By 14 Comments
…. If you are seeking to reduce the load on the database server and [as a result] increase response time for some…, 97% no # Tmp table on 0% yes, 99% no # String: # Databases prod_db # Hosts localhost # InnoDB trxID 1153145C (2/0%), 11531626… then even better than that would be if it would optimize the queries all together! Unfortunately mk-query-digest won’t…
Post: Understanding Performance Optimization Terminology
March 2, 2009 By Leave a Comment
… to handle larger load (or operate with larger database) which comes to the question of performance on… comes from the fact you can set the optimization goals very differently. Some are concerned about development… and inefficient systems you can find among top web sites. It is not an exception to see…
Comment: Database access Optimization in Web Applications.
September 17, 2006 By 10 Comments
… to your claims: Remember, you titled your entry “Database Optimizations for Web Applications” emphasis on Web. So your example of selecting a 1 million… since if you’re returning 1 million rows to a web browser you’ve got bigger problems. Index coverage is certainly…
Post: A common problem when optimizing COUNT()
September 20, 2008 By 19 Comments
… it’s trying to do. You can’t fully optimize a query unless you know how to consider alternative …what they were trying to do with COUNT(). This is database-agnostic, not related to MySQL. The problem is when … Alas, there is a lot of misinformation on the web about COUNT(), so it is not a good place …
