Author: Mark Leith. Publisher: Planet MySql.Once upon a time, we used the slow query log and mysqldumpslow. Then MySql Proxy and the performance schema came along and proved themselves much more useful. Now, Performance Schema Statement Digests provide SQL access to the performance data. This article shows how to access the performance data through SQL.
Author: Mike Linville. Publisher: Black Dog Education.This 5 minute video gives us 3 tips for speeding up our WordPress site: Delete plugins that are not in use, reduce image sizes, and reduce each page’s content.
Author: Gavin Towey. Publisher: Planet MySql.This article suggests another way to use MySql’s slow query log: Set the long query time to 0.000 to gather all the data, then compute the total run time per day (avg run time X number of runs per day), then optimize the queries that use the most time per day rather than the most time per instance. To avoid creating your own performance issues, this article shows how to sample data rather than leaving the slow query log on all the time (i.e., continual measurement rather than continuous measurement).
Author: Dane Balia. Publisher: Code Project.Sometimes our code runs long. It’s not a performance issue – it takes a long time because it’s doing a lot of work. When this happens, though, we are faced with the dreaded “Stop Running this Script” question, at which point we are at the user’s mercy. This article proposes a solution. [Hint: It chops the work up into pieces.]
Author: Sandeep Mewara. Publisher: Code Project.This very short Q&A reminds us that testing performance in the test environment does not tell us what performance will be like in the production environment. [WG: Test in the test environment before transferring to production, then test in the production environment, then monitor the production environment on an ongoing basis.]
Author: Oracle MySQL Group. Publisher: Planet MySql.This article answers questions that were raised during a recent webinar about providing NoSQL Java access to MySQL Cluster via the ClusterJ and ClusterJPA APIs. These Java interfaces promise “extremely high performance for common operations.”
Author: Ilya Grigorik. Publisher: Ilya Grigorik.This article explains how SPDY, HTTPS, and NPN work together in Chrome. It also shows us how we can reproduce our own local “Silk proxy” setup in just a few lines of code and configuration.
Author: Aaron Brown. Publisher: Planet MySql.This article shows that keeping wanted rows can be faster than deleting unwanted rows. This is accomplished by copying the good rows to a new table, then renaming the tables. If you read this one, make sure to read the next one, too.
Author: Shlomi Noach. Publisher: Planet MySql.Contrary to the previous article, this article points out the likely performance problems that will result from INSERTing rather than DELETEing. It recommends deleting rows in small chunks over a period of time.
Author: Ovais Tariq. Publisher: MySql Performance Blog.”In this blog post I am going to give a high level picture of how Lazy Drop Table works and how the new DROP Table works in MySQL >= 5.5.23. After the explanation I will share the results of benchmarks that I ran to compare both the implementations. Note that whatever we are discussing here holds for when you are using innodb_file_per_table.”
Warren wrote his first computer program in 1970 (yes, it was Fortran). He earned his Bachelor of Arts degree from the University of Waterloo and his Bachelor of Computer Science degree at the University of Windsor. After a few years at IBM, he worked on a Master of Mathematics (Computer Science) degree at the University of Waterloo. He decided to stay home to take care of his newborn son rather than complete that degree. That decision cost him his career, but he would gladly make the same decision again. Warren is now retired, but he finds it hard to do nothing, so he writes web performance articles for the Monitor.Us blog. Life is good!