Howto: Fix a Slow Bitnami Redmine Stack

June 25, 2010

Problem: Redmine is running super slow.
Version: Bitnami Redmine Stack on Windows
The Fix
1. Run MySQL System Tray Monitor (accessible from either of these methods):

  • Start menu – MySql – MySQL System Tray Monitor
  • “C:\Program Files\MySQL\MySQL Tools for 5.0\MySQLSystemTrayMonitor.exe”

2. Right click on system tray icon and from the popup menu select Actions -> Manage MySQL Instances
3. Click “Startup Variables” Icon
4. In the ‘General Paramaters’ tab change key buffer usage to 512 M (if your machine has 4096MB of ram)
5. Click apply changes

Basically MySQL’s key buffer usage needs to be increased.