All osCommerce shops require a MySQL database to function but little attention is given to it. Just ask yourself when was the last time you optimized your database? Unfortunately, this is a big mistake since MySQL is prone to developing problems. Some are fixed as the database runs but some are not and, over time, these grow and can severely effect your shops performance. This addon will automatically tune-up the database (the cron setup is required) and fix problems many shop owners will not even know exist. Here are some of its features:
- Defragment the tables
- Optimize the keys
- Strip the customers tables of old data
- Strip the sessions table of old data
- Strip the user tracking table (if present) of old data
- Remove old credit card numbers