RE: Weird database files

2005-09-28 Thread Jeff McKeon
-Original Message- From: Gleb Paharenko [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 28, 2005 06:30 To: mysql@lists.mysql.com Subject: Re: Weird database files Hello. On the master we're still running 4.0.16, the slaves are up to 4.1.13. If you can - upgrade

Re: Weird database files

2005-09-27 Thread Gleb Paharenko
Hello. Yes, these files are from some unterminated query. See: http://dev.mysql.com/doc/mysql/en/temporary-files.html You may want to use --start-position (--start-datetime) and --stop-position (--stop-datetime) to skip the problematic statement and perform necessary updates on the

RE: Weird database files

2005-09-27 Thread Jeff
Jeff wrote: Had problem with our database this weekend, apparently an app did an insert query that was huge size wise and this totally boogered up replication downstream. Also I cant read past that point in the binlog using mysqlbinlog on the master server. It complains that:

Re: Weird database files

2005-09-27 Thread Jeff McKeon
Jeff wrote: Had problem with our database this weekend, apparently an app did an insert query that was huge size wise and this totally boogered up replication downstream. Also I cant read past that point in the binlog using mysqlbinlog on the master server. It complains that: