194 reputation
19
bio website
location
age
visits member for 3 years
seen Nov 13 at 16:43

Dec
21
comment Improve `Update` performance (rows locking issue)
Thanks I will read more updated advice now.. I've just dropped 'status' index and ran the scripts again - it did not improve the UPDATE performance.. still a lot of queues in the mysqladmin proc. I have just updated my question with iostat, please check if that causing problem?
Dec
21
revised Improve `Update` performance (rows locking issue)
added 936 characters in body
Dec
21
comment Improve `Update` performance (rows locking issue)
I am sorry, I meant status - yes I understand what Primary key does.
Dec
21
comment Improve `Update` performance (rows locking issue)
Would primary key take advantage over number ?
Dec
21
revised Improve `Update` performance (rows locking issue)
added 597 characters in body
Dec
21
revised Improve `Update` performance (rows locking issue)
added 10 characters in body
Dec
21
comment Improve `Update` performance (rows locking issue)
@ypercube it check if the number is valid or invalid from externally (API). If there is an error then return into $error but this is not an issue.
Dec
21
comment Improve `Update` performance (rows locking issue)
@ypercube I have updated my question, how its generated. That is good ideas about grouping but there will be like 10 different type of error texts... and also without error. How can that be archived?
Dec
21
awarded  Editor
Dec
21
revised Improve `Update` performance (rows locking issue)
added 1404 characters in body
Dec
21
asked Improve `Update` performance (rows locking issue)