From: <sinisa Date: April 20 2000 3:16pm Subject: Re: Mysql update logs trouble. List-Archive: http://lists.mysql.com/mysql/34745 Message-Id: <14591.8021.449591.410891@localhost.localdomain> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Tonu Samuel writes: > Seems to be thing, what can be and should be fixed. > > Thank you. > > > > Peter Zaitsev wrote: > > > > I'm running mysql 3.23.14 with update log turned on. (As well as queries log > > and slowqueries logs - first for debbugging the crash if one occures second > > to tune the database watching why the queries are executed slowly. > > > > The all logs are flushed every 5 minutes to feed update_log to replecating > > server. > > I found thery interesting thing todays morning - the number of mysql logs > > become really strange: > > > > root@samson:/spylog/logs > ls > > queries.log update_log.-2147483635 update_log.-2147483640 > > update_log.-2147483645 > > queries.zip update_log.-2147483636 update_log.-2147483641 > > update_log.-2147483646 > > sent update_log.-2147483637 update_log.-2147483642 > > update_log.-2147483647 > > slow_queries.log update_log.-2147483638 update_log.-2147483643 > > update_log.-2147483648 > > update_log.-2147483634 update_log.-2147483639 update_log.-2147483644 > > update_log.425 > > > > as you see the logs have huge negative numbers which is really bad :( > > > > Hope there would be no need in update logs since 3.23.15 as it will have the > > replication capatabilites made better but still this is probably a bug... > > HI! This is a known behaviour. There is an option for the startup of mysqld, but if you misuse #, you can get those numbers. Try to start it from some lower number. We have had those questions on the list already. Regards, Sinisa +----------------------------------------------------------------------+ | TcX ____ __ _____ _____ ___ == mysql@stripped | | /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic | | /*/ /*/ /*/ \*\_ |*| |*||*| mailto:sinisa@stripped | | /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus | | /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ | | ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ | | /*/ \*\ Developers Team | +----------------------------------------------------------------------+