On the mysql command line:

The following two commans are useful to determine current connections:

•   SHOW STATUS WHERE `variable_name` = 'Threads_connected';

•   SHOW PROCESSLIST;

Centos prompt

You may update the mysql configuration which is located under /etc/my.cnf.

Two variables you may like to review are:

If you have an array in ascending order and you require it to be in descending order you can use the array_reverse function as below.

  $terms = array_reverse($terms);

The code below shows how to iterate through an array and print the keys and values held within an array.

while (list($key, $val) = each($items)) {
  print $key . " -> " . $val;
}

To allocate within a new array simply:

while (list($key, $val) = each($items)) {
  $terms[] = $val . ") " . $key;
}

A string can be replaced within a unix file using the 'sed' command. For example, it may that you've created a MySQL dump and you want to update a string and then import it back into the database.

For example, let's say we have a string '/var/www/vhosts/intranet2' within a file named 'intranet.sql' and we want to replace it with '/var/www/vhosts/intranet' and save it into a new file named 'intranet-updated.sql'.

You simply need to enter:

This can be checked easily with 'top' on Unix or the Task Manager on Windows.

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';