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: >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