List:General Discussion« Previous MessageNext Message »
From:<sinisa Date:April 20 2000 3:16pm
Subject:Re: Mysql update logs trouble.
View as plain text  
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       |
+----------------------------------------------------------------------+
Thread
SQL questionHarry Brueckner12 Mar
  • Re: SQL questionMartin Ramsch13 Mar
  • Re: SQL questionChristian Mack13 Mar
  • Re: Mysql update logs trouble.sinisa20 Apr
  • Re: Innobase released in MySQL-3.23.34a source distribution: transactions and row level locking now in MySQLJean-Luc Fontaine12 Mar