mmm. I have a couple doing the same, or similar, thing in two different high-volume tables. How are you finding the high perf mysql book - I was thinking about getting it?
excellent, I might go order it then. I'm spending lots of time on db scaling atm - have some larger customers coming online, so starting to see where our systems need tuning
11 comments so far
Inserting multiple rows with intersecting ranges? Using transactions?
1 year, 4 months ago by johndalton
a single insert to a single table, nothing else happening - don't think it's in a transaction
1 year, 4 months ago by silarsis
admittedly, about 30 inserts a second on that table, but that should be well within innodb's capabilities
1 year, 4 months ago by silarsis
it's locking on the index on the table, but I don't clearly understand the lock comments
1 year, 4 months ago by silarsis
not sure about the difference between lockmode X and lockmode X insert intention waiting
1 year, 4 months ago by silarsis
Me either. I was reading the new edition of High Performance MySQL over lunch, but currently trying to debug a memcache problem. :)
Still, deadlock under those circumstances does seem pretty weird.
1 year, 4 months ago by johndalton
mmm. I have a couple doing the same, or similar, thing in two different high-volume tables. How are you finding the high perf mysql book - I was thinking about getting it?
1 year, 4 months ago by silarsis
It's early days yet, but initial impressions are that it's excellent.
1 year, 4 months ago by johndalton
it's twice the size, up to date, and I'm finding the writing to be very clear and readable.
1 year, 4 months ago by johndalton
excellent, I might go order it then. I'm spending lots of time on db scaling atm - have some larger customers coming online, so starting to see where our systems need tuning
1 year, 4 months ago by silarsis
nothing like realworld load
1 year, 4 months ago by silarsis