aps database huge grows

[AndrasJ]

Hi All,

A few days ago the apsc database growth (39MB). Healt monotoring is alarm me to MySQL CPU time is high (almost 100%) at daily scheduled backup. Other time all work perfectly.

History:
The xxx.tld domain is migrated from Plesk 9.5 (unix) to 10.3.1, and the installed app from 9.5 not working anymore in 10.3.1 (TUTOS) and in panel caused the following error: resource of type aps.database with id not found by brokers.
User manager was not available at this domain.
I make a fix from here: http://jackal777.wordpress.com/2011...pe-aps-database-with-id-not-found-by-brokers/
User manager will be fine, but in I can't remove TUTOS from Applications/manage installed apps/remove.

apsc databese contains many (82.000 to ~500.000+) records like this:

mysql> select * from aps_application_backup
.....
| 44115 | 88251 | d655eaef-1073-4f41-8db4-3f60f6afb14a | 2 | |
| 44116 | 88253 | d655eaef-1073-4f41-8db4-3f60f6afb14a | 2 | |
| 44117 | 88255 | d655eaef-1073-4f41-8db4-3f60f6afb14a | 2 | |
+-------+--------------------+--------------------------------------+------------+---------------+
43633 rows in set (0.03 sec)

SELECT * FROM aps_registry_object;
.....
| 88253 | f42d7ead-f9f0-49c4-b066-6b8f59395f91 | aps.application.backup | 2012-03-27 03:58:53 | y |
| 88254 | b370b700-0118-41e2-8426-64c483bea139 | aps.resource.backup | 2012-03-27 03:58:53 | y |
| 88255 | 01b9cd45-dc11-4c6c-be7c-a1658652bad1 | aps.application.backup | 2012-03-27 03:58:54 | y |
| 88256 | 8588c040-30bc-4fb7-8bfd-ca5ed40b6b19 | aps.resource.backup | 2012-03-27 03:58:54 | y |
+-------+--------------------------------------+------------------------+---------------------+---------+
87271 rows in set (0.13 sec)

SELECT * FROM aps_registry_object_setting;
....
| ssl_target_directory | false | 0 | NULL | 88250 |
| ssl_target_directory | false | 0 | NULL | 88252 |
| ssl_target_directory | false | 0 | NULL | 88254 |
| ssl_target_directory | false | 0 | NULL | 88256 |
| type | mysql | 0 | NULL | 59 |
| version | 4.1.13 | 0 | NULL | 59 |
+----------------------+-----------------------------------------------+-----------+------+--------------------+
479997 rows in set (0.86 sec)


select * from aps_resource_backup;
....
| 44115 | 88252 | 44115 | dad2d272-1985-426a-a83a-298791a6c67b | | NULL | NULL | |
| 44116 | 88254 | 44116 | dad2d272-1985-426a-a83a-298791a6c67b | | NULL | NULL | |
| 44117 | 88256 | 44117 | dad2d272-1985-426a-a83a-298791a6c67b | | NULL | NULL | |
+-------+--------------------+---------------+--------------------------------------+---------------+---------------------------+---------------------+------------+
43633 rows in set (0.06 sec)

select * from aps_resource_requirement_backup;
.....
| 132339 | 44116 | 50e96235-6296-4bc1-b1d5-797aed8c4ab9 | aps.environment | | NULL | NULL |
| 132341 | 44117 | dad2d272-1985-426a-a83a-298791a6c67b | aps.database | main | NULL | NULL |
| 132342 | 44117 | 50e96235-6296-4bc1-b1d5-797aed8c4ab9 | aps.environment | | NULL | NULL |
+--------+--------------------+--------------------------------------+-----------------+----------------+--------------------------------------+--------+
87265 rows in set (0.16 sec)


...so guys, how can I correct these database tables, and daily backup not use so much CPU, and remove tutos apps from xxx.tld domain.

Thank you.
BR, Golyo

 

[AndrasJ]

Server parameters:
Parallels Plesk Panel v10.3.1_build1013110726.09 os_Debian 6.0
Linux 2.6.32-5-amd64