I had problems with the database load. I suspect some of the django generated queries might require new indexes to perform better. Mysql has an option to log slow queries. That would be very helpful in determining which indexes to create. Can I activate this option or something similar on a shared db instance, or do I have to install my own instance of mysql? asked 21 Apr '13, 09:53 wuerg |
The slow query log on the shared MySQL server can only be activated by WebFaction staff. You would need to open a support ticket to have that done on the shared MySQL server. You may also want to consider installing a private instance of MySQL. We now offer a one-click installer for mysql from the Control Panel. This means you can install a private mysql instance like any other application. You would then import your databases into the new mysql instance. The benefit is that you have full control over the configuration, but it uses the system libraries so any patched like security holes would be applied for you. answered 21 Apr '13, 11:45 aaront ♦♦ |