database (mysql) monitoring + query logs (prof ...

Вторник, 13 Март. 2007

database (mysql) monitoring + query logs (profiling)

Ole, moi le grand, j'ai trouvé :=)

Database performance monitoring and SQL tuning with the performance monitoring classes.

http://phplens.com/lens/adodb/docs-perf.htm

Sample :

fail kotorii sozdaeot zapros dlia loga :
====
session_start();
#ado_sql.php

require("database_config.php");
include("../../sys/adodb/adodb.inc.php");
include("../../sys/adodb/adodb-pager.inc.php");

$db = ADONewConnection($GLOBALS["database_server_driver"]);
$db->Connect($GLOBALS["database_server"],$GLOBALS["database_user"],$GLOBALS["database_password"],$GLOBALS["database_dbname"]);
$db->LogSQL(true);
$db->debug=false;
$sql="Select * from table_name where id='1'";
print $sql."
";
$rs =& $db->Execute($sql);
while (!$rs->EOF) {
/** select fields **/
$rs->MoveNext();
}

?>


fail "monitor"

session_start();
include_once('../../sys/adodb/adodb.inc.php');
require("database_config.php");
# session variables required for monitoring
$conn = ADONewConnection($GLOBALS["database_server_driver"]);
$conn->Connect($GLOBALS["database_server"],$GLOBALS["database_user"],$GLOBALS["database_password"],$GLOBALS["database_dbname"]);
$perf =& NewPerfMonitor($conn);
$perf->UI($pollsecs=5);
?>