Thanks Jeremy, Iīll try this. Leo
----- Original Message ----- From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "Leonardo Rodrigues" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, October 24, 2003 5:23 AM Subject: Re: Optimizing table (so-called VACUUM on postgreSQL) and InnoDB > 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]
