News Feed
Sections




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

SitePoint PHP Blog:
Optimizing MySQL
April 04, 2014 @ 11:54:48

The SitePoint PHP blog has posted the first two parts of their "Optimizing MySQL" tutorial series by Peter Nijssen. The first looks at general tips around indexes and the second shows some configuration tips to get the most from your database systems.

MySQL is one of the most used databases in conjunction with PHP. Making sure that your MySQL databases are running at their best is one of the most important aspects you have to consider whenever your web application grows. In this series of 3 standalone articles, we will have a look at how we can optimize our MySQL installation. We will take a look at which optimizations we can perform on our database, on our MySQL configuration and how we can find potential problems when MySQL is not performing well.

The first tutorial walks you through a brief introduction to indexes, shows you how to find duplicates and unused indexes that might be hanging around. The second post deals with the configuration topics using the Percona pt-variable-advisor. They also make use of the MySQLTuner tool for even further enhancement. Finally, the article finishes with a look at cross-server configuration comparison and how to see the differences.

0 comments voice your opinion now!
mysql series performance percona configuration indexes

Link: http://www.sitepoint.com/series/optimizing-mysql/

blog comments powered by Disqus

Similar Posts

Padraic Brady's Blog: Self-Contained Reusable Zend Framework Modules With Standardised Configurators

Daniel Cousineau's Blog: Hierarchical Data With PHP and MySQL

Juan Treminio: Introduction to Vagrant/Puppet and introducing PuPHPet

PHPFog Blog: Scaling PHP Up, Out, and Around

Evolt.org: Failover Database Connection with PHP + mySQL


Community Events





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


interview application library code introduction framework language developer configure project list wordpress series laravel threedevsandamaybe bugfix release community podcast api

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