-
Notifications
You must be signed in to change notification settings - Fork 0
/
index.html
executable file
·347 lines (327 loc) · 14.6 KB
/
index.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta name="description" content="Learn to Build Fast, Reliable, Scalable Systems with MySQL">
<meta name="author" content="Baron Schwartz">
<link rel="shortcut icon" href="assets/ico/favicon.png">
<title>High Performance MySQL - Learn to Build Fast, Reliable, Scalable Systems with MySQL</title>
<!-- Bootstrap core CSS -->
<link href="assets/css/bootstrap.css" rel="stylesheet">
<!-- Custom styles for this template -->
<link href="assets/css/main.css" rel="stylesheet">
<link href='http://fonts.googleapis.com/css?family=Lato:300,400,700,300italic,400italic' rel='stylesheet' type='text/css'>
<link href='http://fonts.googleapis.com/css?family=Raleway:400,300,700' rel='stylesheet' type='text/css'>
<script src="assets/js/jquery.min.js"></script>
<script src="assets/js/smoothscroll.js"></script>
</head>
<body data-spy="scroll" data-offset="0" data-target="#navigation">
<!-- Fixed navbar -->
<div id="navigation" class="navbar navbar-default navbar-fixed-top">
<div class="container">
<div class="navbar-header">
<button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-collapse">
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
</div>
<div class="navbar-collapse collapse">
<ul class="nav navbar-nav">
<li class="active"><a href="#">Top</a></li>
<li><a href="#desc">More Details</a></li>
<li><a href="#downloads">Downloads and Samples</a></li>
<li><a href="#purchase">Purchase</a></li>
</ul>
</div><!--/.nav-collapse -->
</div>
</div>
<section id="home" name="home"></section>
<div id="headerwrap">
<div class="container">
<div class="row centered">
<div class="col-lg-12">
<h1>High Performance MySQL</h1>
<h3>Learn to Build Fast, Reliable, Scalable Systems with MySQL</h3>
<br>
</div>
<div class="col-lg-12">
<img class="img-responsive" src="assets/img/hpm-cover-perspective.png" alt="">
</div>
</div>
</div> <!--/ .container -->
</div><!--/ #headerwrap -->
<section id="desc" name="desc"></section>
<!-- INTRO WRAP -->
<div id="intro">
<div class="container">
<div class="row centered">
<h1>The Best MySQL Book On The Planet</h1>
<br>
<br>
<div class="col-lg-4">
<img src="assets/img/compass.png" width="128" height="128" alt="">
<h3>The Definitive Guide</h3>
<p><a href="http://www.amazon.com/High-Performance-MySQL-Optimization-Replication/dp/1449314287/?tag=xaprb-20">High
Performance MySQL, 3rd Edition</a> is the definitive guide for
building fast, reliable systems with MySQL. The authors are
noted experts in the field, with years of real-world experience
building very large systems.
You’ll get detailed guidance on tuning your
MySQL server, operating system, and hardware to their fullest
potential. And you’ll learn practical, safe, high-performance
ways to scale your applications with replication, load balancing,
high availability, and failover. </p>
</div>
<div class="col-lg-4">
<img src="assets/img/quote.png" alt="">
<h3>Praised By Experts</h3>
<p>High Performance MySQL teaches
techniques in-depth, in clear and lucid writing, to help
you tap into MySQL’s full power. You'll learn how to design
schemas, indexes, queries, and advanced MySQL features for
maximum performance.
That's why noted MySQL expert Eric Bergen
<a href="http://ebergen.net/wordpress/2010/07/20/how-to-be-a-mysql-dba-and-the-best-mysql-book-on-the-planet/">says</a>
it's “the best MySQL book on the planet,” and another reviewer
calls it “one of the best tech books I’ve ever read.” Reviewers on
<a href="http://www.amazon.com/High-Performance-MySQL-Optimization-Replication/dp/1449314287/?tag=xaprb-20">Amazon</a>
agree it's the best MySQL book in print.
</div>
<div class="col-lg-4">
<img src="assets/img/expand.png" width="128" height="128" alt="">
<h3>Revised and Expanded</h3>
<p>The third edition is completely revised and greatly expanded,
with over 800 pages. There are many new topics and deeper
coverage in all areas. A notable improvement over the second
edition is a systematic, logical approach to performance
throughout.
The book also includes chapters
on benchmarking, profiling, backups, security, and tools and
techniques to help you measure, monitor, and manage your MySQL
installations. Click here to
<a href="#downloads">read a sample chapter</a>.</p>
</div>
</div>
<br>
<hr>
</div> <!--/ .container -->
</div><!--/ #introwrap -->
<section id="desc" name="desc"></section>
<!-- INTRO WRAP -->
<div id="authors">
<div class="container">
<div class="row centered">
<h1>Written By Trusted Experts</h1>
<br>
<br>
<div class="col-lg-4">
<img src="assets/img/baron.jpg" width="128" height="128" alt="">
<h3>Baron Schwartz</h3>
<p>Baron is the founder and CEO of <a
href="https://vividcortex.com/">VividCortex</a>, a SaaS
platform for database performance monitoring. Formerly the VP of
Consulting at Percona, he has extensive background in MySQL
performance in the real world. He is the author of
several books and many open-source projects. He speaks frequently
on system performance, open source, DevOps, and team optimization
at universities, major companies, and industry conferences. He's
also an Oracle ACE and frequent participant in the PostgreSQL
community.</p>
</div>
<div class="col-lg-4">
<img src="assets/img/peter.jpg" width="128" height="128" alt="">
<h3>Peter Zaitsev</h3>
<p>Peter is the Chief Executive Officer at <a href="http://www.percona.com/">Percona</a>. Peter was an early
employee at MySQL AB, eventually leading the company’s High
Performance Group. A serial entrepreneur, Peter co-founded his
first startup while attending Moscow State University where he
majored in Computer Science. He specializes in helping
companies fix issues with high-traffic applications
dealing with terabytes of data, using hundreds of
servers. He speaks frequently at conferences.</p>
</div>
<div class="col-lg-4">
<img src="assets/img/vadim.jpg" width="128" height="128" alt="">
<h3>Vadim Tkachenko</h3>
<p>Vadim leads <a href="http://www.percona.com/">Percona</a>'s Development group which produces
Percona Server, Percona XtraDB, and Percona XtraBackup. He is an
expert in LAMP performance, especially optimizing MySQL and
InnoDB internals to take full advantage of modern hardware using
his multi-threaded programming background. Source code patches
authored by Vadim have been incorporated by Oracle Corporation
and its predecessors into the mainstream MySQL and InnoDB
products.</p>
</div>
</div>
<br>
<hr>
</div> <!--/ .container -->
</div><!--/ #introwrap -->
<section id="downloads" name="downloads"></section>
<div id="downloads">
<div class="container">
<div class="row centered">
<h1 class="centered">Downloads and Samples</h1>
<br>
<div class="col-lg-4">
<a href="/high-performance-mysql-3rd-edition-sample.pdf"><img src="assets/img/hpm-cover-perspective.png" width="253" height="184" alt=""></a>
<h3>Sample Chapter</h3>
<p>O'Reilly authorized us to post a sample chapter for you to
preview. Please enjoy<a
href="/high-performance-mysql-3rd-edition-sample.pdf"> Chapter
8, Optimizing Server Settings</a>. This chapter includes the
table of contents. O'Reilly has also <a
href="http://shop.oreilly.com/product/0636920022343.do">posted
a sample on their website</a>, so you can read
<em>two</em> sample chapters.
<br>
<br>
Errata are available at the <a
href="http://oreilly.com/catalog/9780596101718/">O'Reilly
catalog page</a>.</p>
</div>
<div class="col-lg-4">
<img src="assets/img/code.png" width="184" heigh="184" alt="">
<h3>Code Samples</h3>
<p>We've also posted code samples from the 3rd edition of High
Performance MySQL. One-liner and once-off scripts are not shown
here, but generally reusable scripts and queries are, if they're
long enough that it's harder to type them than to look them up on
this page. If you'd like a particular sample to be added, please
contact us and we'll add it for you.
</div>
<div class="col-lg-4 text-left">
Chapter 2
<ul>
<li><a href="https://gist.github.com/xaprb/311cb005cd55678627ae">Page 44: gather.sh</a></li>
<li><a href="https://gist.github.com/xaprb/f400f5db43830a1ac2bd">Page 48: analyze.sh</a></li>
</ul>
Chapter 3
<ul>
<li><a href="https://gist.github.com/xaprb/7a012d5be64c1285942c">Page 83: show_profiles.sql</a></li>
<li><a href="https://gist.github.com/xaprb/bce5cd6dffc877f28c8b">Page 93: qtt.sh</a></li>
</ul>
Chapter 7
<ul>
<li><a href="https://gist.github.com/xaprb/f1695009025bca103087">Page 281: view_source.sql</a></li>
<li><a href="https://gist.github.com/xaprb/bbfc9142d9c7476c47bb">Various pages: routines.sql</a></li>
<li><a href="https://gist.github.com/xaprb/8cdb8d3f3cee9c021ae1">Page 296: now_usec.c</a></li>
<li><a href="https://gist.github.com/xaprb/18c5b9d70a21d531acd0">Various pages: fts.sql</a></li>
</ul>
Chapter 8
<ul>
<li><a href="https://gist.github.com/xaprb/16d14584bb5afb6bc140">Page 343: my.cnf</a></li>
</ul>
Appendix B
<ul>
<li><a href="https://gist.github.com/xaprb/2ce5e3f1f4272d0c6e48">Page 687: mext.sql</a></li>
</ul>
Appendix D
<ul>
<li><a href="https://gist.github.com/xaprb/a9daa2bd0fe7beca1265">Page 726: explain.sql</a></li>
</ul>
Appendix E
<ul>
<li><a href="https://gist.github.com/xaprb/f9cd937967fde1add562">Page 743: locks.sql</a></li>
</ul>
</div>
</div>
<div class="row">
<hr>
<h1 class="centered">Foreword by Mark Callaghan</h1>
<br>
<div class="col-lg-2"> </div>
<div class="col-lg-8">
<p>I’ve been a fan of this book for years, and the third edition
makes a great book even better. Not only do world-class experts
share that expertise, but they have taken the time to update and
add chapters with high-quality writing. While the book has many
details on getting high performance from MySQL, the focus of the
book is on the process of improvement rather than facts and
trivia. This book will help you figure out how to make things
better, regardless of changes in MySQL’s behavior over time.</p>
<p>The authors are uniquely qualified to write this book, based on
their experience, principled approach, focus on efficiency, and
commitment to improvement. By <em>experience</em>, I mean that the
authors have been working on MySQL performance from the days when
it didn’t scale and had no instrumentation to the current period
where things are much better. By <em>principled approach</em>, I mean that
they treat this like a science, first defining problems to be
solved and then using reason and measurement to solve those
problems.</p>
<p>I am most impressed by their focus on <em>efficiency</em>. As consultants,
they don’t have the luxury of time. Clients getting billed by the
hour want problems solved quickly. So the authors have defined
processes and built tools to get things done correctly and efficiently. They describe the processes in this book and publish
source code for the tools.</p>
<p>Finally, they continue to get better at what they do. This
includes a shift in concern from throughput to response time, a
commitment to understanding the performance of MySQL on new
hardware, and a pursuit of new skills like queueing theory that
can be used to understand performance.</p>
<p>I believe this book augurs a bright future for MySQL. As MySQL
has evolved to support demanding workloads, the authors have led
a similar effort to improve the understanding of MySQL
performance within the community. They have also contributed
directly to that improvement via XtraDB and XtraBackup. I
continue to learn from them and hope you take the time to do so
as well.</p>
<p class="text-right">— <a href="http://smalldatum.blogspot.com/">Mark Callaghan</a>, Software Engineer, Facebook</p>
</div>
<div class="col-lg-2"> </div>
<br>
</div><!-- /container -->
</div>
<section id="purchase" name="purchase"></section>
<div>
<div class="container">
<div class="row">
<div class="col-lg-12">
<hr>
<h1 class="centered">Purchase</h1>
<p>You can buy the book <a
href="http://www.amazon.com/High-Performance-MySQL-Optimization-Replication/dp/1449314287/?tag=xaprb-20">from
Amazon</a>. Be careful not to buy the first or second edition;
Amazon doesn’t make the distinction very clear. All the links on this site
go to the third edition. You can also order the book from
<a href="http://shop.oreilly.com/product/0636920022343.do">O’Reilly’s
website</a>.</p>
</div>
</div>
<div class="row">
<div class="col-lg-6 centered">
<a href="http://www.amazon.com/High-Performance-MySQL-Optimization-Replication/dp/1449314287/?tag=xaprb-20" class="btn btn-primary btn-lg" role="button">Purchase From Amazon</a>
<br> <br>
</div>
<div class="col-lg-6 centered">
<a href="http://shop.oreilly.com/product/0636920022343.do" role="button" class="btn btn-primary btn-lg">Purchase From O'Reilly</a>
<br> <br>
</div>
</div>
<div class="row">
<div class="col-lg-12">
<br> <br>
<br> <br>
</div>
</div>
</div>
</div>
<div id="footerwrap"> </div>
<div id="c">
<div class="container">
<p>Theme by <a href="http://www.blacktie.co">BLACKTIE.CO</a></p>
</div>
</div>
<!-- Bootstrap core JavaScript
================================================== -->
<!-- Placed at the end of the document so the pages load faster -->
<script src="assets/js/bootstrap.js"></script>
<script>
$('.carousel').carousel({
interval: 3500
})
</script>
</body>
</html>