PDA

View Full Version : Monitor performance mysql



michael_s
07-20-2007, 09:11 AM
This adds a delete button to clear the qlog table. Update only, Not full package.

In catalog/admin/mysqlperformance.php:

FIND:
require('includes/application_top.php');

ADD AFTER:
switch ($HTTP_GET_VARS['action']) {
case 'deleterecords':
tep_db_query("delete from " . TABLE_MYSQL_PERFORMANCE);
tep_redirect(tep_href_link(FILENAME_MYSQL_PERFORMA NCE));
break;
}

FIND:





ADD AFTER:
















FIND:






CHANGE TO:









FIND:











ADD AFTER:



In catalog/admin/includes/languages/english/mysqlperformance.php:

ADD BEFORE ?>:
define('TEXT_DELETE','Delete all records?');
define('IMAGE_BUTTON_DELETE','Delete all records');
define('IMAGE_BUTTON_CANCEL','Do not delete records');


More... (http://www.oscommerce.com/community/contributions,4689)