MySQL is the most popular relational database management system. MySQL is one of the best RDBMS(relational database management system) application software in Web application. Free to share with you several MySQL from beginning-to advanced excellent books, help you quickly master MySQL from basic knowledge to advanced tuning experience, hope you like.
MySQL in Practice 45 – Lin Xiaobin
Lin Xiaobin, known online as “Ding Qi”, is the person in charge of Tencent Cloud Database. He is a former senior technical expert at Ali Cloud. He was in charge of Ali Cloud RDS kernel development team and operation and maintenance team, and promoted the open source of ALISQL branch. As an active contributor to the MySQL community, Dinky focuses on data storage system, MySQL source code research and improvement, MySQL performance optimization and function improvement, and is keen on solving MySQL difficult problems.
This course consists of two major modules.
Module 1: Basic. This tutorial will cover MySQL infrastructure, logging system, transaction isolation, locking, etc.
Module 2: Practice. Starting from the key database problems, the database principle is analyzed and the practical guidance is given. Each question is not just a simple answer, but a question about why you think this way and how you should do it. By letting you know why, you will be able to solve a puzzle in your daily work.
MySQL must know and know.pdf
MySQL is one of the most popular database management systems in the world. The book starts with simple data retrieval and progresses to more complex topics, including the use of joins, subqueries, regular expressions and full-text based searches, stored procedures, cursors, triggers, table constraints, and more. Focused chapters provide a clear, systematic, and concise presentation of what readers are supposed to know, empowering them instantly and without notice.
A book that takes care of beginners is not so much a book as a booklet, less than 250 pages booklet, very practical, basically no theory of what to build up, it is completely a practical guide, teach you how to use SQL statements to operate MySQL. After reading this book, we can basically say that it is the beginning. The only drawback is that it’s a little expensive.
Inside MySQL Technology 2nd Edition. PDF
“MySQL Technology Insider :InnoDB Storage Engine (2nd Edition)” is written by senior MySQL experts in China and recommended by many database experts at home and abroad. As the only monograph about InnoDB in China, the first edition of “Inside MySQL Technology :InnoDB Storage Engine (2nd edition)” was well received. The 2nd edition not only made a comprehensive supplement for the latest MySQL 5.6, but also improved the deficiencies in the first edition according to the feedback of the readers. Inside MySQL Technologies :InnoDB Storage Engine (2nd Edition) is about 50% rewritten. Inside MySQL Technology :InnoDB Storage Engine (2nd Edition) provides an in-depth analysis of InnoDB’s architecture, implementation principles, working mechanisms, and a number of best practices from a source code perspective to help you systematically and deeply understand InnoDB. More importantly, It provides an excellent guide for designing and managing high performance, high availability database systems.
“Inside MySQL Technology :InnoDB Storage Engine (2nd Edition)” is a total of 10 chapters. First of all, it introduces the MySQL architecture and various common storage engines and the comparison between them. Then with the internal implementation of InnoDB as the entry point, the implementation principle of each function module inside the InnoDB storage engine is explained in detail one by one, including the architecture of InnoDB storage engine, data structure in memory, physical storage of tables and pages based on the InnoDB storage engine, index and algorithm, file, lock, transaction, backup and recovery. And InnoDB performance tuning and other important knowledge; Finally, InnoDB storage engine source code compilation and debugging made an introduction, we read and understand the InnoDB source code has an important guiding significance.
High Performance MySQL 3rd Edition.pdf
“High Performance MySQL (3rd Edition)” is a classic in the MySQL field, with a wide range of influence. Version 3 includes a number of new features in the latest MySQL 5.5 release, as well as new content related to solid disk, high scalability design, and databases in cloud computing environments. There are also a number of extensions and additions to the existing benchmarking and performance tuning sections. The book is divided into 16 chapters and 6 appendices, covering MySQL architecture and history, benchmarking and performance analysis, database hardware and software performance optimization, replication, backup and recovery, high availability and scalability, as well as cloud MySQL and MySQL related tools and other aspects. Each chapter is a relatively separate topic, and the reader can read it selectively on its own.
Free e-books: Please scan the code and follow the public account “Java Beginners to Architecture”, and reply “0040” to get the above e-books for free.
Sort through these first and give me a thumbs-up if you find it helpful.