Tutorial: MySQL Connection Management and caching in PHP

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, DevOps engineer, and a trainer for the Linux operating system/Unix shell scripting. Get the latest tutorials on SysAdmin, Linux/Unix and open source topics via RSS/XML feed or weekly email newsletter.

Share this on (or read 1 comments/add one below):

1 comment

    Have a question? Post it on our forum!