DROP TABLE IF EXISTS `table_name`;

CREATE PROCEDURE `DROP_TABLE`(IN `@table_name` varchar(50))
BEGIN
   DECLARE exit handler for sqlexception
   begin
   end;
   SELECT `id` FROM `table_locks` where `table_name` = `@table_name`LOCK IN SHARE MODE;
   DROP TABLE IF EXISTS `@table_name`;
   DELETE FROM `table_locks` WHERE `table_name` = `@table_name`;
END;

thread_cache_size=50
thread_concurrency=8
table_open_cache=2048
innodb_buffer_pool_size=256M 
innodb_flush_log_at_trx_commit=2