Comments - When will transactional fulltext indexes be ready?
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
Thanks for the answer. Frequently updated fulltext indexes need to constantly acquire table locks, which is a problem.
To get around the issue we've created duplicated tables that are updated hourly and converted all other tables to InnoDB so that we can get row level locking. Ideally we'd like to get row level locking on updates of tables that have full text indexes.
We converted this weekend from the stock MySQL that comes with Centos 5 to MariaDB 5.2 series. So far so good - system is faster and uses less resources.
We will try converting our myisam fulltext tables to aria in the upcoming weeks. Its worth it for a crash safe system. And we'll be waiting for row level locking. Indeed, row level locking is more important than transactions. I dont know if that is the same for other clients, but we'd much rather see row or page locks.
BTW, our thanks for a great product. We appreciate the work you do, it makes a difference for us and we've come to rely on the technology.