SHOW STATUS 创建临时磁盘表
显示全局状态，例如“Created_tmp_disk_tables”。
每次我通过 phpmyadmin 运行该查询时，都会创建另一个基于磁盘的临时表。
有办法预防吗？
编辑：看起来在 phpmyadmin 中做的任何事情都是创建临时磁盘表。
SHOW GLOBAL STATUS LIKE 'Created_tmp_disk_tables'.
Everytime I run that query through phpmyadmin another disk based temp table is created.
Is there a way to prevent it?
Edit : Looks like doing anything in phpmyadmin is creating temp disk tables.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我不认为是这样...我现在已经在3台服务器上进行了测试（其中2台MySQL 5.1，一台是5.0），我已经运行了几次命令，临时表的数量没有增加。你有哪个 MySQL 版本？在哪个平台上？无论如何，如果这是真的，我会说这是一个错误，因为显示变量不需要创建临时表。
因此，您的服务器上运行的其他一些查询似乎正在创建这些磁盘临时表并增加您的计数。
I don't think it is so... I have now tested on 3 servers (2 of them MySQL 5.1, one is 5.0), I have run the command several times and number of temp tables did not increase. Which MySQL version do you have? On which platform? Anyway, if it would be true, I would say it is a bug, because showing a variable should not need to create a temp table.
So it seems that some other queries which are running on your server are creating those disk temp tables and increasing your count.