Book :: High performance MySQL, O'Reilly 2nd Edition

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
jaoudestudios
DevNet Resident
Posts: 1483
Joined: Wed Jun 18, 2008 8:32 am
Location: Surrey

Book :: High performance MySQL, O'Reilly 2nd Edition

Post by jaoudestudios »

This book covers mysql optimisation and how to improve your queries etc.

If you deal with medium to large databases or want to reduce the load on your server by making your database as efficient as possible. This book is worth every penny!

It covers many other areas too, like differences between various engines. New engines coming out - that seem very impressive too!

I give it 4.8/5
xaprb
Forum Newbie
Posts: 4
Joined: Wed Dec 31, 2008 3:25 pm

Re: Book :: High performance MySQL, O'Reilly 2nd Edition

Post by xaprb »

I'm the lead author. Curious to hear whether others have read it and what they think about it. Anything to improve or add?
User avatar
Eran
DevNet Master
Posts: 3549
Joined: Fri Jan 18, 2008 12:36 am
Location: Israel, ME

Re: Book :: High performance MySQL, O'Reilly 2nd Edition

Post by Eran »

I read it and keep it as my most valued MySQL resource (outside of your blog and the MySQL performance blog). I would like a little more information on scaling options, but that's just me and might be outside the scope of a book focused on MySQL.
User avatar
John Cartwright
Site Admin
Posts: 11470
Joined: Tue Dec 23, 2003 2:10 am
Location: Toronto
Contact:

Re: Book :: High performance MySQL, O'Reilly 2nd Edition

Post by John Cartwright »

Interesting. I think I'll pick this up in the New Year.
User avatar
jaoudestudios
DevNet Resident
Posts: 1483
Joined: Wed Jun 18, 2008 8:32 am
Location: Surrey

Re: Book :: High performance MySQL, O'Reilly 2nd Edition

Post by jaoudestudios »

xaprb wrote:I'm the lead author. Curious to hear whether others have read it and what they think about it. Anything to improve or add?
No way!?!? Seriously? I do have some suggestions as I feel you went into depth in places that I thought were too basic and glossed over other areas that I would have liked to seen more details - but this could just be my personal preference.
pytrin wrote:outside of your blog
What is the link to your blog/website?
User avatar
Eran
DevNet Master
Posts: 3549
Joined: Fri Jan 18, 2008 12:36 am
Location: Israel, ME

Re: Book :: High performance MySQL, O'Reilly 2nd Edition

Post by Eran »

Most valuable MySQL online resources outside of the manual -
http://www.xaprb.com/blog/
http://www.mysqlperformanceblog.com/ (authors on this blog are also co-authors of the MySQL high performance book)
User avatar
jaoudestudios
DevNet Resident
Posts: 1483
Joined: Wed Jun 18, 2008 8:32 am
Location: Surrey

Re: Book :: High performance MySQL, O'Reilly 2nd Edition

Post by jaoudestudios »

pytrin wrote:Most valuable MySQL online resources outside of the manual -
http://www.xaprb.com/blog/
http://www.mysqlperformanceblog.com/ (authors on this blog are also co-authors of the MySQL high performance book)
Cheers! :D and Happy New Year! Is this the Year Linux takes over Microsoft? (that discussion is probably for another time :) )
xaprb wrote:I'm the lead author. Curious to hear whether others have read it and what they think about it. Anything to improve or add?
Which author? There are 6. Baron, Peter...?
User avatar
Eran
DevNet Master
Posts: 3549
Joined: Fri Jan 18, 2008 12:36 am
Location: Israel, ME

Re: Book :: High performance MySQL, O'Reilly 2nd Edition

Post by Eran »

xparb is baron. Peter is the lead author on the MySQL performance blog
User avatar
jaoudestudios
DevNet Resident
Posts: 1483
Joined: Wed Jun 18, 2008 8:32 am
Location: Surrey

Re: Book :: High performance MySQL, O'Reilly 2nd Edition

Post by jaoudestudios »

Thanks :)
xaprb
Forum Newbie
Posts: 4
Joined: Wed Dec 31, 2008 3:25 pm

Re: Book :: High performance MySQL, O'Reilly 2nd Edition

Post by xaprb »

jaoudestudios wrote:I do have some suggestions as I feel you went into depth in places that I thought were too basic and glossed over other areas that I would have liked to seen more details - but this could just be my personal preference.
What suggestions do you have?

We did not have complete freedom; anything that was in the first edition had to stay, and I wanted to cut some of it out.

Where do you want more details?
User avatar
Eran
DevNet Master
Posts: 3549
Joined: Fri Jan 18, 2008 12:36 am
Location: Israel, ME

Re: Book :: High performance MySQL, O'Reilly 2nd Edition

Post by Eran »

A particular subject that is often a problem and I haven't found much details on, is versioning database schema. While source-code has very good versioning tools (such as SVN), pushing schema updates from a local development server to staging and to other development nodes is painful task that often has to be done manually. If you could add a chapter on tools available and technique to use, that would be great.
xaprb
Forum Newbie
Posts: 4
Joined: Wed Dec 31, 2008 3:25 pm

Re: Book :: High performance MySQL, O'Reilly 2nd Edition

Post by xaprb »

I just had an onsite client ask me about that, too. This is a good idea. Keep posting ideas. I have noted the URL of this forum thread in my TODO in case my wife ever lets me do a 3rd edition ;)
User avatar
jaoudestudios
DevNet Resident
Posts: 1483
Joined: Wed Jun 18, 2008 8:32 am
Location: Surrey

Re: Book :: High performance MySQL, O'Reilly 2nd Edition

Post by jaoudestudios »

I am only half way through the book, but I will let you know any suggestions I come up with :)

I will keep an eye on your websites too. I am planning to have a look through your tools on your website this weekend :). Any in particular you would recommend or is there a particular one to start with?
xaprb
Forum Newbie
Posts: 4
Joined: Wed Dec 31, 2008 3:25 pm

Re: Book :: High performance MySQL, O'Reilly 2nd Edition

Post by xaprb »

Nothing particular, it just depends on what you're trying to do. If you use replication I'd look at mk-table-checksum for verifying it. If you're trying to get better performance I'd install a Percona patched build, set the slow log time to 0, let it log for a while and use mk-log-parser to see what your most expensive queries are.
Post Reply