Mysql: How to optimize deleting thousands of rows

I have hundred thousand rows in my table and I want to delete with condition It took 15 min but still not done? It's just a plane table no related model. Its a chunk of almost 200k rows that I want to remove I need to specify which needed to remove so I need to use condition If I can just truncate. Is there any way to handle this, I'm using laravel

Details::where('file_name_belongs',$file_name)->delete();

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2AKCvpl
via IFTTT