Lots of unused records in psa mysql Database tables

[kclo]

Hi all,

I have tried to provision over 3000 domains to my Plesk 9.5 servers and then delete these 3000 domains before I put the server into production. From the Plesk control panel, all domains have been removed. However, I found that there are still many records in several tables of the psa database.

Like
psa.accounts with over 5000 records
sys_users with 30 records
hosting with 17 records

All include some previous deleted domains record.

I seems that some records are not clear during domain removal.

Can I just removed those records from the Database? Any dependency need to check before action?

Thanks!

 

[IgorG]

What method to remove these 3000 domains did you use?
If domains were removed correctly by corresponding CLI utility or through Plesk interface, the extra entries in the database should not stay.

 

[MarkM]

should not stay.

For what it's worth, I've manually removed fields from these tables without issue. Just take a dump of the tables to be on the safe side, but it should not be needed.

 

[kclo]

Thanks for your reply!

I used Unix script to create and delete domain through Plesk api. In the middle of deleting 3000 domains, I see that there are errors that it can't connect to MySQL from Plesk api error code return. This may be the reason for many records in the DB.

Anyway, I have manually removed those records from MySQL