コード例 #1
0
ファイル: monitor.php プロジェクト: engine9-/newznab-tmux
     }
 }
 $runVar['timers']['query']['split_time'] = time() - $timer02;
 $runVar['timers']['query']['split1_time'] = time() - $timer01;
 $timer03 = time();
 //This is subpartition compatible -- loops through all partitions and adds their total row counts instead of doing a slow query count
 $partitions = $pdo->queryDirect(sprintf("\n\t\t\t\tSELECT SUM(TABLE_ROWS) AS count, PARTITION_NAME AS category\n\t\t\t\tFROM INFORMATION_SCHEMA.PARTITIONS\n\t\t\t\tWHERE TABLE_NAME = 'releases'\n\t\t\t\tAND TABLE_SCHEMA = %s\n\t\t\t\tGROUP BY PARTITION_NAME", $pdo->escapeString($db_name)));
 foreach ($partitions as $partition) {
     $runVar['counts']['now'][$partition['category']] = $partition['count'];
 }
 unset($partitions);
 $runVar['timers']['query']['init_time'] = time() - $timer03;
 $runVar['timers']['query']['init1_time'] = time() - $timer01;
 $timer04 = time();
 $proc1qry = $tRun->proc_query(1, $runVar['settings']['book_reqids'], $runVar['settings']['request_hours'], $db_name);
 $proc1res = $pdo->queryOneRow($proc1qry !== false ? $proc1qry : '', $tRun->rand_bool($runVar['counts']['iterations']));
 $runVar['timers']['query']['proc1_time'] = time() - $timer04;
 $runVar['timers']['query']['proc11_time'] = time() - $timer01;
 $timer05 = time();
 $proc2qry = $tRun->proc_query(2, $runVar['settings']['book_reqids'], $runVar['settings']['request_hours'], $db_name);
 $proc2res = $pdo->queryOneRow($proc2qry !== false ? $proc2qry : '', $tRun->rand_bool($runVar['counts']['iterations']));
 $runVar['timers']['query']['proc2_time'] = time() - $timer05;
 $runVar['timers']['query']['proc21_time'] = time() - $timer01;
 $timer06 = time();
 $proc3qry = $tRun->proc_query(3, $runVar['settings']['book_reqids'], $runVar['settings']['request_hours'], $db_name);
 $proc3res = $pdo->queryOneRow($proc3qry !== false ? $proc3qry : '', $tRun->rand_bool($runVar['counts']['iterations']));
 $runVar['timers']['query']['proc3_time'] = time() - $timer06;
 $runVar['timers']['query']['proc31_time'] = time() - $timer01;
 $timer07 = time();
 if ($runVar['constants']['tablepergroup'] == 1) {
     $sql = 'SHOW TABLE STATUS';
コード例 #2
0
ファイル: monitor.php プロジェクト: Jay204/nZEDb
     }
 }
 $runVar['timers']['query']['split_time'] = time() - $timer02;
 $runVar['timers']['query']['split1_time'] = time() - $timer01;
 $timer03 = time();
 //This is subpartition compatible -- loops through all partitions and adds their total row counts instead of doing a slow query count
 $partitions = $pdo->queryDirect(sprintf("\n\t\t\t\tSELECT SUM(TABLE_ROWS) AS count, PARTITION_NAME AS category\n\t\t\t\tFROM INFORMATION_SCHEMA.PARTITIONS\n\t\t\t\tWHERE TABLE_NAME = 'releases'\n\t\t\t\tAND TABLE_SCHEMA = %s\n\t\t\t\tGROUP BY PARTITION_NAME", $pdo->escapeString($db_name)));
 foreach ($partitions as $partition) {
     $runVar['counts']['now'][$partition['category']] = $partition['count'];
 }
 unset($partitions);
 $runVar['timers']['query']['init_time'] = time() - $timer03;
 $runVar['timers']['query']['init1_time'] = time() - $timer01;
 $timer04 = time();
 $proc1qry = $tRun->proc_query(1, $runVar['settings']['book_reqids'], $runVar['settings']['request_hours'], $db_name);
 $proc1res = $pdo->queryOneRow($proc1qry !== false ? $proc1qry : '', $tRun->rand_bool($runVar['counts']['iterations']));
 $runVar['timers']['query']['proc1_time'] = time() - $timer04;
 $runVar['timers']['query']['proc11_time'] = time() - $timer01;
 $timer05 = time();
 $proc2qry = $tRun->proc_query(2, $runVar['settings']['book_reqids'], $runVar['settings']['request_hours'], $db_name);
 $proc2res = $pdo->queryOneRow($proc2qry !== false ? $proc2qry : '', $tRun->rand_bool($runVar['counts']['iterations']));
 $runVar['timers']['query']['proc2_time'] = time() - $timer05;
 $runVar['timers']['query']['proc21_time'] = time() - $timer01;
 $timer06 = time();
 $proc3qry = $tRun->proc_query(3, $runVar['settings']['book_reqids'], $runVar['settings']['request_hours'], $db_name);
 $proc3res = $pdo->queryOneRow($proc3qry !== false ? $proc3qry : '', $tRun->rand_bool($runVar['counts']['iterations']));
 $runVar['timers']['query']['proc3_time'] = time() - $timer06;
 $runVar['timers']['query']['proc31_time'] = time() - $timer01;
 $timer07 = time();
 if ($runVar['constants']['tablepergroup'] == 1) {
     $sql = 'SHOW TABLE STATUS';