This post will be about benchmarking of MySQL Persistent Connections vs Non-Persistent Connections -- what always seems to be a hot topic among PHPers about what connection type to use when connection to a MySQL database...
mysql
MySQL Connection Management in PHP
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...
Install & Configure IPplan IP Manager in openSUSE
IPplan is a free opensource IP Address management application. IPPlan is a web based IP address management software and tracking tool simplifying the administration of your IP address space. IPplan goes beyond IP address management including DNS administration, configuration file management, circuit management and storing of hardware information.
Using tmpfs for MySQL tmpdir setting
Speed up mysql tmp table creation by putting it in the ramdisk...
Additional reading: Dans' Blog
How to backup and import a MySQL InnoDB database
Due to the way Innodb tables are structured, you cannot perform a hotback up of this database without using third party tools. Therefore you must take your database offline for a small period of time while you take the backup...