Bug #65615 | after truncating the table,data insert is slow | ||
---|---|---|---|
Submitted: | 14 Jun 2012 11:32 | Modified: | 15 Jun 2012 3:57 |
Reporter: | tatsuya sano | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Command-line Clients | Severity: | S3 (Non-critical) |
Version: | 5.6.5 m8 | OS: | Linux (CentOS5.8 32bit) |
Assigned to: | CPU Architecture: | Any | |
Tags: | truncate |
[14 Jun 2012 11:32]
tatsuya sano
[14 Jun 2012 11:44]
Valeriy Kravchuk
Please, send your my.cnf file content. I wonder if innodb_file_per_table is set. This may be similar to bug #59783.
[15 Jun 2012 1:38]
tatsuya sano
my.cnf file
Attachment: bug-data-65615.txt (text/plain), 5.40 KiB.
[15 Jun 2012 2:48]
tatsuya sano
I checked the bug # 59783, I thought it was the same problem. I tried the same test at MySQL5.5.25, this problem has been fixed. In MySQL5.6.6, there is no problem because it is scheduled for this fix. Thank you so much.
[15 Jun 2012 3:57]
tatsuya sano
changed status.