tbllog_register consume the cpu

[nimafire]

hello

this is what i have in mysql process list:

31522                       1606.8   0.0 Execut Waiting for tab Insert into `tbllog_register` (`namespace`, `name`, `namespace_id`, `namespace_value`, `updated_at`, `crea
    31523                       1606.7   0.0 Execut Waiting for tab Insert into `tbllog_register` (`namespace`, `name`, `namespace_id`, `namespace_value`, `updated_at`, `crea
    31580                       1308.6   0.0 Execut Waiting for tab Insert into `tbllog_register` (`namespace`, `name`, `namespace_id`, `namespace_value`, `updated_at`, `crea
    31771                       103.2   0.0 Execut Waiting for tab Select date_format(created_at, '%Y-%m-%d') AS date, name, namespace, IF((namespace_value REGEXP '^[[:digit
    31471                       0.3   0.0 Execut    Sending data Select * from `tbllog_register` limit 100 offset 844100

this make whmcs unavailable due to high load on cpu. ive check and there is no  cronjob for domain sync active, how can i disable this function ?

[nimafire]

any update?

[RadWebHosting]

You need to optimize your SQL server configuration and probably look to optimize your queries to reduce having your queries sitting in a queue like that 

[nimafire]

Changing database settings is not a principled way. It should be determined which service in the system uses this table and fills itChanging database settings is not a principled way. It should be determined which service in the system uses this table and fills it