On Thursday 30 June 2016 at 15:23:19, Diana Scannicchio wrote:
> below you can see what I get by connecting to MySQL as a privileged user and
> asking it to "show processlist” on both the nodes (one running v2.4.10 and
> the second one running v2.3.11. And also the output of top.
Well, the first interestng bit is on the test machine, where MySQL is busy
"logging slow query", so I do think that turning on the slow query log in your
MySQL my.cnf should shed some further light on this problem.
Secondly I see from 'top' that mysqld is using 67.4% CPU and 70.4% memory,
which is certainly excessive for this activity.
The test machine is also using ~128Mbytes swap space, which is not excessive,
but interesting given that the production machine is using none.
I see a load average of 7.74 - how many CPU cores are there on the test
machine?
Finally, you have 964 processes running (again, on the test machine - it seems
to show the problem more extremely than the production machine does) - can you
identify from ps what the majority of these are?
The only other question I have is "how was the icinga2 database created in
MySQL on these machines?" It does look to me rather as though missing indexes
could be the problem, but I think the output of the slow query log should help
with that.
Regards,
Antony.
--
#define SIX 1+5
#define NINE 8+1
int main() {
printf("%d\n", SIX * NINE);
}
- thanks to ECB for bringing this to my attention
Please reply to the list;
please *don't* CC me.
_______________________________________________
icinga-users mailing list
icinga-users@lists.icinga.org
https://lists.icinga.org/mailman/listinfo/icinga-users
