One of the developers is having a problem optimizing a table in MySQL 4.0.14-standard on Solaris 9. The optimize seems to succeed but when he tries to access the table with a SQL client, we get an error of something to the effect that MySQL "cannot fine MESSAGES.MYI". After running 'myisamchk -o' on the table, corruption is found and repaired. This happens every time the optimize is run on the table.
I think the problem may be reltated to disk space; we are rather low on some file systems. Our pet theory is that the optimize writes out a temporary DB which fails. Does anyone know what exactly optimize writes out to the OS? I cannot find any information on this. Thanks, Ben Ricker Wellinx.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]