I’m currently trying to update a realtime index, the whole index is around 8.000.000 records, but i’m updating 600.000 record of it. This update proces takes forever to complete. Its already running like 6 hours and its still not done. Is there something wrong in my configuration? The server has plenty of resources (more then enough RAM and CPU) and plain indexes are indexed very fast. I’m running manticore 4.2
I’m updating the date trough SQL like this:
begin;
UPDATE [indexname] SET column1 = 12345 WHERE id = 123;
UPDATE [indexname] SET column1 = 12345 WHERE id = 456;
UPDATE [indexname] SET column1 = 12345 WHERE id = 789;
commit;
I collect all 600.000 queries and sent them to manticore as one command.
I’m using PHP to connect to Manticore with PDO:
snikolaev@dev:~$ (for id in `seq 200000 800000`; do echo "UPDATE example SET column1 = 12345 WHERE id = $id;"; done;) > /tmp/sql
snikolaev@dev:~$ time mysql -P9315 -h0 < /tmp/sql
real 0m38.018s
user 0m1.152s
sys 0m6.063s
Thank you for you’re response and for testing it, didn’t know you can test it that way. I’ve removed the transaction code and find out that the problem was in my PHP code, because when running the way you tested it, it was updated within seconds. So it isn’t a manticore problem but an other problem.