[Mysql] Performance problem after database drop

[kc atgb <kisscoolandthegangbang@hotmail.fr>]

Hi all,

I have a strange situation with one of our database servers. After a table purge
, we can see a performance degradation for the same jobs. 

What do the job do, write data to two tables. The first one is purged from
entries after 2 months. The second one, is never purged so we had do to it
manually and that was done some days ago. 

The table had a size approximatively of 350GB. The purge operatoin was done
without problem (show create table, drop table, create table). 

Some time after, 2 or maybe 3 days, a colleague reported me that some job that
was working with these datas, are taking longer to be executed. It's very very
strange because there was no configuration modification at all, just data purge.

The time needed for the job to terminate was from 45-60 minutes longer to 2h+
longer. 

Does any body have already been in a situation like this ? 

Any advice or feedback is welcome to help to troubleshoot this. 

Thanks,
K.