100
103
$flags |= REQUEST::NEED_READERINFO;
102
105
$cache = new CACHEDB();
103
$list = $cache->GetCacheList($flags);
106
if (($_GET['filter'])&&($flags&CACHE::FIND_BROKEN)) {
108
$cache->GetCacheList(false, CACHE::FIND_BROKEN),
109
$cache->GetCacheList($_GET['filter'], $flags)
112
$list = $cache->GetCacheList(false, $flags);
104
113
usort($list, create_function('$a,$b', 'return strcasecmp(
105
114
$a["db_server"] . "__" . $a["db_name"] . "__" . $a["db_group"],
106
115
$b["db_server"] . "__" . $b["db_name"] . "__" . $b["db_group"]
217
239
} while ((is_numeric($grp0))&&(!$list[$grp0]['req']));
219
241
?><div class="source" <?= ($filter_server == $server)?"style=\"border: 2px solid pink;\"":""?>>
220
<h3> Server: <a href="index.php?page=cacheinfo.php&source_info&group_info&table_info&filter=<?=$server?>"><?=$server?></a><?
242
<h3> Server: <a href="index.php?page=cacheinfo.php&<?=$info_props?>&filter=<?=$server?>"><?=$server?></a><?
243
if ((!$extended_mode)||($show_mark)) echo " (";
244
if (!$extended_mode) {
245
?><a href="index.php?page=cacheinfo.php&<?=$all_info_props?>&filter=<?=$server?>">Extended Info</a><?
246
if ($show_mark) echo ", " ;
221
248
if ($show_mark) {
222
?>(<a href="javascript:Mark('<?=implode(",", $srv["tables"])?>', 1)">Mark</a>,<a href="javascript:Mark('<?=implode(",", $srv["tables"])?>', 0)">Unmark</a>)<?
224
if ($server != "_unknown_") {
225
if (is_numeric($grp0)) echo translate("Server: %s (%s)", $list[$grp0]['server'], $list[$grp0]['reader']);
226
else echo translate("Server: In-active");
249
?><a href="javascript:Mark('<?=implode(",", $srv["tables"])?>', 1)">Mark</a>, <a href="javascript:Mark('<?=implode(",", $srv["tables"])?>', 0)">Unmark</a><?
251
if ((!$extended_mode)||($show_mark)) echo ")";?></h3><?
253
if (($filter_server === false)||(($filter_server == $server)&&($filter_source === false))) {
254
if ($server != "_unknown_") {
255
if (is_numeric($grp0)) echo translate("Server: %s (%s)", $list[$grp0]['server'], $list[$grp0]['reader']);
256
else echo translate("Server: In-active");
260
if (($filter_server === false)||(($filter_server == $server)&&($filter_source === false))) {
261
echo translate("First record: %s", date("r", $srv['first'])) . "<br/>";
262
echo translate("Last record: %s", date("r", $srv['last'])) . "<br/>";
263
echo translate("Database Size: %s", dsPrintSize($srv['dbsize']));
229
echo translate("First record: %s", date("r", $srv['first'])) . "<br/>";
230
echo translate("Last record: %s", date("r", $srv['last'])) . "<br/>";
231
echo translate("Database Size: %s", dsPrintSize($srv['dbsize']));
233
266
if ($srv['databases']) echo "<br/><br/>Databases:<br/>";
234
267
else echo ", " . translate("%u groups", sizeof($srv['tables'])) . "<br/>";
235
269
foreach ($srv['databases'] as $source) {
236
270
$db = &$sources[$source];
237
echo "<a href=\"index.php?page=cacheinfo.php&source_info&group_info&table_info&filter=$source\"" . (($filter_source == $source)?"style=\"color:red\";":"") . ">" . substr(strstr($source, "__"),2) . "</a>: ";
238
echo translate("%u groups", sizeof($db['groups'])) . ", ";
239
echo dsPrintSize($db['dbsize']) . ", ";
240
echo date("r", $db['first']) . " - " . date("r", $db['last']);
241
if (($show_mark)&&(($filter_source === false)||($filter_source == $source))) {
242
?>(<a href="javascript:Mark('<?=implode(",", $db["tables"])?>', 1)">Mark</a>,<a href="javascript:Mark('<?=implode(",", $db["tables"])?>', 0)">Unmark</a>)<?
271
echo "<a href=\"index.php?page=cacheinfo.php&$info_props&filter=$source\"" . (($filter_source == $source)?"style=\"color:red\";":"") . ">" . substr(strstr($source, "__"),2) . "</a>: ";
272
echo translate("%u groups", sizeof($db['groups']));
273
if (($filter_source === false)||($filter_source == $source)) {
274
echo ", " . dsPrintSize($db['dbsize']) . ", ";
275
echo date("r", $db['first']) . " - " . date("r", $db['last']);
277
$show_mark_here = (($show_mark)&&(($filter_source === false)||($filter_source == $source)));
278
if ((!$extended_mode)||($show_mark)) echo " (";
279
if (!$extended_mode) {
280
echo "<a href=\"index.php?page=cacheinfo.php&$all_info_props&filter=$source\">Extended Info</a>";
281
if ($show_mark_here) echo ", ";
283
if ($show_mark_here) {
284
?><a href="javascript:Mark('<?=implode(",", $db["tables"])?>', 1)">Mark</a>, <a href="javascript:Mark('<?=implode(",", $db["tables"])?>', 0)">Unmark</a><?
286
if ((!$extended_mode)||($show_mark)) echo ")";
361
if (isset($info['get_extended_cache_info_time'])) {
362
echo translate("Cache Query Time: %s s", $info['get_extended_cache_info_time']);
363
if ($info['get_extended_cache_info_time'] > 1) echo " [SLOW]";
366
if (isset($info['query_time'])) {
367
echo translate("Source Query Time: %s s", $info['query_time']);
368
if ($info['query_time'] > 1) echo " [SLOW]";
310
372
if (isset($info['info']['dbsize'])) {
311
373
echo translate("Cache Size: %s", dsPrintSize($info['info']['dbsize'])) . "<br/>";
314
376
if (isset($info['info']['records'])||isset($info['records'])) {
315
377
if (!isset($info['records']))
316
echo translate("Number of records: %s (CACHE)", $info['info']['records']);
378
echo translate("Number of records: %s (CACHE-only)", $info['info']['records']);
317
379
else if (!isset($info['info']['records']))
318
echo translate("Number of records: %s (READER)", $info['records']);
380
echo translate("Number of records: %s (READER-only)", $info['records']);
319
381
else if (abs($info['records'] - $info['info']['records']) < 100)
320
382
echo translate("Number of records: %s (IN SYNC)", $info['info']['records']);
322
echo translate("Number of records: %s (CACHE) %s (READER)", $info['info']['records'], $info['records']);
384
echo translate("Number of records: %s (CACHE) %s (READER) --- Wild guess with MySQL/ADEIDB", $info['info']['records'], $info['records']);
352
414
if ((isset($info['info']['first'])&&isset($info['info']['last']))||(isset($info['first'])&&isset($info['last']))) {
353
if ($info['first'] == $info['info']['first'])
354
echo translate("First record (ALL) : %s", date("r", $info['info']['first'])) . "<br/>";
355
else if (!isset($info['first']))
356
echo translate("First record (CACHE) : %s", date("r", $info['info']['first'])) . "<br/>";
357
else if (!isset($info['info']['first']))
358
echo translate("First record (READER): %s", date("r", $info['first'])) . "<br/>";
415
if (ceil($info['first']) == ceil($info['info']['first']))
416
echo translate("First record (ALL) : %s", print_date($info['info']['first'])) . "<br/>";
417
else if (!isset($info['first'])) {
418
if (isset($_GET['reader_info']))
419
echo translate("First record (CACHE-only) : %s", print_date($info['info']['first'])) . "<br/>";
421
echo translate("First record (CACHE) : %s", print_date($info['info']['first'])) . "<br/>";
422
} else if (!isset($info['info']['first']))
423
echo translate("First record (READER-only): %s", print_date($info['first'])) . "<br/>";
360
echo translate("First record (CACHE) : %s", date("r", $info['info']['first'])) . "<br/>";
361
echo translate("First record (READER): %s", date("r", $info['first'])) . "<br/>";
425
echo translate("First record (CACHE) : %s", print_date($info['info']['first'])) . "<br/>";
426
echo translate("First record (READER): %s", print_date($info['first'])) . "<br/>";
364
if ($info['last'] == $info['info']['last'])
365
echo translate("Last record (ALL) : %s", date("r", $info['info']['last'])) . "<br/>";
366
else if (!isset($info['last']))
367
echo translate("Last record (CACHE) : %s", date("r", $info['info']['last'])) . "<br/>";
368
else if (!isset($info['info']['last']))
369
echo translate("Last record (READER): %s", date("r", $info['last'])) . "<br/>";
429
if (floor($info['last']) == floor($info['info']['last']))
430
echo translate("Last record (ALL) : %s", print_date($info['info']['last'])) . "<br/>";
431
else if (!isset($info['last'])) {
432
if (isset($_GET['reader_info']))
433
echo translate("Last record (CACHE-only) : %s", print_date($info['info']['last'])) . "<br/>";
435
echo translate("Last record (CACHE) : %s", print_date($info['info']['last'])) . "<br/>";
436
} else if (!isset($info['info']['last']))
437
echo translate("Last record (READER-only): %s", print_date($info['last'])) . "<br/>";
371
echo translate("Last record (CACHE) : %s", date("r", $info['info']['last'])) . "<br/>";
372
echo translate("Last record (READER): %s", date("r", $info['last'])) . "<br/>";
439
echo translate("Last record (CACHE) : %s", print_date($info['info']['last'])) . "<br/>";
440
echo translate("Last record (READER): %s", print_date($info['last'])) . "<br/>";