Author Archive

MySQLTuner 1.0.0 is now available

It has finally arrived. MySQLTuner 1.0.0 is now available for download. Major improvements include full support for MySQL 5.1 and Solaris. You can review other changes in the changelog.
As always, I’d like to personally thank everyone who has made this release possible. Your efforts have provided benefits from MySQL users worldwide, [...]

Upgraded to Wordpress 2.6.5

If you run a Wordpress blog, and you haven’t upgraded to Wordpress 2.6.5, you might want to make the move soon. There were a few bugs and security issues fixed, along with other changes.

Importing Excel files into MySQL with PHP

If you have Excel files that need to be imported into MySQL, you can import them easily with PHP. First, you will need to download some prerequisites:
PHPExcelReader - http://sourceforge.net/projects/phpexcelreader/
Spreadsheet_Excel_Writer - http://pear.php.net/package/Spreadsheet_Excel_Writer
Once you’ve downloaded both items, upload them to your server. Your directory listing on your server should have two directories: Excel (from PHPExcelReader) [...]

Plesk: Upgrade to 8.4 causes “no such user” error in maillog

If you have a Plesk server where short mail names are enabled, upgrading to Plesk 8.4 can cause some issues. Valid logins may be rejected, and they’ll appear in your /usr/local/psa/var/log/maillog as “no such user”. You can correct the issue by switching to long mail names (click Server -> Mail in Plesk), or [...]

Viewing documentation for your ruby gems

As I get started with ruby, one of the things I’ve noticed is that ruby’s documentation could be a bit better.  However, I discovered that this four line ruby script will give your documentation for your server’s installed gems:

1
2
3
4
#!/usr/bin/env ruby
require "rubygems/server"
options = {:gemdir => Gem.dir, :port => 4242, :daemon => true}
Gem::Server::run(options)

Thanks to Daniel for the [...]