MySQL repair all tables

mysqlcheck -u root -p --auto-repair --check --optimize <dbname>

Mysql replication: purging binary logs

It is recommended to purge or recycle the master/slave db binary logs on a daily or weekly basis

Here is the command:

purge binary logs before '2012-05-01';

http://dev.mysql.com/doc/refman/5.0/en/purge-binary-logs.html

Bandwidth Monitor Linux tools

Good command line tools:
bwm
bwm-ng
iftop

Useful links:
http://www.ubuntugeek.com/bandwidth-monitoring-tools-for-linux.html

SendMail Testing tool

Use the following tools to test your SendMail server:
http://www.mxtoolbox.com
https://www.wormly.com/test_smtp_server


Default SendMail configuration allows listening only to 127.0.0.0
That causes SendMail to accept emails from internal accounts only.
To receive emails from the whole world, Edit Network ports and change 127.0.0.0 to the server external IP address or set it to All.

Building and install PerlMagick on windows

Please follow the following steps
- It requires downloading the source code package of ImageMagick.
- Goto VisualMagick folder
- Build the solution via Visual Studio
- Add VisualMagick\bin to environment PATH
- Goto PerlMagick directory
- Copy MakeFile.nt to MakeFile.PL
- perl MakeFile.PL
- nmake
- nmake install
- restart windows
- nmake test

Linux checking network services

Check the service listening to port 25

netstat -tunap | grep :25

Fixing MySQL stuck in prerequisites state

Set the following option in configuration file:
optimizer_search_depth=3