guys, i'm creating a table with:CREATE TABLE xxx SELECT * FROM yyyy
this one take a long time (more than 1 hour) to end...
my problem is... i'm using HeidiSQL sometimes to check tables and etc...
when i open database it execute a
SHOW TABLE STATUS FROM `database`
but is blocked while create table don't end, could we implement a non block show table? or a timeout?
--
Roberto Spadim
SPAEmpresarial
Eng. Automação e Controle