MySQL. Оптимизация производительности (2-е издание) - 2010

  • Published on
    15-Jun-2015

  • View
    5.056

  • Download
    5

Embed Size (px)

DESCRIPTION

, http://www.slideshare.net/wavedocs/ , ( ). . . - , , , . , ,

Transcript

<ul><li> 1. (1,1) -1- high_perf_mysq.indd 20.04.2010 12:36:20 , ,2- MySQL. 5.1 , - , , MySQL MySQL. , . , . , - . MySQL, - . -, . , , . : , , InnoDB , MySQL 5.0 5.1, -MySQL , , MySQL , , , , , , , , , - MySQL. MySQL, - , - , - MySQL, ., , , MySQL, : , , : -ISBN 978-5-93286-153-0 (812) 324-5353, (495) 945-8100 , , , ,9 785932 861530 www.symbol.ru , high_perf_mysq.indd 120.04.2010 12:36:20</li></ul><p> 2. - - Books.Ru ISBN 978-5-93286-153-0, MySQL. , 2- - Books.Ru . - , . , - (piracy@symbol.ru), . 3. High PerformanceMySQLSecond EditionBaron Schwartz, Peter Zaitsev, Vadim Tkachenko,Jeremy D. Zawodny, Arjen Lentz,Derek J. Balling 4. MySQL , , , . , , . - 2010 5. , , , . , , . MySQL. , 2- . . . . . . . . . ., ., ., ., ., .MySQL. , 2- . . . .:-, 2010. 832., .ISBN 978-5-93286-153-0 - , MySQL. , - . , - . - MySQL, . - , . , - , . , , MySQL.ISBN 978-5-93286-153-0ISBN 978-0-596-10171-8 () -, 2010Authorized translation of the English edition 2008 OReilly Media Inc. This translation is pub ished and sold by permission of OReilly Media Inc., the owner of all rights lto publish and sell the same. , . , , .-.199034,-,16,7, .(812) 324-5353, www.symbol.ru. N 000054 25.12.98. 005-93, 2; 953000 . 15.04.2010. 70100 1/16. . 52 .. 1500 . 199034, -, 9 , 12. 6. ................................................................................. 9..................................................................................... 101. MySQL .................................................................. 23 MySQL .................................................. 24 ............................................ 26............................................................................... 29Multiversion Concurrency Control (MVCC) . .................................... 37. MySQL....................................................39 2. : ...... 60 ?. .......................... 61 . . ............................................ 62 . ................................................66 ......................................... 72 ............................................... 76. ...................................................................... 86. ..................................... 112 3. ................................... 116 ............................................. 117 ........................................................... 135 ..................................................... 147 ..................................... 176 ............................................... 182 .............................................. 186 ALTER TABLE. ................................ 193. ............................................ 197 4. ........................................................... 200 : ....... 200 . ......................................... 206. .................................. 209 MySQL. ........................................... 232. 7. 6 ................................... 242 ............................................. 250 , . ................................ 253. 5. MySQL............................................ 261 MySQL................................................................ 261 MySQL.................................................... 275................................................................................. 284 ......................................................... 285 ....................................... 290........................................................................ 292 .............................................. 299 ............................................................. 307 . .................................................. 317 . ................................. 318 (XA) .............................................. 329 6. .......................................... 332 ........................................................ 333 ...................................................... 339 / MySQL.............................................. 351 MySQL................................. 368 ......................................... 372 ................................... 379 7. ............ 381 MySQL?............................ 382 MySQL........................................... 382 ................................... 386 ............................ 396 RAID..................... 396 .......... 406 ................................ 408 .................................................................. 410 .................................................... 413 .......................................................... 414 ..................................................................... 417 .................................................................................. 418 .............................................. 420 8. ............................................................................ 427 .................................................................... 427 ............................................................. 432 .................................................. 441 8. 7 ............................................................. 449 ................... 466 ........................ 469 .......................................... 480 ?.................................... 501 MySQL............................................ 5049. ............................... 506 ......................................................................... 507 MySQL. ........................................................ 509 . ......................................................... 539 ................................................................ 55210. ..................................... 564 ..................... 564 -. ............................................................. 568.. ......................................................................... 572. MySQL.................................................................. 579 MySQL............................................................... 58111. .............................. 582. .................................................................................... 583 . .............................................. 589 ................................ 600 .................................................. 603 ............................................ 616 ..................... 628 ........................................ 629 ............................................. 63812. ......................................................................... 642......................................................................... 642 ........................................................... 643 ............................ 665 ...................................................... 666 ................................................................ 675MySQL ............... 68013. MySQL...................................................... 682 ............................................................. 682 SHOW STATUS........................................................... 683 SHOW INNODB STATUS.............................................. 691 SHOW PROCESSLIST................................................... 707 SHOW MUTEX STATUS............................................... 708 9. 8 . ............................................................ 709. INFORMATION_SCHEMA....................................... 710 14. ............. 712 .............................................. 712 ........................................................ 715 ............................................................... 727 MySQL...................................................................... 730 .................................... 733 A. ..................................................... 734 B. EXPLAIN.................................................................... 739 . Sphinx MySQL................................ 756 D. ............................................................... 788 . ............................................................. 799 . 10. , . -, MySQL , . , , - MySQL. , , . , , , MySQL , . - , -, . , MySQL, - , . MySQL, - - , , MySQL, . 2008 11. . - MySQL, , . MySQL. , SQL. , - , ... ..., . , , - , MySQL. , MySQL - , - ?. , - MySQL, - , , - . , - MySQL, , - MySQL. , , - UNIX. , , . , : MySQL , , -, . MySQL , MySQL - . MySQL 1. 1 , , - , . 12. 11, , - , . , . , , , MySQL , . -, MySQL . - MySQL, - . . - , . 1 MySQL , - , . - MySQL, , . MySQL - . , . - MySQL, - , Oracle. , MySQL. 2 : - - . , , .. , - , . , - , - , -, . 3 - , . MySQL - , , - , , 13. 12 . - MySQL, - , , . 4 , MySQL - . , , . ( - ; , .) , - MySQL , , . , , - . 5 MySQL , - MySQL. , ,, . MySQL -, , , - , , . , , - MySQL. 6 , - MySQL, - -. 7 , , , . - , - . . 8 - , . , , 9, - 14. 13, - . , - MySQL. - . , , - MySQL. 10 - - , -. , - , , . 11 - - MySQL. , - . 12 - MySQL. , - , - . - , - . - - . -, , , . 13 MySQL , - MySQL. , . , . SHOW INNODBSTATUS, , - InnoDB. 14 - , - MySQL. - , , , .. 15. 14 Maatkit, MySQL - . - innotop, - , MySQL. UNIX top - , , - MySQL . A , - , . B - EXPLAIN , EXPLAIN. C Sphinx MySQL Sphinx, MySQL. , D - , , - . MySQL . - , MySQL. - , MySQL 4.1 5.0 - -. , -, . MySQL 5.1 6.0 (MySQL 5.1-, 6.0 -). - , MySQL -. MySQL 5.0, - . , - MySQL 5.0, MySQL 5.0.40 . -, 5.1. MySQL. , - , - (http://dev.mysql.com/doc/). MySQL , - : Mac OS X, Windows, 16. 15GNU/Linux, Solaris, FreeBSD ! GNU/Linux1 UNIX- . Windows, , . , - . - UNIX , - Windows2. MySQL Windows - Perl . MySQL , - Perl, - Perl-, -, . Maatkit Perl. , Perl Windows ActiveState - (DBI DBD::mysql) MySQL. : , URL, - , , , , , UNIX. , , , , - , , . , . - . , , - .1 Linux, , GNU/Linux, , .2 UNIX- Windows http://unxutils.sourceforge.net http://gnuwin32.sourceforge.net. 17. 16 , - . . . - - . -, . , , - . - -. . - , . http://www.highperfmysql.com, . MySQL. , , -. , , - ISBN, : High Performance MySQL: Optimization,Backups, Replication, and More, Second Edition, by Baron Schwartz et al.Copyright 2008 OReilly Media, Inc., 9780596101718. , , , permissions@oreilly.com. Safari - Safari Enabled, , Safari OReilly.Safari . , - , , . http://safari.oreilly.com. 18. 17 -: OReilly Media, Inc. 1005 Gravenstein Highway North Sebastopol, CA 95472 800-998-9938 ( ) 707-829-0515 ( ) 707-829-0104 () -, , -. : http://www.oreilly.com/catalog/9780596101718/ : bookquestions@oreilly.com , , - OReilly Network : http://www.oreilly.com . - http://www.xaprb.com. : http://www. mysqlperformanceblog.com http://www.webscalingblog.com. , Percona, http://www.percona.com. , OpenQuery, http://openquery.com.au. http://arjen-lentz.livejournal.com http://lentz.com.au. Sphinx (Andrew Aksyonov) - C Sphinx MySQL. - . . , , MySQL MySQL AB. , - ( , - ): (Tobias Asplund), - 19. 18 (Igor Babaev), (Pascal Borghino), (Roland Bouman), (Ronald Bradford), (Mark Callaghan), (Jeremy Cole), (BrittCrawford) HiveDB Project, (Vasil Dimov), - (Harrison Fisk), (Florian Haas), - (Dmitri Joukovski) Zmanda ( , - LVM), (Alan Kasindorf), (Sheeri Kritzer Cabral), (MarkoMakela), (Giuseppe Maxia), (PaulMcCullagh), . (B. Keith Murphy), (DhirenPatel), (Sergey Petrunia), (AlexanderRubin), (Paul Tuckfield), (Heikki Tuuri) (Michael Widenius). (Andy Oram) (Isabel Kunkle), - OReilly, (Rachel Wheeler), . OReilly. - . , , , . -(Alan Rimm-Kaufman) Rimm-KaufmanGroup . , , . , . , - MySQL , , -. , , . - MySQL, , , . . Percona, , . , - . ( - MySQL), - 20. 19 . , , . - MySQL, . , . , , , InnoDB, , - , - , . , - MySQL , , MySQL AB. MySQL -, InnoDB , MySQL . , - , - . Percona, , . OReilly , . , , , , -, , . - , , MySQL, , , MySQL. , , . , . , , , . -. ( ) MySQL AB, ; 21. 20 1, MySQL , Sun Microsystems. MySQL. , , - MySQL. , , . . . , , -. , , , - , , . - , . , - . , - , , . - . . OReilly , , . , , -. , , - - ., , - , . 2003 , , - . , Krow (Brian Krow Aker), JDBC (Mark JDBC Matthews), the other Jeremy (Jeremy the other Jeremy Cole), VBMySQL.com (Mike VBMySQL.com Hillyer), Rainman (Raymond Rainman De Roo), Re1 (Ulf Michael Widenius) MySQL MySQL AB. . . 22. 21gex Master (Jeffrey Regex Master Friedl), (Jason DeHaan), (Dan Nelson), UNIX Wiz (Steve UNIX...</p>

Recommended

View more >