Hi,
Recently, i met an issue that high CPU usage of Mysqld process with opendaylight journaling. So i search the solution by google and i found that there was already existed a bug report on networking-odl project(1717018 High CPU usage of Mysqld process with opendaylight journaling). But i found that the cause of this bug is differ from mine.
I found that high CPU usage of Mysqld process with opendaylight journaling when i stop the opendaylight process. So the neutron resources are not able sync to opendaylight. As time goes on, the journal db rows growing up that result in the high CPU usage of Mysqld process.
Below is my journal db rows count:
MySQL [neutron]> select count(*) from opendaylightjournal;
+----------+
| count(*) |
+----------+
| 23941 |
+----------+
1 row in set (0.02 sec)
MySQL [neutron]> select count(*) from opendaylightjournal where state='pending';
+----------+
| count(*) |
+----------+
| 23941 |
+----------+
1 row in set (0.01 sec)
MySQL [neutron]> select count(*) from opendaylight_journal_deps;
+----------+
| count(*) |
+----------+
| 8380997 |
+----------+
1 row in set (1.49 sec)
Thanks for reporting this issue.
Could you please give some details about your environment (versions, etc...)
If I understand well the simple reproduction step is to stop ODL process?