Slucajno sam danas naleteo na sledeci text
Citat:
We used to use MyISAM for fulltext, duplicating the data in the InnoDB master table. Once the query rate grew sufficiently high and the data size grew past a gigabyte or so it became completely unacceptable on performance grounds, taking more than half of our database server capacity and still not working well. We abandoned it and switched to Lucene. By that point we were in the top thousand sites on the net, so it had survived pretty well.
I'm also as MySQL Support Engineer but these views are from my Wikipedia role, not the MySQL one.
James Day
|
ostatak texta (innoDB vs myisam)
http://mysqldatabaseadministration.b...reference.html