CODEWITHSUNDEEP
mysqlperconatokudb
the_root
the_root

Reputation: 339

INSERT ... ON DUPLICATE KEY UPDATE Database / Engine

I'm currently writing a PHP application that processes large amounts of data and writes them to MySQL. I use Percona MySQL with TokuDB engine but it is difficult to handle. The application currently makes about 400 - 800 inserts / updates per second based on the "INSERT ... ON DUPLICATE KEY UPDATE" query. In the beginning it wasn't able to proceed all these data in-time, so I had to move my Database LOG files to Ramdisk and it is working fine now, but if the amount of data increases slightly - it will not be able to process everything. So I'm wondering - is there a solution other than MySQL ( or even MySQL somehow ) that is compatible with PHP and allows about 1000 inserts / updates per second and support simple queries like "SELECT * FROM fasterDB.fasterTABLE WHERE a = 1 AND b = 2". And also, to allow ~800 selects / per second.

As far as I understand, TokuDB will soon have a new official release that will have a "noar" which will do much faster "INSERT ... ON DUPLICATE KEY UPDATE" but it's still unclear - when it will be available for CentOS7 :-(

Upvotes: 0

Views: 186

Answers (0)

Related Questions