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.