Geek Answers Handbook

Slow TIME TABLE OF TIME

Inclusion into an interesting problem with the MySQL table, which I created as a temporary table for reporting purposes.

I found that if I did not specify a storage mechanism, the DROP TEMPORARY TABLE command would hang for half a second.

If I defined my table as ENGINE = MEMORY, this short hang will disappear.

Since I have a solution to this problem (using MEMORY tables), my question is why will the temporary table take a lot of time? By default, they do not use the MEMORY engine? It’s not even a very large table, a couple of hundred lines with my current test data.

+5
source share
2 answers

, , , - mysql, /tmp - . ( ) RAM, /dev/shm.

, !

+4

InnoDb, , InnoDb, InnoDb , DROP TEMPORARY TABLE , . .

, DROP (TEMPORARY) TABLE LOCK, . , , .

, InnoDb 80 , SQL InnoDb. 100 DROP TEMPORARY TABLE 5 , . , , , - , , . , DROP TEMPORARY TABLE.

0

More articles:


All Articles