} } $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';