282 reputation
314
bio website
location Cedar Rapids, IA
age 34
visits member for 2 years, 7 months
seen 2 days ago

I have been a code monkey since 1994, though until 1998 that was entirely mIRC scripting. :) Since then it's been ColdFusion, then PHP.


Jul
2
awarded  Curious
Jun
24
awarded  Popular Question
May
27
awarded  Notable Question
Jan
7
awarded  Popular Question
Oct
1
awarded  Notable Question
Sep
16
accepted Easily, quickly replace MySQL table?
Sep
13
asked Easily, quickly replace MySQL table?
Jul
16
asked INT or TIMESTAMP for the change time column in a logging table?
Apr
6
awarded  Popular Question
Apr
2
awarded  Tumbleweed
Mar
11
awarded  Popular Question
Jan
25
awarded  Popular Question
Jan
9
awarded  Yearling
Sep
28
comment Some queries slower in MySQL 5.5 than 5.0?
Well ... the thing is, I don't mind if the slaves lose a second of replication, we can resync them if necessary. But it was really, REALLY slowing them down. But we're upgrading the master this weekend and I'm going to keep sync_binlog at 0 because we simply can't have that kind of slowdown. Any idea WHY we would have that kind of slowdown? If it's a widespread thing then you'd think there'd be remedies, but if it's just us then I don't know why.
Sep
28
revised Some queries slower in MySQL 5.5 than 5.0?
added 83 characters in body
Sep
28
accepted Distribute MySQL in different cities?
Sep
28
asked How do triggers affect last_insert_id()?
Sep
22
awarded  Teacher
Aug
17
accepted When to switch from MyISAM to InnoDB?
Aug
17
comment When to switch from MyISAM to InnoDB?
Thank you, though this doesn't quite answer my question. I KNOW I want InnoDB. I'm asking if it makes sense to convert to it while still on 5.0, rather than my original plan of waiting until 5.5, since, on 5.0, presumably MyISAM is faster than InnoDB.