This project is not covered by Drupal’s security advisory policy.
Wondering why your views run so slow? Why after switching to InnoDB, MySQL isn't running any better? This module has the answers!
Indexes
It will show what CCK columns get used in a view filter or relationship and give you the option to add an index on it so the views query will run faster. Also can add indexes to core modules that could use one.
Engine
Ability to convert your database from MyISAM to InnoDB in order to eliminate table locks on data writes.
Collation
Are half your tables latin1_swedish_ci and the other half utf8_general_ci? Use this to change them all to utf8_general_ci.
MySQL Tuner
Have you never edited your my.conf file? This will give you hints at what values to tweak in order to get MySQL running better. Special thanks to MySQL Tuner, since this part of the module is a port of that project.
Future Plans:
- Figure out which experimental indexes are good & which ones are bad
- #798756: Better index suggestions with filters and sorts. Manage Multi Column Indexes
- #799230: Run explain on every views query
- #799236: Run explain on every query in the slow query log
- #817688: Engine Selection Per Table; Suggest you put site into maintenance mode
Similar Projects
MySQL Report
Shadow - SQL queries / views optimization
Materialized View API
Views Optimized
Automated Views Optimize Indexes Detailer
Project information
- Seeking co-maintainer(s)
Maintainers are looking for help reviewing issues. - Module categories: Performance
- 42 sites report using this module
- Created by mikeytown2 on , updated
- This project is not covered by the security advisory policy.
Use at your own risk! It may have publicly disclosed vulnerabilities.