We have a PHP app running many dynamic queries. I’m not saying they are the best, but for now it’s what we live with. There are 3 scenarios of > 1000 row updates. We are looking at going to Percona XTraDB cluster
- Insert/Update where ID in (CDL of 1000+ IDs)
- Insert Into (SELECT blah more than 1000 rows)
- Delete LOG Where Date < ‘11-22-2013’
Is there a preferred method of handling the different scenarios?
Further, how set is the 1000 row limit. This is a small set of our transactions (200 a day). Most of these are in the 2000-3000 affected rows.