Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Roger Felstree
June 9, 2007, 10:22 pm
rate this thread
I'm using MySQL v5.0 and we currently have a database containing several
tables with Full Text indexes. Some of these tables contain ~800,000 records
of >500Kb text. While the majority of queries are selects - when we need to
do Inserts to these tables they are becoming horrendously slow.
If I set up an additional server - is it possible to set up a replication
partnership so that the fulltext index is only present on the slave? i.e.
updates are carried out on the master with no fulltext index - and then
replicated to the slave with the fulltext index for end users to query?
Any advice / pointers would be much appreciated!
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum