View Single Post
  #1   (View Single Post)  
Old 16th August 2010
Carpetsmoker's Avatar
Carpetsmoker Carpetsmoker is offline
Real Name: Martin
Tcpdump Spy
 
Join Date: Apr 2008
Location: Netherlands
Posts: 2,243
Default MySQL book recommendations

For my current job I need to do MySQL work -- Both designing new stuff and optimizing existing stuff, some operations take up to a minute to complete and stuff I'm writing at the moment might take even longer!
The tables have no keys or have keys that are never used, most columns are TEXT columns, and I suspect the queries in the code could be a lot better too.
I know enough about MySQL to know this, but to be honest I lack the in-depth experience/knowledge to fix this properly once and for all.

There are more pressing/urgent matter to be done at the moment, so I have a few weeks to brush up my MySQL.

Can anyone recommend a good book? I'm looking for something that will at least do a good (indepth) explanation of the basics (preferably while maintaining brevity and being to the point -- I am not an idiot).
__________________
UNIX was not designed to stop you from doing stupid things, because that would also stop you from doing clever things.
Reply With Quote