[OSM-talk] Database Maintenance

Tom Hughes tom at compton.nu
Sun Jul 29 17:39:01 BST 2007


In message <46ACC142.7000908 at siliconcircus.com>
          Jon Bright <jon at siliconcircus.com> wrote:

> Tom Hughes wrote:
>
> > All I can tell you is that there are two ALTER TABLE statements
> > still running (for current_nodes and current_segments). Unfortunately
> > there is (as far as I can tell) no way to monitor their progress and
> > see how far they have got.
> 
> If we're talking about MySQL and those are MyISAM tables

They're InnoDB...

> If it's postgres, or if those are (as I suspect) InnoDB tables, then I
> also have no clue how to monitor the progress.  Possibly something shows
> up in "show table status" or "show innodb status"?

I don't have privs for "show innodb status" unfortunately, and
there is no sign of the temporary tables it is copying to in
the "show table status" output so I can't see how big they are
relative to the originals :-(

Tom

-- 
Tom Hughes (tom at compton.nu)
http://www.compton.nu/




More information about the talk mailing list