Hi, Im encountering something very funny with embedded server (libmysqld.dll) ver 4.0.12, im connecting to this using Delphi 7 statically on a windows 98 machine. If i call mysql_real_query('OPTIMIZE TABLE my_db.my_table') in the main thread it works perfectly fine, but the moment i call exactly the same thing inside another worker thread the call simply hangs (the call to mysql_real_quesy does not seem to return)
Im working with MyIsam tables, and i have been able to work 'select' queries in a worker thread. Has anybody encountered any similar problems, i guess it could have something to do with the OPTIMIZE TABLE satetement Thank you and Regards G