Book :: High performance MySQL, O'Reilly 2nd Edition
Moderator: General Moderators
- jaoudestudios
- DevNet Resident
- Posts: 1483
- Joined: Wed Jun 18, 2008 8:32 am
- Location: Surrey
Book :: High performance MySQL, O'Reilly 2nd Edition
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
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
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
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.
- 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
Interesting. I think I'll pick this up in the New Year.
- jaoudestudios
- DevNet Resident
- Posts: 1483
- Joined: Wed Jun 18, 2008 8:32 am
- Location: Surrey
Re: Book :: High performance MySQL, O'Reilly 2nd Edition
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.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?
What is the link to your blog/website?pytrin wrote:outside of your blog
Re: Book :: High performance MySQL, O'Reilly 2nd Edition
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)
http://www.xaprb.com/blog/
http://www.mysqlperformanceblog.com/ (authors on this blog are also co-authors of the MySQL high performance book)
- jaoudestudios
- DevNet Resident
- Posts: 1483
- Joined: Wed Jun 18, 2008 8:32 am
- Location: Surrey
Re: Book :: High performance MySQL, O'Reilly 2nd Edition
Cheers!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)
Which author? There are 6. Baron, Peter...?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?
Re: Book :: High performance MySQL, O'Reilly 2nd Edition
xparb is baron. Peter is the lead author on the MySQL performance blog
- jaoudestudios
- DevNet Resident
- Posts: 1483
- Joined: Wed Jun 18, 2008 8:32 am
- Location: Surrey
Re: Book :: High performance MySQL, O'Reilly 2nd Edition
What suggestions do you have?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.
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
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
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 
- jaoudestudios
- DevNet Resident
- Posts: 1483
- Joined: Wed Jun 18, 2008 8:32 am
- Location: Surrey
Re: Book :: High performance MySQL, O'Reilly 2nd Edition
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?
I will keep an eye on your websites too. I am planning to have a look through your tools on your website this weekend
Re: Book :: High performance MySQL, O'Reilly 2nd Edition
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.