I'm not sure it would work in my environment of IIS and MySQL ? On 29 Sep 2011, at 20:10, mos <mo...@fastmail.fm> wrote:
> Derek is right. The Sphynx search engine is much faster than MyISAM's full > text search engine. It will work on InnoDb tables so you don't have to export > the data to MyISAM. > > Mike > > At 01:43 PM 9/29/2011, you wrote: >> But I could create an additional myisam table to overcome my problem >> providing I can get the data to synchronise between the two tables >> >> On 29 Sep 2011, at 18:16, Reindl Harald <h.rei...@thelounge.net> wrote: >> >> > so mysql is currently the wrong database for your project >> > sad but true, you can not have fulltext-search and innodb this time >> > >> > Am 29.09.2011 19:15, schrieb Tompkins Neil: >> >> We've succesfully used FULLTEXT searching on another application that >> >> does not need Innodb tables. In addition for >> >> the FULLTEXT searching we use things like "IN BOOLEAN MODE" as well - so >> >> for our project Like %% is not enough. >> >> >> >> On Thu, Sep 29, 2011 at 6:13 PM, Reindl Harald <h.rei...@thelounge.net >> >> <mailto:h.rei...@thelounge.net>> wrote: >> >> >> >> you do not need any replication or myisam for >> >> select * from table where field like '%input%'; >> >> >> >> for most workloads this is enough and you have not the problem >> >> with stop-words, minimum input length and so on >> >> >> >> Am 29.09.2011 19:07, schrieb Tompkins Neil: >> >>> Yes, unless I can set-up some sort of replication between the two tables. >> >>> >> >>> On Thu, Sep 29, 2011 at 6:05 PM, Reindl Harald <h.rei...@thelounge.net >> >>> <mailto:h.rei...@thelounge.net>>wrote: >> >>> >> >>>> please do NOT post off-list! >> >>>> >> >>>> so your only workaround is like '%whatever%' currently >> >>>> >> >>>> Am 29.09.2011 19:04, schrieb Tompkins Neil: >> >>>> The reason I'm using Innodb is because the usage of foreign keys in >> >>>> short >> >>>> however, we need a couple of the tables to support FULLTEXT searching >> >>>> which Innodb >> >>>> does not support. >> >>>> >> >>>> >> >>>> On Thu, Sep 29, 2011 at 6:01 PM, Reindl Harald <h.rei...@thelounge.net >> >>>> <mailto:h.rei...@thelounge.net>>wrote: >> >>>> >> >>>>> >> >>>>> >> >>>>> Am 29.09.2011 18:56, schrieb Tompkins Neil: >> >>>>>> Hi >> >>>>>> >> >>>>>> I've a Innodb and MyISAM table in the SAME database that I wish to >> >>>>> replicate >> >>>>>> the data between the two because I need to use FULLTEXT searching on >> >>>>>> the MyISAM table. Is this possible ? If so how do I do it. >> >>>>> >> >>>>> in short: no >> >>>>> >> >>>>> in longer: >> >>>>> why in the world are you using the wrong engine if you need >> >>>>> fulltext-search? >> >>>>> mysql 5.6 semmes to start support this in innodb, but currently not >> >>>>> >> >>>>> replication is based on binlogs and contains database/table so there is >> >>>>> no dirty trick do this on one server except let run a script and copy >> >>>>> the table-contents per cronjob >> >>>>> >> >>>>> >> >>>> >> >>>> -- >> >>>> >> >>>> Mit besten GrüÃen, Reindl Harald >> >>>> the lounge interactive design GmbH >> >>>> A-1060 Vienna, Hofmühlgasse 17 >> >>>> CTO / software-development / cms-solutions >> >>>> p: +43 (1) 595 3999 33 <tel:%2B43%20%281%29%20595%203999%2033>, m: +43 >> >>>> (676) 40 221 40 >> >> <tel:%2B43%20%28676%29%2040%20221%2040> >> >>>> icq: 154546673, http://www.thelounge.net/ >> >>>> http://www.thelounge.net/signature.asc.what.htm >> >>>> >> >>>> >> >>> >> >> >> >> -- >> >> >> >> Mit besten GrüÃen, Reindl Harald >> >> the lounge interactive design GmbH >> >> A-1060 Vienna, Hofmühlgasse 17 >> >> CTO / software-development / cms-solutions >> >> p: +43 (1) 595 3999 33 <tel:%2B43%20%281%29%20595%203999%2033>, m: +43 >> >> (676) 40 221 40 >> >> <tel:%2B43%20%28676%29%2040%20221%2040> >> >> icq: 154546673, http://www.thelounge.net/ >> >> >> >> http://www.thelounge.net/signature.asc.what.htm >> >> >> >> >> > >> > -- >> > >> > Mit besten GrüÃen, Reindl Harald >> > the lounge interactive design GmbH >> > A-1060 Vienna, Hofmühlgasse 17 >> > CTO / software-development / cms-solutions >> > p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 >> > icq: 154546673, http://www.thelounge.net/ >> > >> > http://www.thelounge.net/signature.asc.what.htm >> > >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: http://lists.mysql.com/mysql?unsub=mo...@fastmail.fm > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=neil.tompk...@googlemail.com > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
