All pastes #42614 Raw Edit

Someone

public text v1 · immutable
#42614 ·published 2006-02-21 08:28 UTC
rendered paste body
function memory_check() {
  $min_memory_needed = (int) ($global_buffers + ($thread_buffers * $max_connections->Value));
  $global_buffers = (int) ($key_buffer->Value + $net_buffer->Value);
  $thread_buffers = (int) ($read_rnd_buffer_size->Value + $sort_buffer->Value + $myisam_sort_buffer->Value + $read_buffer->Value + $join_buffer->Value); 
  $key_buffer = db_fetch_object(db_query('SHOW VARIABLES LIKE "key_buffer_size"'));
  $net_buffer = db_fetch_object(db_query('SHOW VARIABLES LIKE "net_buffer_length"'));
  $max_connections = db_fetch_object(db_query('SHOW VARIABLES LIKE "max_connections"'));
  $read_rnd_buffer_size = db_fetch_object(db_query('SHOW VARIABLES LIKE "read_rnd_buffer_size"'));
  $sort_buffer = db_fetch_object(db_query('SHOW VARIABLES LIKE "sort_buffer_size"'));
  $myisam_sort_buffer = db_fetch_object(db_query('SHOW VARIABLES LIKE "myisam_sort_buffer_size"'));
  $read_buffer = db_fetch_object(db_query('SHOW VARIABLES LIKE "read_buffer_size"'));
  $join_buffer = db_fetch_object(db_query('SHOW VARIABLES LIKE "join_buffer_size"'));
  echo "<tr><td><center<b>" . t('Minimum Memory Needed : ') . $min_memory_needed .  "</b></center></td></tr>";
  echo "<tr><td><center<b>" . t('Global Buffer : ') . $global_buffers .  "</b></center></td></tr>";
  echo "<tr><td><center<b>" . t('Thread Buffers : ') . $thread_buffers .  "</b></center></td></tr>";
  echo "<tr><td><center<b>" . t('Key Buffer : ') . $key_buffer->Value .  "</b></center></td></tr>";
  echo "<tr><td><center<b>" . t('Net Buffer : ') . $net_buffer->Value .  "</b></center></td></tr>";
  echo "<tr><td><center<b>" . t('Max Connections : ') . $max_connections->Value .  "</b></center></td></tr>";
  echo "<tr><td><center<b>" . t('Read Rnd Buffer Size : ') . $read_rnd_buffer_size->Value .  "</b></center></td></tr>";
  echo "<tr><td><center<b>" . t('Sort Buffer : ') . $sort_buffer->Value .  "</b></center></td></tr>";
  echo "<tr><td><center<b>" . t('Myisam Sort Buffer : ') . $myisam_sort_buffer->Value .  "</b></center></td></tr>";
  echo "<tr><td><center<b>" . t('Read Buffer : ') . $read_buffer->Value .  "</b></center></td></tr>";
  echo "<tr><td><center<b>" . t('Join Buffer : ') . $join_buffer->Value .  "</b></center></td></tr>";
}