Optimize a table in MySQL from the command line interface

If you have MySQL tables that grow large and then have a lot of deletes they will become fragmented and larger than they need to be. This post looks at how to look at check to see if a MySQL table is no longer optimal and how to optimize it.

Display DNS cache on Windows

It is possible on Windows to display the DNS cache from the command line. This can be useful for diagnosing DNS issues where an invalid or out of date DNS record might be cached. This post looks at how to displayed cached DNS records on Windows.

PHP CLI counter for long running processes

I’ve been doing a reasonable amount of PHP CLI (command line interface) programming recently for getting stuff from log files and converting large numbers of images. Some of these processes can some quite a while to run, sometimes as long as several hours, so it can be useful to know roughly how far through the process it is.This post looks at how to output a counter to the command line from PHP which replaces itself on each iteration.

Categories PHP

Sending email with Zend_Mail

The Zend Framework is a PHP framework with many individual components that do not require you to use the whole framework. In this post I will look at how to send an emailusing the Zend Framework’s Zend_Mail component.

Categories PHP