140 reputation
15
bio website
location
age
visits member for 2 years, 6 months
seen Jul 10 '12 at 19:55

Jul
23
awarded  Notable Question
Nov
30
awarded  Popular Question
Jun
12
comment Random write freezes
Thanks so much for the in-depth answer. I'm in the process of changing the table to use an auto incrementing primary key instead. It sounds like that will fix the issue.
Jun
12
awarded  Supporter
Jun
12
accepted Random write freezes
Jun
1
comment Random write freezes
Thanks for the reply. I've added some examples.
Jun
1
revised Random write freezes
added 1615 characters in body
Jun
1
asked Random write freezes
Jan
12
awarded  Scholar
Jan
12
accepted Concurrent MySQL updates hang with InnoDB (on Amazon RDS)
Jan
12
comment Concurrent MySQL updates hang with InnoDB (on Amazon RDS)
Thanks so much for the in-depth answer! I have tried the temp table, and it just ends up taking far too long. However, the idea of doing it in batches is terrific. I'm going to give that a shot asap. Thanks!
Jan
9
awarded  Editor
Jan
9
revised Concurrent MySQL updates hang with InnoDB (on Amazon RDS)
added 135 characters in body; edited title
Jan
9
comment Concurrent MySQL updates hang with InnoDB (on Amazon RDS)
@AaronBrown Sorry about that, by ID I meant hash. For this particular table the primary key, hash, is a varchar(5).
Jan
9
awarded  Student
Jan
9
comment Concurrent MySQL updates hang with InnoDB (on Amazon RDS)
@AaronBrown The ID is indexed and views is an int(10). However, the sql statement may actual be views+'2' even though views is an int.
Jan
8
asked Concurrent MySQL updates hang with InnoDB (on Amazon RDS)