I executed some alter statements on my master server, which have been successfully executed on master (now there is no temp table on master) and all alter also have been replicated on slave server successfully. But still I am getting temp table on slave (#sql-7a87_230c32.ibd and #sql-7a87_230c32.frm).
Now I need help to know below points:
When alter has been successfully done then why this temp table still exist and not deleted.
Now how can I delete this temp table and what will be its impact.
May I read this temp file or know by any command that for which table this temp table was created.
Note: If I delete it from its directory path then mysql will throw error message related with it and also I am not aware what will be its impact.
I will be very thankful for any quick help.
1.. When alter has been successfully done then why this temp table still exist and not deleted.
After reading #sql-7a87_230c32.frm whith the help of your post, now it is clear that it was my first alter table (I altered 6 tables one by one).
Below are some facts which will help to know exact reason-
sql-7a87_230c32.frm file creation time is "2014-06-09 01:49:00" and its .ibd file #sql-7a87_230c32.frm time is "2014-06-09 03:34:00" and its size is 3.4 GB while its main file size is 6.8 GB
After checking server logs it came to know that slave was being shutdown at "2014-06-09 03:33:05" (I have to check if it was done by system admin team even they were aware about this db activity or itself) and restarted when alter was executing on slave.
This table creation time on slave is showing as "2014-06-09 04:43:32".
After analyzing above facts it seems first time alter statement on this table was executing near about "2014-06-09 01:49:00" but without copying completely (as temp .ibd table size is less than its original size) it was rolled back when server was gone shutdown near about at "2014-06-09 03:33:05" but system did not remove these temp tables. Now again when slave gone up it was started replication again same point and now altered table successfully, which was completed by "2014-06-09 04:43:32".
But as per my understanding in this case temp tables should be remove along with rolled back but in this case it was not done. Please help me to clear it.