I've now just upgraded to MySQL 5.6 on our test server. Just trying to find a date as to when it will go into production
On Thu, Sep 29, 2011 at 8:10 PM, 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<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<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<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<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.tompkins@** > googlemail.com<http://lists.mysql.com/mysql?unsub=neil.tompk...@googlemail.com> > >