Re: InnoDB vs. MySQL performance Issue
Sam, I think now it is time to stop what you have started. If you can't answer the question then don't waste the time of thousand of users on this list with your personal opinions and comments on people signatures. You can communicate with the user directly, not through the list. Other wise it becomes too provoking. P.S I don't expect any reply, but if you insist then no CC to the list. Thanks Salam Baker Sam Przyswa wrote: Maximo Migliari ([EMAIL PROTECTED]) écrivait: Sameh, We r here to help one another solving their problems. Ive never posted any solutions, to this list or another based on religion or something else but the problem itself only. I invite all people here to read the Islamic history of true muslims and youll find that we never treated people based on their religion. All the times nonmuslims get all thier rights under isalmic control. We never kill children, women, unarmed persons...etc Septenber 11 2001, more than 3000 women, men, child, killed, Tel Aviv January 5 2003, 23 death and 100 injured by islamic terrorists, that's the islamic history (small part). Sam Apache-PHP-MySQL user. -- Albert Einstein, Karl Marx, Jesus Christ, and you Mohamed what have you done for the world ? - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Bug using truncation in 4.0.4-beta
Description:
Special case: using SELECT with truncation doesn't return some records
when the searched query appears at the end of the line. Note that the last
record will
be matched and returned because there is a space character at the end.
I am using ft_min_word_len = 1;
How-To-Repeat:
Try this:
drop database if exists Test_Bug ;
create database Test_Bug;
use Test_Bug;
create table article (id int(10) primary key not null auto_increment, title text);
insert into article values
(0, 'Probability and Statistics with Reliability, Queueing and Computer Science
Applications'),
(0, 'Rasiowa-Sikorski deduction systems in computer science application'),
(0, 'Computer science today in the European Union'),
(0, 'Phase transition in a random fragmentation problem with applications to computer
science'),
(0, 'A Collection of Papers and Memoirs Celebrating the Contribution of Rod Burstall
to Advances in Computer Science'),
(0, 'KITE microprocessor and CAE for computer science'),
(0, 'What Makes Them Succeed? Entry, progression and graduation in Computer Science ');
create fulltext index ti_idx on article (title);
select id,title from article where match (title) against ('computer science' in
boolean mode);
select . Now using the truncation operator .. as '';
select id,title from article where match (title) against ('computer science*' in
boolean mode);
Fix:
Submitter-Id: submitter ID
Originator:
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Severity:
Priority:
Category: mysql
Class:
Release: mysql-4.0.4-beta (Source distribution)
Environment:
System: Linux nile.lub.lu.se 2.4.7-10smp #1 SMP Thu Sep 6 16:16:16 EDT 2001 i686
unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98)
Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS=''
LIBC:
lrwxrwxrwx1 root root 13 Sep 16 15:52 /lib/libc.so.6 - libc-2.2.4.so
-rwxr-xr-x1 root root 1282588 Sep 4 2001 /lib/libc-2.2.4.so
-rw-r--r--1 root root 27304836 Sep 4 2001 /usr/lib/libc.a
-rw-r--r--1 root root 178 Sep 4 2001 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr/local/mysql --with-raid
--with-named-curses-libs=/usr/lib/libncurses.so.5.2 --with-innodb
Regards
Salam
-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
