DB Tuner | WUI knowledgebase

Component ID

761348

Component name

DB Tuner

Component type

module

Maintenance status

Seeking co-maintainer(s)

Development status

Under active development

Component security advisory coverage

not-covered

Downloads

22544

Component created

Sun, 04/04/2010 - 12:00

Component changed

Tue, 12/02/2014 - 12:00

Component body

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.

Categories