Page 1 of 1

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

Posted: Tue Dec 30, 2008 5:36 am
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

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

Posted: Wed Dec 31, 2008 3:26 pm
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?

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

Posted: Wed Dec 31, 2008 3:42 pm
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.

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

Posted: Wed Dec 31, 2008 6:48 pm
by John Cartwright
Interesting. I think I'll pick this up in the New Year.

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

Posted: Wed Dec 31, 2008 6:51 pm
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?

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

Posted: Wed Dec 31, 2008 6:57 pm
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)

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

Posted: Thu Jan 01, 2009 5:13 am
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...?

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

Posted: Thu Jan 01, 2009 8:10 am
by Eran
xparb is baron. Peter is the lead author on the MySQL performance blog

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

Posted: Thu Jan 01, 2009 2:10 pm
by jaoudestudios
Thanks :)

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

Posted: Thu Jan 01, 2009 3:36 pm
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?

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

Posted: Thu Jan 01, 2009 3:54 pm
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.

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

Posted: Thu Jan 01, 2009 3:57 pm
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 ;)

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

Posted: Fri Jan 02, 2009 6:09 am
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?

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

Posted: Fri Jan 02, 2009 7:20 am
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.