News Feed
Jobs Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Andrew Johnstone's Blog:
MySQL & PHP Performance Optimization Tips
July 25, 2007 @ 07:49:00

Andrew Johnstone has posted a few handy tips to help you find out where in your application a certain kind of issue might lie - MySQL/PHP performance problems.

In high performance web applications you will always have bottlenecks within your application. Identifying these bottlenecks and optimizing is a tedious task and typically show themselves underload. A single bad/unindexed query can bring a server to its knees. A large number of rows will also help to highlight any poor queries, and on very large datasets you may come to the point where you may have to make decisions whether to denormilize database schema.

One of his recommendations is to run an EXPLAIN on each of the pages, showing what kinds of queries are being run and how long they could take. Once you've found that there is an issue somewhere, then you can move on to his next tip - using mysqlreport and mytop to watch the processes. He includes some sample commands to run, but there's more detailed information in a guide on hackmysql.com.

2 comments voice your opinion now!
performance mysql tip mysqlreport mytop explain index performance mysql tip mysqlreport mytop explain index


blog comments powered by Disqus

Similar Posts

PHPClasses.org: Lately in PHP, Episode 31 - The Urge to Kill Older PHP Versions

SitePoint PHP Blog: MySQL Transactions & Why They Canít Be Emulated in PHP

IBM developerWorks: Make PHP apps fast, faster, fastest (Part 1)

Content with Style Blog: Zend Framework DB and Mysql pre 5.17

Fabian's Blog: Better Performance patch for Symfony 1.0.x and Propel 1.2


Community Events











Don't see your event here?
Let us know!


database component symfony2 unittest release hhvm composer framework performance security hack facebook language podcast package introduction opinion overview application install

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework