MySQL 4.0.2, 4.0.3,4.0.4 replication circle broken.

2002-09-10 Thread Artem V. Ryabov
Hello Victoria, As far as I see bug of muliple log files still not fixed regardless of last change in 4.0.4: 'FLUSH LOGS removed numerical extension for all future update logs.' -- Best regards, Artem mailto:[EMAIL PROTECTED] sql query

Re: MySQL 4.0.2, 4.0.3 replication circle broken.

2002-09-02 Thread Artem V. Ryabov
Hello Victoria, Thursday, August 15, 2002, you wrote: AVR>> In case of repliacation circle (A->B->A) query 'flush log' on any of AVR>> this servers create endless loop, with creating new binary log file AVR>> on each iteration. (about 30 new files every second in my case) > Thanks for bug r

MySQL 4.0.2, 4.0.3 replication circle broken.

2002-08-15 Thread Artem V. Ryabov
Hello mysql, In case of repliacation circle (A->B->A) query 'flush log' on any of this servers create endless loop, with creating new binary log file on each iteration. (about 30 new files every second in my case) -- Best regards, Artem mailto:[EMAIL PROTECTED]

Re: MySQL 4.0.2 replication circle broken?

2002-08-14 Thread Artem V. Ryabov
Hello all, I was check up 4.0.3 (from the Development Source Tree), bug still exist. >>Description: aor> I use replication circle (A->B, B->A) with 3.23.51 - all ok. aor> But I got problem, when upgrade both my servers to 4.0.2. aor> Mysqld create 30 new bin-log files eve

Re[2]: Bug or feature fulltext search?

2002-08-01 Thread Artem V. Ryabov
Hello Sergei, Tuesday, July 23, 2002, 10:17:06 PM, you wrote: SG> Hi! SG> On Jul 23, Artem V. Ryabov wrote: >> Hello mysql, >> >> see this 2 queries: >> why they not equal? >> why first skip many records? >> >> mysql> select left(ftTe

Re[2]: Bug or feature fulltext search?

2002-07-24 Thread Artem V. Ryabov
Hello Sergei, Tuesday, July 23, 2002, 10:17:06 PM, you wrote: SG> Hi! SG> On Jul 23, Artem V. Ryabov wrote: >> Hello mysql, >> >> see this 2 queries: >> why they not equal? >> why first skip many records? >> >> mysql> select left(ftTe

Bug or feature fulltext search?

2002-07-23 Thread Artem V. Ryabov
Hello mysql, see this 2 queries: why they not equal? why first skip many records? mysql> select left(ftText,20) from Txt_index where match(ftText) against('+(wÝd200206*) +wÝ12p' in boolean mode); +--+ | left(ftText,20) | +--+ | wÝd20020601 wÝ12p

release 4.0.2

2002-06-04 Thread Artem V. Ryabov
Hello developers, What problem with release 4.0.2? Why you can't release it also as 'alpha' and continue work on next version like 4.0.3. You alredy fix many bugs and add many very nice features, such as query like 'MATCH ... AGAINST(... IN BOOLEAN MODE)'. Release it! We (users) wri

min() bug

2002-04-16 Thread Artem V. Ryabov
Hello mysql, mysql> create temporary table _234 select -20020412051754 as b; select min(b) from _234; Query OK, 1 row affected (0.00 sec) Records: 1 Duplicates: 0 Warnings: 0 +-+ | min(b) | +-+ | -20020412051744 | +-

min() bug

2002-04-12 Thread Artem V. Ryabov
Hello bugs, min return not value from table. mysql> select min(ord) from cSectText where SectID=932; +-+ | min(ord)| +-+ | -20020412051744 | +-+ 1 row in set (0.00 sec) mysql> select ord from cSectText where SectID=932

Re[2]: Bad count(*) perfermance on index.

2002-01-25 Thread Artem V. Ryabov
Hello Jeremy, Friday, January 25, 2002, 11:00:43 AM, you wrote: >> Why query type >> >> select count(*) from table_name where key_field between 'min' and >> 'max' so slow? >> >> example: >> >> mysql> select count(*) from Textes where ID between 7937 and 45061; >> +--+ >> | count(*) | >

Bad optimization on ORDER BY .. DESC.

2001-07-25 Thread Artem V. Ryabov
Hello All, When I use "order by .. DESC" in query, time always more then in "order by .. ASC" case. Explain say "Using filesort",in "DESC" case query. Why??? Why I can't use key value in select like that: select * from TableName where KEY(KEYNAME) select * from cSectText where SectID=1 o