

Fonctions membres publiques | |
| perf_mysql (&$conn) | |
| Explain ($sql, $partial=false) | |
| Tables () | |
| GetReads () | |
| GetWrites () | |
| FindDBHitRatio () | |
| GetQHitRatio () | |
| GetInnoDBHitRatio () | |
| GetKeyHitRatio () | |
| optimizeTable ($table, $mode=ADODB_OPT_LOW) | |
Attributs publics | |
| $tablesSQL = 'show table status' | |
| $createTableSQL | |
| $settings | |
| $optimizeTableLow = 'CHECK TABLE %s FAST QUICK' | |
| $optimizeTableHigh = 'OPTIMIZE TABLE %s' | |
| perf_mysql::perf_mysql | ( | &$ | conn | ) |
| perf_mysql::Explain | ( | $ | sql, | |
| $ | partial = false | |||
| ) |
Réimplémentée à partir de adodb_perf.
| perf_mysql::Tables | ( | ) |
| perf_mysql::GetReads | ( | ) |
| perf_mysql::GetWrites | ( | ) |
| perf_mysql::FindDBHitRatio | ( | ) |
| perf_mysql::GetQHitRatio | ( | ) |
| perf_mysql::GetInnoDBHitRatio | ( | ) |
| perf_mysql::GetKeyHitRatio | ( | ) |
| perf_mysql::optimizeTable | ( | $ | table, | |
| $ | mode = ADODB_OPT_LOW | |||
| ) |
| perf_mysql::$tablesSQL = 'show table status' |
Réimplémentée à partir de adodb_perf.
| perf_mysql::$createTableSQL |
Valeur initiale :
"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 )"
Réimplémentée à partir de adodb_perf.
| perf_mysql::$settings |
| perf_mysql::$optimizeTableLow = 'CHECK TABLE %s FAST QUICK' |
| perf_mysql::$optimizeTableHigh = 'OPTIMIZE TABLE %s' |
1.5.3