[Cdash] client_job table size and performance issues

[Nils Gladitz]

On 30.03.2015 20:29, Zack Galbreath wrote:
> On Mon, Mar 30, 2015 at 1:44 PM, Nils Gladitz <nilsgladitz at gmail.com 
> <mailto:nilsgladitz at gmail.com>> wrote:
>
>
>     The output is now:
>       -- removing old buildids for projectid: 1
>       -- removing old buildids for projectid: 1
>
>     But the size of the table still seems to be unchanged.
>
>
> I'm afraid I don't know why this isn't working for you.  In case you 
> feel like investigating this further, here's a link to the relevant 
> query that collects up all the old records that should be deleted:
>
> https://github.com/Kitware/CDash/pull/36/files#diff-6f95875e9921e6792511bfb61afa94b7R114
>
> Let me know if you discover anything new.

As a matter of fact I was trying that right now :)

Based on that query I tried the following:
cdash=# SELECT cj.startdate, cj.enddate, cjs.startdate, cjs.enddate, 
cjs.repeattime, cj.status FROM client_job AS cj LEFT JOIN 
client_jobschedule AS cjs ON cj.scheduleid = cjs.id WHERE 
cjs.projectid=1 ORDER BY cj.startdate ASC LIMIT 5;
       startdate      |       enddate       |      startdate |       
enddate       | repeattime | status
---------------------+---------------------+---------------------+---------------------+------------+--------
  2014-09-05 14:26:16 | 2014-09-05 14:26:16 | 2014-09-05 14:24:46 | 
1980-01-01 00:00:00 |      24.00 |      3
  2014-09-05 14:27:37 | 2014-09-05 14:27:38 | 2014-09-05 14:26:27 | 
1980-01-01 00:00:00 |      24.00 |      3
  2014-09-05 14:29:59 | 2014-09-05 14:30:00 | 2014-09-05 14:29:27 | 
1980-01-01 00:00:00 |       0.04 |      3
  2014-09-05 14:31:20 | 2014-09-05 14:31:21 | 2014-09-05 14:29:27 | 
1980-01-01 00:00:00 |       0.04 |      3
  2014-09-05 14:32:01 | 2014-09-05 14:32:02 | 2014-09-05 14:31:11 | 
1980-01-01 00:00:00 |      24.00 |      3
(5 rows)

Also:

cdash=# select count(*) from client_jobschedule WHERE enddate <> 
'1980-01-01 00:00:00';
  count
-------
      0
(1 row)

Nils
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://public.kitware.com/pipermail/cdash/attachments/20150330/3fce01e2/attachment-0001.htm>