Here are some basic strategies for optimising Drupal's use of the database.

Enabling MySQL's Query Cache

To enable add the following lines to to your MySQL options file - the file is named my.cnf and specifies the variables and behaviour from your MySQL server.

# The MySQL Server
[mysqld]
query_cache_size=64M

The current cache size can be viewed as output of MySQL's SHOW VARIABLES command:

SHOW VARIABLES LIKE 'query_cache%';

query_cache_size | 67108864
query_cache_type | ON

• Mailchimp
• Eventbrite

Also are shopfront side:

• Shopify

The code below shows an example of how to add javascript files for a specific node (in this case nid of 339).

Within the template.php file for the admin theme (e.g. Garland) enter the following:

# disable revisions
# Added by Zerotouch
# Ref http://drupal.org/node/289466
function phptemplate_node_form($form) {
unset($form['revision_information']);
return theme_node_form($form);
}

Within the settings.php file the default and legacy databases can be defined. An example is shown below.

$db_url['default'] = 'mysqli://user:password@localhost/default_database_name';
$db_url['legacy'] = 'mysqli://user:password@localhost/legacy_database_name';