Bug #6041 | Select statements with 'not empty' sit at sorting result | ||
---|---|---|---|
Submitted: | 12 Oct 2004 10:22 | Modified: | 12 Nov 2004 14:50 |
Reporter: | Michael Furdyk | Email Updates: | |
Status: | No Feedback | Impact on me: | |
Category: | MySQL Server: MyISAM storage engine | Severity: | S1 (Critical) |
Version: | 4.1.5-gamma-standard-log | OS: | Linux (Redhat 7.3) |
Assigned to: | CPU Architecture: | Any |
[12 Oct 2004 10:22]
Michael Furdyk
[12 Oct 2004 10:30]
Michael Furdyk
I noticed a bunch of these types of files are being created in data... 12 -rw-rw---- 1 mysql mysql 10058 Oct 12 04:56 #sql-181_6f.frm 5348 -rw-rw---- 1 mysql mysql 5463048 Oct 12 04:56 #sql-181_6f.MYD 116 -rw-rw---- 1 mysql mysql 112640 Oct 12 06:07 #sql-181_6f.MYI 5348 -rw-r--r-- 1 root root 5463048 Oct 12 06:07 #sql-181_6f.TMD 12 -rw-rw---- 1 mysql mysql 10058 Oct 12 05:02 #sql-272_28.frm 5348 -rw-rw---- 1 mysql mysql 5463048 Oct 12 05:02 #sql-272_28.MYD 116 -rw-rw---- 1 mysql mysql 112640 Oct 12 05:02 #sql-272_28.MYI 12 -rw-rw---- 1 mysql mysql 10058 Oct 12 04:28 #sql-7da9_395.frm 5348 -rw-rw---- 1 mysql mysql 5463048 Oct 12 04:28 #sql-7da9_395.MYD 116 -rw-rw---- 1 mysql mysql 112640 Oct 12 04:28 #sql-7da9_395.MYI 12 -rw-rw---- 1 mysql mysql 10058 Oct 12 04:37 #sql-7f35_51.frm 5348 -rw-rw---- 1 mysql mysql 5463048 Oct 12 04:37 #sql-7f35_51.MYD 116 -rw-rw---- 1 mysql mysql 112640 Oct 12 04:37 #sql-7f35_51.MYI
[12 Oct 2004 10:41]
MySQL Verification Team
Hi, Thank you for the report. Do you get server hang with exactly the same test case? Because it works fine for me. If no, how big is table 'Organizations'?
[12 Oct 2004 11:12]
MySQL Verification Team
These files are temporary tables that MySQL creates during execution some queries. Check that you have enough free disk space.
[12 Oct 2004 11:23]
Michael Furdyk
Yes, there's enough disk space. With more investigation, mysql seems to be having this problem with a few tables it's incorrectly set as utf-8 - they are actually latin1. When the default charset was changed it seemed to ignore the latin1 tables latin1 origin and set them somehow as utf8? Do you think this could be the problem? (not in logs) if so, how can I get mysql to properly re-identify the tables that are latin1? ALTER TABLE `Events` DEFAULT CHARACTER SET latin1 COLLATE latin1_general_ci ; just seems to hang forever...
[12 Oct 2004 14:50]
MySQL Verification Team
If you want to change just default character set, the above ALTER TABLE statement does it. If you want to convert all data from utf8 to latin1, you should use ALTER TABLE ... CONVERT TO CHARACTER SET .. If you didn't specify explicitly character set for the table, table has the same character set as current database has. You didn't answer me about size of the table "Organizations". Tell me also, how many rows in the table that are satisfied Name!='' condition? What is the output of EXPLAIN SELECT?
[14 Feb 2005 22:54]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".