Re: InnoDB data log files

2007-04-25 Thread Andrew Simpson
Hi Dan, Thanks for this, fixed the problem perfectly when we applied it. Andrew On Thu, 2007-04-12 at 10:45 -0500, Dan Nelson wrote: > In the last episode (Apr 12), Andrew Simpson said: > > One server had a problem while creating a backup last week. The routine > > normally takes about 30 seco

Re: InnoDB data log files

2007-04-12 Thread Dan Nelson
In the last episode (Apr 12), Andrew Simpson said: > One server had a problem while creating a backup last week. The routine > normally takes about 30 seconds, but in this case went on for over 30 > minutes. During this, the application was responding correctly to other > users. After a reboot,

InnoDB data log files

2007-04-12 Thread Andrew Simpson
Hello all, I am looking after the installation of web-based software built using MySQL with mostly InnoDB tables. The software is currently installed in over 10 locations and has been running continually for several months in some of these. These installations vary from several thousand to sev