Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
3 10
Impact
~11k people reached

  • 0 posts edited
  • 0 helpful flags
  • 6 votes cast
Dec
21
comment Improve `Update` performance (rows locking issue)
@Dtest wow!! thank you very much, updating performance is very fast now :) about 200 updates a second.. I followed your instruction and it work! :) I thought adding index on 'mobile' and 'status' would help the `UPDATE' to find the record quick but that was not the case hmmmmm. Thanks again.
Dec
21
awarded  Student
Dec
21
awarded  Commentator
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)