Adriano - MySQL names temp tables like that (starting with # sign), in paticular while storing a result set to be sorted. I would guess that your query is returning a result set large enough to hit a filesystem limit on your box. How big are you expecting the results to be? Perhaps you are missing a join, or have a malformed query in some way, and therefore producing a cartesian product.
You could try removing any sort you have on the data to see if the query will return results that way, since MySQL won't attempt to sort the data and therefore may not fill up a temp table. You could also try a LIMIT x on your statement to see if your query is returning what you expect. Finally, it is very helpful in this forum if you post your table structures, your actual query as well as the output you get from running EXPLAIN <query>; Best, Dan On 10/21/06, adriano ghezzi <[EMAIL PROTECTED]> wrote:
Hy thank you all, I'm getting the following err msg -> The table '#sql_2c52_0' is full running a complex query (and only running that query) with three outer join it is a simple db that stores mail msgs my query is about mail msg->recipients->sender the biggest table mail_archive has 90467 rows I checked every things I know: -disk space tables integrity isam check etc... my server is-> server version: 4.0.24_Debian-10sarge2-log all tables are myISAM tables this snippets is in csv format output from command: SHOW TABLE STATUS FROM mydbLIKE 'mail%' mysql> "Name","Type","Row_format","Rows","Avg_row_length","Data_length","Max_data_length","Index_length","Data_free","Auto_increment","Create_time","Update_time","Check_time","Create_options","Comment" "mail_archive","MyISAM","Dynamic",90467,4307,389686660,4294967295,2044928,0,102183,"2006-10-01 02:38:34","2006-10-01 23:15:31","2006-10-01 02:43:55","","" "mail_attachment_archive","MyISAM","Dynamic",47107,47,2233816,4294967295,1024,0,,"2006-01-20 09:53:26","2006-10-01 23:15:31","","","" "mail_recipients","MyISAM","Dynamic",682960,51,34918212,4294967295,5704704,19044,,"2006-01-20 09:53:26","2006-10-01 23:15:31","","","" "mail_senders","MyISAM","Dynamic",49247,50,2497204,4294967295,421888,3560,,"2006-01-20 09:53:26","2006-10-01 23:15:31","2006-03-23 23:53:08","","" any help would be appreciate. TIA ag. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
