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
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
before all thank you for your answer,
next
while waiting for an answ3er I backup the db then tried to convert tables
in Inno db format
everything run fine now, the same query execute ok
but i prefer myIsam format i use it as default,
then I'd like to understand what is the problem,
here are