3 Common Rails + MySQL Mistakes

http://www.engineyard.com/blog/2011/3-common-rails-mysql-mistakes/

by mattyb • 15 years ago

6 2 15 years ago

Pooter• 15 years ago

None of these are Rails specific. Don't stick session data in a relational db if you can put it in memcache or someplace similar. Also, MySQL's query optimizer and execution engine suck (SQL server, DB2, Oracle, and PostgreSQL all handle in() queries with select statements just fine).

The select for update thing, though, sounds like a table type selection issue. Doesn't innodb handle locking at roughly row level (maybe db page)? Seems like that one is for people who stick with MyISAM. If you're doing concurrency sensitive stuff, pick a better storage engine (or more robust db).

ethangunderson• 15 years ago

The first item in the list really bugs me. It's not enough to just tell me not to do something, teach me why it's bad. That way, I can explain to others why this is a mistake instead of just regurgitating the same explanation of 'it's a performance disaster'.

3 Common Rails + MySQL Mistakes

Related Stories