1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

aps database huge grows

Discussion in 'Plesk 10.x for Linux Issues, Fixes, How-To' started by AndrasJ, Mar 27, 2012.

  1. AndrasJ

    AndrasJ New Pleskian

    19
     
    Joined:
    Dec 23, 2009
    Messages:
    4
    Likes Received:
    0
    Location:
    Budapest, Hungary
    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
     
  2. AndrasJ

    AndrasJ New Pleskian

    19
     
    Joined:
    Dec 23, 2009
    Messages:
    4
    Likes Received:
    0
    Location:
    Budapest, Hungary
    Server parameters:
    Parallels Plesk Panel v10.3.1_build1013110726.09 os_Debian 6.0
    Linux 2.6.32-5-amd64
     
Loading...