VACUUM is basically a workalike for: ALTER TABLE <table_name> TYPE=InnoDB;
There are various types of VACUUM commands as well. VACUUM FULL basically locks the table and shrinks the on-disk table space. The normal "VACUUM" (normal since 7.2 I think), does not lock the table (similar to REORGANISE in some other databases, while REORGANISE in some databases like SQLBase REORGANISE locks everything) but does a basic defrag. Hope this helps! Regards, Chris On Fri, 24 Oct 2003 05:23 pm, Jeremy Zawodny wrote: > 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]
