Hi,
1. I am reading 'internals' list and I see some words about subselect in 'bk
commit into 4.1 tree' messages...
Seems like we can expect subselect in 4.1 branch !?? :)
2. When 4.0.2 beta will be released?
3. Seems like gcc 3.0 (or 3.1?) becomes an official recommended compliler
for mysql
Hello,
I am very interesting in this work. Please continue it :)
Alexander
PS
Any chance to get the sources?
--
Server version: 4.0.2-alpha-log
Protocol version: 10
Connection: Localhost via UNIX socket
Client characterset:cp1251
Server
Hi,
I know, many fulltext bugs fixed last two weeks, thanks!
But this nice mysql4 feature are critical for us, we plan to use it in many
projects... and we test it again and again... :)
My test case:
http://www.graphit.ru/fulltext402.tar.gz
test.res - output from 4.0.2 cloned 2002-03-21.
With
Hello,
CREATE TABLE IF NOT EXISTS test (
id mediumint(6) unsigned NOT NULL DEFAULT '0' ,
txt text ,
PRIMARY KEY (id)
);
#insert. 4 rows
ALTER TABLE test ADD FULLTEXT findind (txt);
select * from test where match(txt) against('+sony -playstation' in boolean
mode)
(25 rows
Hello,
Sergey, thanks for the patch, I applied it for 4.0.1 and seems like
mentioned bug closed.
But I found new bug :)
Strange, but the query WORKS AS EXPECTED without fulltext index!
The results for 4.0.1 with latest fulltext patch applied:
If you need full testcase, please conteact me.
Hello,
I have found a bug( or bad feature? :) ) in 4.0.1
boolean fulltext search
Please help...
Test case with table can be found at http://logo.nino.ru/fulltextbug.tar.gz
Alexander
( sql database query table for you, spam protector:)
--
show variables like 'ft%'
--
Hello,
Why score is 0 in my query?
Any suggestions? Seems like fulltext '*' operator produce buggy results.
Alexander
mysql \s
--
./mysql Ver 11.19 Distrib 4.0.1-alpha, for pc-solaris2.8 (i386)
Connection id: 9
Current database:
Current user: root@localhost
Hello,
I have thread_concurrency=4 already in my.cnf, but mysqld don't want to use
more than 50% of CPU resources.
(Solaris8 x86 MU3 on Dual PIII Xeon with 1GB RAM)
Alexander
On Wednesday 18 July 2001 07:41, Alexander Belyaev wrote:
Hello,
I have a similar results on my Solaris8 x86 + MU3
Hello,
please let me know, if you are have some ideas about following:
--
mysql set @a='1';
Query OK, 0 rows affected (0.00 sec)
mysql select @a:=concat(@a,',',id) from message
Thanks for suggestions, just downgrading now.
Alexander
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
Hello,
We have dual PIII Xeon 700MB memory box for mysql database running Solaris8
x86 + mu3.
After upgrading from 3.23.33 to 3.23.35 *average* speed downed ~ 50% -60%.
Output from "sar" command shows heavy stress of I/O system.
I use word "average", because we have more than 30 databases with
11 matches
Mail list logo