• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

aps database huge grows

AndrasJ

New Pleskian
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
 
Server parameters:
Parallels Plesk Panel v10.3.1_build1013110726.09 os_Debian 6.0
Linux 2.6.32-5-amd64
 
Back
Top