benchmark test on gratia_itb prototype database hosted on flxd01
query performance with tables still in MyIsam engine:
select JobUsageRecord_Report.VOName, sum(JobUsageRecord_Report.WallDuration)
as WallDuration,
sum(JobUsageRecord_Report.CpuUserDuration +
JobUsageRecord_Report.CpuSystemDuration) as Cpu,
sum(JobUsageRecord_Report.Njobs) as Njobs from JobUsageRecord_Report where
EndTime >= date('2007-08-11 00:00:00 GMT') and EndTime <= date('2007-08-28
00:00:00 GMT')
and ResourceType = 'Batch' group by JobUsageRecord_Report.VOName order by
JobUsageRecord_Report.VOName
35.58 seconds
select JobUsageRecord_Report.VOName, sum(JobUsageRecord_Report.WallDuration)
as WallDuration,
sum(JobUsageRecord_Report.CpuUserDuration +
JobUsageRecord_Report.CpuSystemDuration) as Cpu,
sum(JobUsageRecord_Report.Njobs) as Njobs from JobUsageRecord_Report where
EndTime >= date('2007-07-11 00:00:00 GMT') and EndTime <= date('2007-08-28
00:00:00 GMT')
and ResourceType = 'Batch' group by JobUsageRecord_Report.VOName order by
JobUsageRecord_Report.VOName;
1658 seconds
test the conversion from MyISAM to InnoDB on a few tables:
alter table DupRecord engine=innodb 6min
data file increased from 486M to 537M; index size decreased from 6M to 4.5M
alter table JobUsageRecord_Meta =innodb 15min
data file increased from 292M to 424M ; index size increased from 189M to 346M
========================================================
-rw-rw---- 1 diana dbi 8830 Aug 29 09:07 CEProbeStatus.frm
mysql> alter table CEProbeStatus engine = innodb;
Query OK, 37 rows
affected (1.58 sec)
Records: 37 Duplicates: 0 Warnings: 0
-rw-rw---- 1 diana dbi 8830 Oct 9 10:55 CEProbeStatus.frm
-rw-rw---- 1 diana dbi 98304 Oct 9 10:55 CEProbeStatus.ibd
========================================================
-rw-rw---- 1 diana dbi
8844 Aug 28 15:51 CPUInfo.frm
-rw-rw---- 1 diana dbi 98304 Aug 28 15:51 CPUInfo.ibd
mysql> alter
table CPUInfo engine=innodb ;
Query OK, 5 rows affected (0.40 sec)
Records: 5 Duplicates: 0 Warnings: 0
-rw-rw---- 1 diana dbi
8844 Oct 9 11:03 CPUInfo.frm
-rw-rw---- 1 diana dbi 98304 Oct 9 11:03 CPUInfo.ibd
=========================================================
-rw-rw---- 1 diana dbi
8604 Aug 28 15:51 CPUMetricTypes.frm
-rw-rw---- 1 diana dbi 98304 Sep 17 16:47 CPUMetricTypes.ib
mysql> alter
table CPUMetricTypes engine=innodb ;
Query OK, 2 rows affected (0.27 sec)
Records: 2 Duplicates: 0 Warnings: 0
-rw-rw---- 1 diana dbi
8604 Oct 9 11:07 CPUMetricTypes.frm
-rw-rw---- 1 diana dbi 98304 Oct 9 11:07 CPUMetricTypes.ibd
=========================================================
-rw-rw---- 1 diana dbi
8666 Aug 29 09:07 ConsumableResource.frm
-rw-rw---- 1 diana dbi 114688 Aug 29 09:07 ConsumableResource.ibd
mysql> alter
table ConsumableResource engine=innodb;
Query OK, 0 rows affected (0.29 sec)
Records: 0 Duplicates: 0 Warnings: 0
-rw-rw---- 1 diana dbi
8666 Oct 9 11:09 ConsumableResource.frm
-rw-rw---- 1 diana dbi 114688 Oct 9 11:09 ConsumableResource.ibd
==========================================================
-rw-rw---- 1 diana dbi
8786 Aug 29 09:07 Disk.frm
-rw-rw---- 1 diana dbi 114688 Aug 29 09:07 Disk.ibd
mysql> alter
table Disk engine=innodb;
Query OK, 0 rows affected (0.29 sec)
Records: 0 Duplicates: 0 Warnings: 0
-rw-rw---- 1 diana dbi
8786 Oct 9 11:11 Disk.frm
-rw-rw---- 1 diana dbi 114688 Oct 9 11:11 Disk.ibd
=========================================================
-rw-rw---- 1 diana dbi
8890 Aug 29 09:07 HostDescriptionProbeSummary.frm
-rw-rw---- 1 diana dbi 9437184 Sep 20 17:08 HostDescriptionProbeSummary.ibd
mysql> alter
table HostDescriptionProbeSummary engine=innodb ;
Query OK, 4295 rows affected (3.05 sec)
Records: 4295 Duplicates: 0 Warnings: 0
-rw-rw---- 1 diana dbi
8890 Oct 9 11:13 HostDescriptionProbeSummary.frm
-rw-rw---- 1 diana dbi 9437184 Oct 9 11:13 HostDescriptionProbeSummary.ib
==========================================================
-rw-rw---- 1 diana dbi
19236 Aug 29 10:01 JobUsageRecord.frm
-rw-rw---- 1 diana dbi 2285895680 Sep 20 17:08 JobUsageRecord.ibd
mysql> alter
table JobUsageRecord engine=innodb ;
Query OK, 2500016 rows affected (46 min 16.86 sec)
Records: 2500016 Duplicates: 0 Warnings: 0
-rw-rw---- 1 diana dbi
19236 Oct 9 11:15 JobUsageRecord.frm
-rw-rw---- 1 diana dbi 1971322880 Oct 9 12:03 JobUsageRecord.ibd
===========================================================
-rw-rw---- 1 diana dbi
8632 Aug 29 10:39 JobUsageRecord_Xml.frm
-rw-rw---- 1 diana dbi 7570718720 Sep 20 17:08 JobUsageRecord_Xml.ibd
mysql> alter
table JobUsageRecord_Xml engine=innodb ;
Query OK, 2489177 rows affected (2 hours 3 min 38.89 sec)
Records: 2489177 Duplicates: 0 Warnings: 0
-rw-rw---- 1 diana dbi
8632 Oct 9 13:04 JobUsageRecord_Xml.frm
-rw-rw---- 1 diana dbi 6647971840 Oct 9 15:08 JobUsageRecord_Xml.ibd
===========================================================
-rw-rw---- 1 diana dbi
8786 Aug 29 09:07 Memory.frm
-rw-rw---- 1 diana dbi 37748736 Sep 20 17:06 Memory.ibd
mysql> alter
table Memory engine=innodb;
Query OK, 361549 rows affected (31.15 sec)
Records: 361549 Duplicates: 0 Warnings: 0
-rw-rw---- 1 diana dbi
8786 Oct 9 15:14 Memory.frm
-rw-rw---- 1 diana dbi 37748736 Oct 9 15:15 Memory.ibd
===========================================================
-rw-rw---- 1 diana dbi
8942 Aug 29 09:07 MetricRecord.frm
-rw-rw---- 1 diana dbi 98304 Aug 29 09:08 MetricRecord.ibd
mysql> alter
table MetricRecord engine=innodb ;
Query OK, 39 rows affected (0.38 sec)
Records: 39 Duplicates: 0 Warnings:
-rw-rw---- 1 diana dbi
8942 Oct 9 15:17 MetricRecord.frm
-rw-rw---- 1 diana dbi 98304 Oct 9 15:17 MetricRecord.ibd
===========================================================
-rw-rw---- 1 diana dbi
9040 Sep 4 18:48 MetricRecord_Meta.frm
-rw-rw---- 1 diana dbi 131072 Sep 4 19:14 MetricRecord_Meta.ib
mysql> alter
table MetricRecord_Meta engine=innodb;
Query OK, 39 rows affected (0.44 sec)
Records: 39 Duplicates: 0 Warnings: 0
-rw-rw---- 1 diana dbi
9040 Oct 9 15:20 MetricRecord_Meta.frm
-rw-rw---- 1 diana dbi 131072 Oct 9 15:20 MetricRecord_Meta.ibd
===========================================================
-rw-rw---- 1 diana dbi
8632 Aug 29 09:07 MetricRecord_Xml.frm
-rw-rw---- 1 diana dbi 147456 Aug 29 09:08 MetricRecord_Xml.ibd
mysql> alter
table MetricRecord_Xml engine=innodb;
Query OK, 39 rows affected (0.17 sec)
Records: 39 Duplicates: 0 Warnings: 0
-rw-rw---- 1 diana dbi
8632 Oct 9 15:21 MetricRecord_Xml.frm
-rw-rw---- 1 diana dbi 147456 Oct 9 15:21 MetricRecord_Xml.ibd
===========================================================
-rw-rw---- 1 diana dbi
8756 Aug 29 09:35 Network.frm
-rw-rw---- 1 diana dbi 100663296 Sep 17 20:45 Network.ibd
mysql> alter
table Network engine=innodb;
Query OK, 1053293 rows affected (1 min 37.56 sec)
Records: 1053293 Duplicates: 0 Warnings:
-rw-rw---- 1 diana dbi
8756 Oct 9 15:23 Network.frm
-rw-rw---- 1 diana dbi 100663296 Oct 9 15:25 Network.ibd
===========================================================
-rw-rw---- 1 diana dbi
8706 Aug 29 09:07 PhaseResource.frm
-rw-rw---- 1 diana dbi 114688 Aug 29 09:08 PhaseResource.ibd
mysql> alter
table PhaseResource engine=innodb;
Query OK, 0 rows affected (0.31 sec)
Records: 0 Duplicates: 0 Warnings: 0
-rw-rw---- 1 diana dbi
8706 Oct 9 15:29 PhaseResource.frm
-rw-rw---- 1 diana dbi 114688 Oct 9 15:29 PhaseResource.ibd
===========================================================
-rw-rw---- 1 diana dbi
9022 Sep 4 18:48 Probe.frm
-rw-rw---- 1 diana dbi 131072 Sep 20 17:08 Probe.ibd
mysql> alter
table Probe engine=innodb;
Query OK, 85 rows affected (0.58 sec)
Records: 85 Duplicates: 0 Warnings: 0
-rw-rw---- 1 diana dbi
9022 Oct 9 15:32 Probe.frm
-rw-rw---- 1 diana dbi 131072 Oct 9 15:32 Probe.ibd
===========================================================
-rw-rw---- 1 diana dbi
8560 Sep 4 18:28 ProbeDetails.frm
-rw-rw---- 1 diana dbi 98304 Sep 4 18:29 ProbeDetails.ibd
mysql> alter
table ProbeDetails engine=innodb;
Query OK, 0 rows affected (0.30 sec)
Records: 0 Duplicates: 0 Warnings: 0
-rw-rw---- 1 diana dbi
8560 Oct 9 15:34 ProbeDetails.frm
-rw-rw---- 1 diana dbi 98304 Oct 9 15:34 ProbeDetails.ibd
===========================================================
-rw-rw---- 1 diana dbi
9040 Sep 4 18:48 ProbeDetails_Meta.frm
-rw-rw---- 1 diana dbi 131072 Sep 4 18:50 ProbeDetails_Meta.ibd
mysql> alter
table ProbeDetails_Meta engine=innodb;
Query OK, 0 rows affected (0.41 sec)
Records: 0 Duplicates: 0 Warnings: 0
-rw-rw---- 1 diana dbi
9040 Oct 9 15:35 ProbeDetails_Meta.frm
-rw-rw---- 1 diana dbi 131072 Oct 9 15:35 ProbeDetails_Meta.ibd
===========================================================
-rw-rw---- 1 diana dbi
8632 Sep 4 18:48 ProbeDetails_Xml.frm
-rw-rw---- 1 diana dbi 114688 Sep 4 18:50 ProbeDetails_Xml.ibd
mysql> alter
table ProbeDetails_Xml engine=innodb;
Query OK, 0 rows affected (0.38 sec)
Records: 0 Duplicates: 0 Warnings: 0
-rw-rw---- 1 diana dbi
8632 Oct 9 15:38 ProbeDetails_Xml.frm
-rw-rw---- 1 diana dbi 114688 Oct 9 15:38 ProbeDetails_Xml.ibd
===========================================================
-rw-rw---- 1 diana dbi
8594 Sep 4 18:48 ProbeSoftware.frm
-rw-rw---- 1 diana dbi 131072 Sep 4 18:50 ProbeSoftware.ibd
mysql> alter
table ProbeSoftware engine=innodb;
Query OK, 0 rows affected (0.45 sec)
Records: 0 Duplicates: 0 Warnings: 0
-rw-rw---- 1 diana dbi
8594 Oct 9 15:40 ProbeSoftware.frm
-rw-rw---- 1 diana dbi 131072 Oct 9 15:40 ProbeSoftware.ibd
===========================================================
-rw-rw---- 1 diana dbi
8638 Aug 29 09:07 ProbeStatus.frm
-rw-rw---- 1 diana dbi 17825792 Sep 20 17:08 ProbeStatus.ibd
mysql> alter
table ProbeStatus engine=innodb;
Query OK, 53187 rows affected (8.91 sec)
Records: 53187 Duplicates: 0 Warnings: 0
-rw-rw---- 1 diana dbi
8638 Oct 9 15:41 ProbeStatus.frm
-rw-rw---- 1 diana dbi 17825792 Oct 9 15:41 ProbeStatus.ibd
===========================================================
-rw-rw---- 1 diana dbi
8838 Aug 29 09:07 ProbeSummary.frm
-rw-rw---- 1 diana dbi 9437184 Sep 20 17:08 ProbeSummary.ibd
mysql> alter
table ProbeSummary engine=innodb;
Query OK, 4265 rows affected (2.28 sec)
Records: 4265 Duplicates: 0 Warnings: 0
-rw-rw---- 1 diana dbi
8838 Oct 9 15:43 ProbeSummary.frm
-rw-rw---- 1 diana dbi 9437184 Oct 9 15:43 ProbeSummary.ibd
===========================================================
-rw-rw---- 1 diana dbi
8990 Aug 29 09:07 Replication.frm
-rw-rw---- 1 diana dbi 98304 Aug 29 09:08 Replication.ibd
mysql> alter
table Replication engine=innodb;
Query OK, 3 rows affected (0.20 sec)
Records: 3 Duplicates: 0 Warnings: 0
-rw-rw---- 1 diana dbi
8990 Oct 9 15:45 Replication.frm
-rw-rw---- 1 diana dbi 98304 Oct 9 15:45 Replication.ibd
============================================================
-rw-rw---- 1 diana dbi
8636 Aug 29 09:48 Resource.frm
-rw-rw---- 1 diana dbi 759169024 Sep 20 17:08 Resource.ibd
mysql> alter
table Resource engine=innodb;
Query OK, 9943897 rows affected (18 min 56.49 sec)
Records: 9943897 Duplicates: 0 Warnings: 0
-rw-rw---- 1 diana dbi
8636 Oct 9 15:46 Resource.frm
-rw-rw---- 1 diana dbi 759169024 Oct 9 16:05 Resource.ibd
============================================================
-rw-rw---- 1 diana dbi
8676 Aug 29 09:07 Role.frm
-rw-rw---- 1 diana dbi 98304 Aug 29 09:08 Role.ibd
mysql> alter
table Role engine=innodb;
Query OK, 2 rows affected (0.50 sec)
Records: 2 Duplicates: 0 Warnings: 0
-rw-rw---- 1 diana dbi
8676 Oct 9 16:08 Role.frm
-rw-rw---- 1 diana dbi 98304 Oct 9 16:08 Role.ibd
============================================================
-rw-rw---- 1 diana dbi
8706 Aug 29 09:07 Security.frm
-rw-rw---- 1 diana dbi 114688 Aug 29 09:08 Security.ibd
mysql> alter
table Security engine=innodb;
Query OK, 0 rows affected (0.22 sec)
Records: 0 Duplicates: 0 Warnings: 0
-rw-rw---- 1 diana dbi
8706 Oct 9 16:10 Security.frm
-rw-rw---- 1 diana dbi 114688 Oct 9 16:10 Security.ibd
============================================================
-rw-rw---- 1 diana dbi
8666 Aug 29 09:07 ServiceLevel.frm
-rw-rw---- 1 diana dbi 606208 Sep 17 20:45 ServiceLevel.ibd
mysql> alter
table ServiceLevel engine=innodb;
Query OK, 6927 rows affected (0.86 sec)
Records: 6927 Duplicates: 0 Warnings: 0
-rw-rw---- 1 diana dbi
8666 Oct 9 16:11 ServiceLevel.frm
-rw-rw---- 1 diana dbi 606208 Oct 9 16:11 ServiceLevel.ibd
============================================================
-rw-rw---- 1 diana dbi
8602 Aug 29 09:07 Site.frm
-rw-rw---- 1 diana dbi 114688 Sep 17 20:45 Site.ibd
mysql> alter
table Site engine=innodb;
Query OK, 70 rows affected (0.17 sec)
Records: 70 Duplicates: 0 Warnings: 0
-rw-rw---- 1 diana dbi
8602 Oct 9 16:13 Site.frm
-rw-rw---- 1 diana dbi 114688 Oct 9 16:13 Site.ibd
============================================================
-rw-rw---- 1 diana dbi
8684 Sep 4 18:28 Software.frm
-rw-rw---- 1 diana dbi 98304 Sep 4 18:29 Software.ibd
mysql> alter
table Software engine=innodb;
Query OK, 0 rows affected (0.25 sec)
Records: 0 Duplicates: 0 Warnings: 0
-rw-rw---- 1 diana dbi
8684 Oct 9 16:14 Software.frm
-rw-rw---- 1 diana dbi 98304 Oct 9 16:14 Software.ibd
============================================================
-rw-rw---- 1 diana dbi
8786 Aug 29 09:07 Swap.frm
-rw-rw---- 1 diana dbi 37748736 Sep 20 17:06 Swap.ibd
mysql> alter
table Swap engine=innodb;
Query OK, 353682 rows affected (41.02 sec)
Records: 353682 Duplicates: 0 Warnings: 0
-rw-rw---- 1 diana dbi
8786 Oct 9 16:16 Swap.frm
-rw-rw---- 1 diana dbi 37748736 Oct 9 16:17 Swap.ibd
============================================================
-rw-rw---- 1 diana dbi
8620 Aug 29 09:08 SystemProplist.frm
-rw-rw---- 1 diana dbi 98304 Sep 17 11:40 SystemProplist.ibd
mysql> alter
table SystemProplist engine=innodb;
Query OK, 9 rows affected (0.10 sec)
Records: 9 Duplicates: 0 Warnings: 0
-rw-rw---- 1 diana dbi
8620 Oct 9 16:18 SystemProplist.frm
-rw-rw---- 1 diana dbi 98304 Oct 9 16:18 SystemProplist.ibd
=============================================================
-rw-rw---- 1 diana dbi
8610 Sep 17 11:34 TableStatistics.frm
-rw-rw---- 1 diana dbi 98304 Sep 20 17:08 TableStatistics.ibd
mysql> alter
table TableStatistics engine=innodb;
Query OK, 4 rows affected (0.27 sec)
Records: 4 Duplicates: 0 Warnings: 0
-rw-rw---- 1 diana dbi
8610 Oct 9 16:20 TableStatistics.frm
-rw-rw---- 1 diana dbi 98304 Oct 9 16:20 TableStatistics.ibd
=============================================================
-rw-rw---- 1 diana dbi
8666 Aug 29 09:37 TimeDuration.frm
-rw-rw---- 1 diana dbi 704643072 Sep 20 17:08 TimeDuration.ibd
mysql> alter
table TimeDuration engine=innodb;
Query OK, 9442043 rows affected (17 min 10.60 sec)
Records: 9442043 Duplicates: 0 Warnings: 0
-rw-rw---- 1 diana dbi
8666 Oct 9 16:21 TimeDuration.frm
-rw-rw---- 1 diana dbi 704643072 Oct 9 16:39 TimeDuration.ibd
=============================================================
-rw-rw---- 1 diana dbi
8666 Aug 29 09:08 TimeInstant.frm
-rw-rw---- 1 diana dbi 41943040 Sep 20 17:06 TimeInstant.ibd
mysql> alter
table TimeInstant engine=innodb;
Query OK, 372824 rows affected (28.52 sec)
Records: 372824 Duplicates: 0 Warnings: 0
-rw-rw---- 1 diana dbi
8666 Oct 10 09:25 TimeInstant.frm
-rw-rw---- 1 diana dbi 41943040 Oct 10 09:26 TimeInstant.ibd
=============================================================
-rw-rw---- 1 diana dbi
8880 Aug 29 09:08 UserProbeSummary.frm
-rw-rw---- 1 diana dbi 14680064 Sep 20 17:08 UserProbeSummary.ibd
mysql> alter table UserProbeSummary engine=innodb;
Query OK, 13757 rows affected (5.99 sec)
Records: 13757 Duplicates: 0 Warnings: 0
-rw-rw---- 1 diana dbi
8880 Oct 10 09:40 UserProbeSummary.frm
-rw-rw---- 1 diana dbi 14680064 Oct 10 09:40 UserProbeSummary.ibd
=============================================================
-rw-rw---- 1 diana dbi
8594 Aug 29 09:08 VO.frm
-rw-rw---- 1 diana dbi 114688 Aug 29 09:08 VO.ibd
mysql> alter
table VO engine=innodb;
Query OK, 56 rows affected (0.23 sec)
Records: 56 Duplicates: 0 Warnings: 0
-rw-rw---- 1 diana dbi
8594 Oct 10 09:41 VO.frm
-rw-rw---- 1 diana dbi 114688 Oct 10 09:42 VO.ibd
=============================================================
-rw-rw---- 1 diana dbi
8682 Aug 29 09:08 VONameCorrection.frm
-rw-rw---- 1 diana dbi 114688 Sep 18 20:38 VONameCorrection.ibd
mysql> alter
table VONameCorrection engine=innodb;
Query OK, 104 rows affected (0.17 sec)
Records: 104 Duplicates: 0 Warnings: 0
-rw-rw---- 1 diana dbi
8682 Oct 10 09:43 VONameCorrection.frm
-rw-rw---- 1 diana dbi 114688 Oct 10 09:43 VONameCorrection.ibd
=============================================================
-rw-rw---- 1 diana dbi
8918 Aug 29 09:08 VOProbeSummaryData.frm
-rw-rw---- 1 diana dbi 14680064 Sep 20 17:08 VOProbeSummaryData.ibd
mysql> alter
table VOProbeSummaryData engine=innodb;
Query OK, 13859 rows affected (5.16 sec)
Records: 13859 Duplicates: 0 Warnings: 0
-rw-rw---- 1 diana dbi
8918 Oct 10 09:45 VOProbeSummaryData.frm
-rw-rw---- 1 diana dbi 14680064 Oct 10 09:46 VOProbeSummaryData.ibd
==============================================================
-rw-rw---- 1 diana dbi
8710 Aug 29 09:08 VolumeResource.frm
-rw-rw---- 1 diana dbi 114688 Aug 29 09:08 VolumeResource.ibd
mysql> alter
table VolumeResource engine=innodb;
Query OK, 0 rows affected (0.14 sec)
Records: 0 Duplicates: 0 Warnings:
-rw-rw---- 1 diana dbi
8710 Oct 10 09:48 VolumeResource.frm
-rw-rw---- 1 diana dbi 114688 Oct 10 09:48 VolumeResource.ibd
==============================================================
-rw-rw---- 1 diana dbi
8988 Sep 17 11:49 trace.frm
-rw-rw---- 1 diana dbi 98304 Sep 17 13:41 trace.ibd
mysql> alter
table trace engine=innodb;
Query OK, 15 rows affected (0.43 sec)
Records: 15 Duplicates: 0 Warnings: 0
-rw-rw---- 1 diana dbi
8988 Oct 10 09:49 trace.frm
-rw-rw---- 1 diana dbi 98304 Oct 10 09:50 trace.ibd
Benchmark test after converting
all tables to innodb
mysql> select JobUsageRecord_Report.VOName,
sum(JobUsageRecord_Report.WallDuration) as WallDuration,
-> sum(JobUsageRecord_Report.CpuUserDuration +
-> JobUsageRecord_Report.CpuSystemDuration) as Cpu,
-> sum(JobUsageRecord_Report.Njobs) as Njobs from JobUsageRecord_Report where
-> EndTime >= date('2007-08-11 00:00:00 GMT') and EndTime <= date('2007-08-28
00:00:00 GMT')
-> and ResourceType = 'Batch' group by JobUsageRecord_Report.VOName order by
JobUsageRecord_Report.VOName \G
18 rows in set, 4 warnings (9 min 23.08 sec)
mysql> select
JobUsageRecord_Report.VOName, sum(JobUsageRecord_Report.WallDuration) as
WallDuration,
-> sum(JobUsageRecord_Report.CpuUserDuration +
-> JobUsageRecord_Report.CpuSystemDuration) as Cpu,
-> sum(JobUsageRecord_Report.Njobs) as Njobs from JobUsageRecord_Report where
-> EndTime >= date('2007-07-11 00:00:00 GMT') and EndTime <= date('2007-08-28
00:00:00 GMT')
-> and ResourceType = 'Batch' group by JobUsageRecord_Report.VOName order by
JobUsageRecord_Report.VOName \G
20 rows in set, 4 warnings (8 min 34.66 sec)