Just for completeness, in case someone has the same problem.
Adding the indexes reduced the CPU usage from 100% during the night (1 Core
used by MySQL) to ~50% peak and maybe 25% average.
create index ix_job_jobtdate on Job(JobTDate);
create index ix_jobmedia_mediaid on JobMedia(MediaId);
Without the indexes (4 Core system):
00:00:01 CPU %user %nice %system %iowait %steal %idle
01:00:01 all 7,90 0,00 0,24 0,02 0,00 91,84
02:00:01 all 24,03 0,00 0,55 0,10 0,00 75,32
03:00:01 all 23,98 0,00 0,53 0,08 0,00 75,41
04:00:01 all 24,19 0,00 0,54 0,15 0,00 75,11
05:00:01 all 24,54 0,00 0,62 0,28 0,00 74,56
06:00:01 all 24,72 0,00 0,71 0,48 0,00 74,10
07:00:01 all 24,35 0,00 0,58 0,26 0,00 74,80
08:00:01 all 24,83 0,00 0,75 0,45 0,00 73,97
09:00:01 all 24,01 0,00 0,53 0,10 0,00 75,36
10:00:01 all 18,07 0,00 0,58 0,13 0,00 81,22
11:00:01 all 3,54 0,00 0,24 0,03 0,00 96,19
With the indexes:
00:00:01 CPU %user %nice %system %iowait %steal %idle
01:00:01 all 1,04 0,00 0,21 0,02 0,00 98,73
02:00:01 all 6,09 0,00 1,08 0,26 0,00 92,57
03:00:01 all 3,56 0,00 0,61 0,25 0,00 95,58
04:00:01 all 2,86 0,00 0,55 0,38 0,00 96,21
05:00:01 all 1,85 0,00 0,36 0,08 0,00 97,70
06:00:01 all 3,91 0,00 0,77 0,69 0,00 94,62
07:00:01 all 2,54 0,00 0,50 0,15 0,00 96,81
08:00:01 all 1,90 0,00 0,37 0,06 0,00 97,67
09:00:01 all 1,32 0,00 0,25 0,03 0,00 98,39
10:00:01 all 0,48 0,00 0,12 0,01 0,00 99,39
Regards,
Robert
------------------------------------------------------------------------------
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|