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]