MySQL Innodb--共享临时表空间和临时文件

输出为：

mysqld    22346   mysql    5u      REG               8,17            0   47278234 /export/data/mysql/tmp/ibW1DoSr (deleted)
mysqld    22346   mysql    6u      REG               8,17            0   47278235 /export/data/mysql/tmp/ibAhuhtS (deleted)
mysqld    22346   mysql    7u      REG               8,17            0   47278236 /export/data/mysql/tmp/ibiiHa4i (deleted)
mysqld    22346   mysql    8u      REG               8,17            0   47278237 /export/data/mysql/tmp/ibeje7dX (deleted)
mysqld    22346   mysql   13u      REG               8,17            0   47278238 /export/data/mysql/tmp/ibLORUJC (deleted)
mysqld    22346   mysql 2943u      REG               8,17            0   47278301 /export/data/mysql/tmp/MLVChF9b (deleted)
mysqld    22346   mysql 3785u      REG               8,17            0   47278326 /export/data/mysql/tmp/MLx6V0TO (deleted)
mysqld    22346   mysql 4795u      REG               8,17            0   47278371 /export/data/mysql/tmp/MLz5r2Yv (deleted)
mysqld    22346   mysql 4928u      REG               8,17            0   47278574 /export/data/mysql/tmp/ML7ivmrd (deleted)
mysqld    22346   mysql 5414u      REG               8,17            0   47278653 /export/data/mysql/tmp/MLx4HGxW (deleted)
mysqld    22346   mysql 6105u      REG               8,17            0   47278714 /export/data/mysql/tmp/MLADScmK (deleted)
mysqld    22346   mysql 6314u      REG               8,17            0   47278715 /export/data/mysql/tmp/MLG8aCpz (deleted)
mysqld    22346   mysql 6315u      REG               8,17            0   47278716 /export/data/mysql/tmp/MLJ7MuCo (deleted)

可以看到该目录下有ML开头和ib开头的文件，用来缓存BINLOG和排序结果。

MySQL Innodb--共享临时表空间和临时文件

标签：end   引入   缓存   inno   命令   scm   系统表   默认   code