Configuration Page

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:

Similar Projects

MySQL Report
Shadow - SQL queries / views optimization
Materialized View API
Views Optimized
Automated Views Optimize Indexes Detailer

Supporting organizations: 
Paid for mikeytown2 to develop & maintain this module

Project Information

Downloads