GIT – Book Description
How can you bring out MySQL’s full power? With High PerformanceMySQL, you’ll learn advanced techniques for everything from designing schemas, indexes, and queries to tuning your MySQL server, operating system, and hardware to their fullest potential. This guide also teaches you safe and practical ways to scale applications through replication, load balancing, high availability, and failover.
Updated to reflect recent advances in MySQL and InnoDBperformance, features, and tools, this third edition not only offers specific examples of how MySQL works, it also teaches you why this system works as it does, with illustrative stories and case studies that demonstrate MySQL’s principles in action. With this book, you’ll learn how to think in MySQL.
- Learn the effects of new features in MySQL 5.5, including stored procedures, partitioned databases, triggers, and views
- Implement improvements in replication, high availability, and clustering
- Achieve high performance when running MySQL in the cloud
- Optimize advanced querying features, such as full-text searches
- Take advantage of modern multi-core CPUs and solid-state disks
- Explore backup and recovery strategies—including new tools for hot online backups
Table of Contents
Chapter 1. MySQL Architecture and History
Chapter 2. Benchmarking MySQL
Chapter 3. Profiling Server Performance
Chapter 4. Optimizing Schema and Data Types
Chapter 5. Indexing for High Performance
Chapter 6. Query Performance Optimization
Chapter 7. Advanced MySQL Features
Chapter 8. Optimizing Server Settings
Chapter 9. Operating System and Hardware Optimization
Chapter 10. Replication
Chapter 11. Scaling MySQL
Chapter 12. High Availability
Chapter 13. MySQL in the Cloud
Chapter 14. Application-Level Optimization
Chapter 15. Backup and Recovery
Chapter 16. Tools for MySQL Users
Appendix A. Forks and Variants of MySQL
Appendix B. MySQL Server Status
Appendix C. Transferring Large Files
Appendix D. Using EXPLAIN
Appendix E. Debugging Locks
Appendix F. Using Sphinx with MySQL
Book Details
- Paperback: 826 pages
- Publisher: O’Reilly Media; 3rd Edition (March 2012)
- Language: English
- ISBN-10: 1449314287
- ISBN-13: 978-1449314286
Download ebook High Performance MySQL, 3rd Edition direct link Oreilly.High.Performance.MySQL.3rd.Edition-www.gocit.vn.pdf
[…] # InnoDB database with 3 MyISAM tables linked port = 3306 socket = /var/run/mysql/mysql.sock # MySQL server [mysqld] port = 3306 socket = /var/run/mysql/mysql.sock datadir = /var/lib/mysql skip-locking key_buffer_size = 16M max_allowed_packet = 2M table_open_cache = 128 sort_buffer_size = 1024K net_buffer_length = 8K read_buffer_size = 512K read_rnd_buffer_size = 1024K myisam_sort_buffer_size = 8M query_cache_size = 16M # Added values after load testing thread_cache_size = 4 tmp_table_size = 128M max_heap_table_size = 128M table_cache = 512 join_buffer_size = 512 # Replication Master Server (default) # binary logging is required for replication log-bin=mysql-bin # binary logging format binlog_format=mixed # required unique id between 1 and 2^32 – 1 # defaults to 1 if master-host is not set # but will not function as a master if omitted server-id = 1 # Innodb specifics innodb_data_home_dir = /var/lib/mysql/ innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /var/lib/mysql/ # 50 – 80 % of RAM but beware of setting memory usage too high innodb_buffer_pool_size = 2048M # innodb_additional_mem_pool_size generally not needed after tests innodb_additional_mem_pool_size = 8M # log_file_size to 25 % of buffer pool size innodb_log_file_size = 512M innodb_log_buffer_size = 16M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 # innodb_file_per_table to avoid defragmentation but when optimizing will lock tables innodb_file_per_table = 1 # The safe_mysqld script [safe_mysqld] log-error = /var/log/mysql/mysqld.log socket = /var/run/mysql/mysql.sock !include_dir /etc/mysql [mysqldump] socket = /var/run/mysql/mysql.sock quick max_allowed_packet = 32M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [myisamchk] key_buffer_size = 60M sort_buffer_size = 60M read_buffer = 8M write_buffer = 8M [mysqlhotcopy] interactive-timeout [mysqld_multi] mysqld = /usr/bin/mysqld_safe mysqladmin = /usr/bin/mysqladmin log = /var/log/mysqld_multi.log # Mysql Database Performance tuning : Please give new suggestions if you think you can optimize performance even more. Download ebook High.Performance.MySQL.3rd.Edition http://www.gocit.vn/bai-viet/ebook-high-performance-mysql-3rd-edition/ […]