Hello all, The referencial integrity control don�t apply to a simple table, do it? So, I saw it�s good to do it use InnoDB table type. What�s your opinion about it? Is it the only and the best way to apply refericial integrity?
My DB is growing, and growing, and I�m very concerned about my host limitions of disk usage. So... Another question: postgreeSQL has a SQL command called VACUUM, which optimize and reduce the table�s used space disk. I discover for mySQL the commands "OPTIMIZE TABLE" and "ANALYZE TABLE", but both don�t run on InnoDB. My question are: are these commands similar to VACUUM? What�s the difference? How can I run on InnoDB? Very thanks for any light... Leonardo Rodrigues -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
