Thu, September 23, 2021
 
https://devcodepro.comdevcodepro
X
Home · Latest · Trends
4

ADOdb Performance Monitor

This module provides HTML and CLI interfaces for viewing key performance indicators of your database.
//MySQL

CREATE TABLE adodb_logsql (
created datetime NOT NULL,
sql0 varchar(250) NOT NULL,
sql1 text NOT NULL,
params text NOT NULL,
tracer text NOT NULL,
timer decimal(16,6) NOT NULL
);

//PHP

include ('classes/adodb/db.php');
include ('classes/adodb/adodb.inc.php');
$adoDriver = "mysqli";
$DB = ADONewConnection($adoDriver);
@$DB->Connect($server,$user,$password,$database);
$perf = NewPerfMonitor($DB);
$perf->UI($pollsecs=3);
rated 4 times (4) (0)
comments: 0 / hits: 2425  / 5 years ago, tue, sep 6, 16, 10:18:23
More From » PHP
 

Comments

There are no comments for this Snippet yet
Only authorized users can post. Please sign in first, or register a free account
 
Share
Posted
Ronald
Member since Sep 6, 2016
Total Code Snippets: 25
Total Comments: 2
Location: New Britain, Connecticut
Ronald snippets
5 years ago, tue, sep 6, 16, 10:11:38
comments: 0 / hits: 2571
PHP
5 years ago, tue, sep 6, 16, 10:42:24
comments: 0 / hits: 2791
PHP
5 years ago, fri, sep 16, 16, 1:10:12
comments: 0 / hits: 3230
PHP
5 years ago, fri, sep 16, 16, 1:12:32
comments: 0 / hits: 2144
CSS
5 years ago, fri, sep 16, 16, 1:27:33
comments: 0 / hits: 3233
PHP
5 years ago, sun, sep 25, 16, 2:52:42
comments: 1 / hits: 2560
5 years ago, thu, nov 10, 16, 4:21:59
comments: 1 / hits: 2707
PHP
5 years ago, mon, nov 21, 16, 10:48:23
comments: 2 / hits: 9438
PHP
5 years ago, sun, dec 25, 16, 2:44:24
comments: 0 / hits: 5214