Tutorial: MySQL Connection Management and caching in PHP

Posted on in Categories MySQL, php, Tuning last updated August 8, 2006

Jay Pipes writes about MySQL Connection Management and caching in PHP.

This small tutorial will help you understand the MySQL Connection Management and caching in PHP.

FTA, “This article is intended to highlight various basic topics concerning proper methods of handling connections to MySQL databases in PHP, guidelines for caching dynamic content, and a technique called “lazy loading”. Hopefully by the end of the article you’ll have learned how to combat a very widespread and potentially devastating scalability problem seen in an enormous number of PHP web applications

Read more at jpipes

On a related note MySQL Performance Blog also covers caching techniques such as:

  • TTL Based Caching
  • Cache Invalidate
  • Cache Update
  • Version based caching

Posted by: Vivek Gite

The author is the creator of nixCraft and a seasoned sysadmin and a trainer for the Linux operating system/Unix shell scripting. He has worked with global clients and in various industries, including IT, education, defense and space research, and the nonprofit sector. Follow him on Twitter, Facebook, Google+.

1 comment

Leave a Comment