From f5803dd6e4bac15a6dd5cefcc33e0ecfdda8d870 Mon Sep 17 00:00:00 2001 From: Eric Bollengier Date: Fri, 22 Jan 2010 10:34:36 +0100 Subject: [PATCH] Bweb: Display database size by default (assume mysql >= 5) --- gui/bweb/lib/Bweb.pm | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/gui/bweb/lib/Bweb.pm b/gui/bweb/lib/Bweb.pm index 7c3f5dde2d..645c10118d 100644 --- a/gui/bweb/lib/Bweb.pm +++ b/gui/bweb/lib/Bweb.pm @@ -1331,9 +1331,9 @@ our %sql_func = ( STARTTIME_PMONTH => " DATE_FORMAT(Job.StartTime, '%m') ", STARTTIME_PWEEK => " DATE_FORMAT(Job.StartTime, '%v') ", # with mysql < 5, you have to play with the ugly SHOW command - DB_SIZE => " SELECT 0 ", + #DB_SIZE => " SELECT 0 ", # works only with mysql 5 - # DB_SIZE => " SELECT sum(DATA_LENGTH) FROM INFORMATION_SCHEMA.TABLES ", + DB_SIZE => " SELECT sum(DATA_LENGTH) FROM INFORMATION_SCHEMA.TABLES ", CAT_POOL_TYPE => " CONCAT(MediaType,'_',Pool.Name) ", CONCAT_SEP => " SEPARATOR '' ", }, -- 2.39.2