--- system.admin.inc 2008-03-20 12:45:27.000000000 -0700
+++ system.admin.inc.bak 2008-03-20 12:44:17.000000000 -0700
@@ -1755,7 +1755,7 @@ function _system_sql($data, $keys) {
* Menu callback: return information about the database.
*/
function system_sql() {
-
+
$result = db_query("SHOW STATUS");
while ($entry = db_fetch_object($result)) {
// 'SHOW STATUS' returns fields named 'Variable_name' and 'Value',
@@ -1772,17 +1772,7 @@ function system_sql() {
'Com_lock_tables' => t('The number of table locks.'),
'Com_unlock_tables' => t('The number of table unlocks.')
));
-/*
- The key buffer is the main index and memory buffer for MyISAM tables. Allocating it enough space is important to maintaining performance.
- http://dev.mysql.com/doc/refman/5.0/en/server-parameters.html
-*/
- $output .= '<h2>' . t('Key Buffers') .'</h2>';
- $output .= '<p>'. t('The MySQL key buffers are used in (only) MyISAM tables to store indices in memory. If you have only a small percentage of your key buffer free. Consider allocating more memory to your key_buffer_size.') .'</p>';
- $output .= _system_sql($data, array(
- 'Key_blocks_unused' => t('The amount of space free in your key buffer.'),
- 'Key_blocks_used' => t('The amount of space used in your key buffer.')
- ));
-
+
$output .= '<h2>'. t('Query performance') .'</h2>';
$output .= _system_sql($data, array(
'Select_full_join' => t('The number of joins without an index; should be zero.'),