Category: mysql

First Look at Yahoo’s MySQL Performance Analyzer

When you deploy an app to production servers, you may experience some database problems as your data grows. Some tools can help you debug and solve your problems, like MysqlTuner, Percona, etc. In this article, we’re going to explore the Yahoo MySql performance analyzer and see what the main features are.Installati...

Re-introducing PDO – the Right Way to Access Databases in PHP

PDO is the acronym of PHP Data Objects. As the name implies, this extension gives you the ability to interact with your database through objects.Why not mysql and mysqli? The very valid question people ask when confronted by a new technology is simply, why should they upgrade? What does this new technology give them ...

Caching Hat-trick: Zend Opcache, Etags and Query Caching

In this article, we will be looking at some of the common caching techniques in PHP: Opcache, Expires Headers and Query Caching in MySQL. We’ll look at additional approaches in part 2.PHP’s Request Lifecycle Before we move on, it’s important to understand PHP’s request lifecycle. What happens behind the scene...

A Simple Workflow From Development To Deployment

  In this article I’ll be taking a look at how to build a simple yet robust workflow for developing sites that require PHP and MySQL. I’ll show you how to use Vagrant to create and run a web server on your own computer, with the version of PHP your live site runs. I also demonstrate a process for u...

25 New & Useful PHP Techniques & Tutorials

PHP is the most popular and widely accepted server side scripting language among developers due to its easy to learn nature, free of cost and its large ever increasing helpful community. Here are 25 useful PHP techniques and tutorials, most of which have been published only in this year. 1. Facebook type image rotatio...