PDA

View Full Version : Monitor performance mysql



michael_s
04-08-2010, 07:00 AM
I HAVE FOUND 3 ERROR:

1 for check line
2 for check tab
3 for path of file



Please note follow line in Catalog/includes/functions/database.php:

$slow_query=tep_db_input($query)."tt".$qlocation."tt".$parsetime."tt".$slow_when . "r";

replace with:

$slow_query=tep_db_input($query)."t".$qlocation."t".$parsetime."t".$slow_when . "rn";

on admin/mysqlperformance.php:

replace all DIR_WS_CATALOG

in DIR_FS_CATALOG

EXPLAIN:
=======
1. Well, we can write text one per line in a file by using carriage return, 'n' or 'r'.
If you are using PC, use "n". For Macintosh, use "r". But just to be on the safe side, you can use both together like this "rn" regardless of what system you're running your code on. This will guarantee it works under both PCs and Macintosh.

2. t must be only one because in admin/mysqlperformance.php you have $Data[$performance_numrows] = explode("t", $Value);

and





END EXPLAIN========

file contains only correction.

More... (http://addons.oscommerce.com/info/4689)