I have a very busy database that is locking up and crashing because of the high load. The script that runs is very intensive but I need it to continue. I want to have as much tweaking and optimization done as possible to help avoid problems.
I know I want this done:
1. enable slow query logs if it does not exist and monitor the slow log, you
can propose indexes that need to be put in place to speed things up.
2. view runtime status in phpmyadmin and evaluate what configuration changes must be done to optimize the database.
3. based on #2 you should create/optimize the [url removed, login to view] file
4. Must monitor the DB for a few days to adjust settings as necessary