Optimized MySQL database and Queries

This website account was suspended due to using too much system resources through database queries. I reviewed and optimized the Mysql database by deleting hundreds of thousands of old records, adding indexes and optimizing tables. I reviewed the code and optimized queries to better address how the client was using the data. I then wrote a script run by crontab weekly to delete all new records over six months old to keep the database tables from growing too large.