On Thu, Oct 16, 2003 at 05:13:58PM -0300, Leonardo Rodrigues wrote: > Hello all, > > The referencial integrity control donīt apply to a simple table, do > it?
What's a "simple" table? > My DB is growing, and growing, and Iīm very concerned about my host > limitions of disk usage. So... You should be! > 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. ANALYZE table runs on InnoDB. > My question are: are these commands similar to VACUUM? Whatīs the > difference? How can I run on InnoDB? I don't know much about PostgreSQL, so I'm not sure. If you describe what VACUUM does, I may be able to help explain how to do the same thing with MySQL. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 40 days, processed 1,530,867,850 queries (439/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
