Mastering the art of indexing

Check out this SlideShare Presentation: This is a good presentation on Indexing and how it relates to INNODB.

More mastering the art of indexing

View more presentations from Yoshinori Matsunobu.

Transfer PuTTY settings between computers

Putty stores its settings in the Windows registry. To save a backup of your Putty settings, you'll need to export this registry key to a file.

HKEY_CURRENT_USER\Software\SimonTatham

From the Start->Run Dialog enter the following.

regedit /e "%userprofile%\desktop\putty.reg" HKEY_CURRENT_USER\Software\Simontatham

The above command will place a copy of the backup on your desktop.

MySQL blocked because of Too Many connections

MySQL server will block connections in case of too many connections. After solving the problem creating too many connections from web server, in some cases still we can see that MySQL blocks the webhosts.

We had to run the following command in mysql server, at the command prompt:

mysqladmin flush-hosts -uroot -pxxxx