A complete set of MySQL tutorials - MySQL hot interview questions

• Chapter1 Course introduction and mysql installation
• 1-1 Course content introduction
• 1-2 Install mysql on linux
• 1-3 Start and log in to mysql
• Chapter2 mysql index
• 2-1 Index overview
• 2-2 Advantages and disadvantages
• 2-3 data structure
• 2-4 Data structure-BTREE
• 2-5 Data structure-B+TREE
• 2-6 Index classification
• 2-7 Index syntax
• 2-8 Index design principles
• Chapter3 view
• 3-1 Overview
• 3-2 Create and modify views
• 3-3 View and delete views
• Chapter4 stored procedure
• 4-1 Stored procedures overview
• Chapter5 grammar
• 5-1 Create call query delete syntax
• 5-2 variable
• 5-3 if judgment
• Chapter6 Input and output parameters
• 6-1 Input parameters
• 6-2 Output parameters
• Chapter7 case structure and loop
• 7-1 case structure
• 7-2 while loop
• 7-3 repeat loop
• 7-4 loop loop
• Chapter8 cursor
• 8-1 Cursor introduction
• 8-2 Basic cursor operations
• 8-3 Loop to get cursor
• Chapter9 Functions and triggers
• 9-1 function
• 9-2 Introduction to triggers
• 9-3 Trigger creation and application
• 9-4 View and delete triggers
• 9-5 Content summary
• Chapter10 Architecture and Storage Engine
• 10-1 Architecture
• 10-2 Storage engine overview
• 10-3 Storage engine features
• 10-4 InnoDB characteristics
• 10-5 MyISAM features
• 10-6 Memory and Merge features
• 10-7 Storage engine selection principles
• Chapter11 Optimize SQL steps
• 11-1 SQL execution frequency
• 11-2 Locate inefficient SQL
• 11-3 Introduction to explain command
• 11-4 explain id
• 11-5 explain之select_type
• 11-6 explain之table type
• 11-7 key rows extra
• 11-8 show profile
• 11-9 trace tool
• Chapter12 Use of index
• 12-1 Verify index to improve query efficiency
• 12-2 Match all values
• 12-3 leftmost prefix rule
• 12-4 Failure conditions (range query, field operation)
• 12-5 covering index
• 12-6 Index failure
• 12-7 like fuzzy matching
• 12-8 Full table scan is faster
• 12-9 Judgment of NULL value
• 12-10 in和not in
• 12-11 Single column index and compound index selection
• 12-12 View index usage
• Chapter13 SQL optimization
• 13-1 Insert data in bulk
• 13-2 insert optimization
• 13-3 orderby optimization
• 13-4 group by optimization
• 13-5 subquery optimization
• 13-6 or optimize
• 13-7 limit optimization
• 13-8 index hint
• 13-9 Content summary
• Chapter14 Application optimization
• 14-1 Application optimization
• 14-2 Query caching-overview and process
• 14-3 Query cache-configuration parameters
• 14-4 Query cache-enable query cache
• 14-5 Query cache—SELECT options
• 14-6 Query cache - failure scenario
• Chapter15 Memory optimization
• 15-1 Optimization principles
• 15-2 MyISAM memory optimization
• 15-3 InnoDB memory optimization
• Chapter16 mysql concurrency parameter adjustment
• 16-1 Concurrency parameter adjustment
• Chapter17 mysql lock problem
• 17-1 Overview and classification of locks
• 17-2 mysql support for locks
• 17-3 MyISAM table lock-read lock
• 17-4 MyISAM table lock - write lock
• 17-5 Summary of MyISAM table locks
• 17-6 MyISAM table lock-view lock contention
• 17-7 InnoDB row lock-introduction and background knowledge
• 17-8 InnoDB row lock-type
• 17-9 InnoDB row lock-basic demo
• 17-10 InnoDB row lock-row lock upgraded to table lock
• 17-11 InnoDB row lock-gap lock hazards
• 17-12 InnoDB row lock-contention view
• 17-13 InnoDB row lock-summary
• Chapter18 Common SQL skills
• 18-1 SQL execution order and regular expressions
• 18-2 Numeric and string functions
• 18-3 Date functions and aggregate functions
• 18-4 Course content
• 18-5 Commonly used tools mysql
• 18-6 Commonly used tools-mysqladmin
• 18-7 Commonly used tools-mysqlbinlog and mysqldump
• 18-8 Commonly used tools-mysqlimport and source
• 18-9 Commonly used tools mysqlshow
• Chapter19 mysql log
• 19-1 error log
• 19-2 Binary log
• 19-3 Binary log (row and log deletion)
• 19-4 Query log
• 19-5 Slow query log
• Chapter20 mysql copy
• 20-1 Copy principle
• 20-2 Cluster construction
• Chapter21 Comprehensive case
• 21-1 Requirements and environment preparation
• 21-2 Basic project import
• 21-3 AOP logging
• 21-4 Log query backend - mapper interface
• 21-5 Log query backend——Service
• 21-6 Log query - front end
• 21-7 System performance optimization analysis
• 21-8 System performance optimization - paging optimization
• 21-9 System performance optimization - index optimization
• 21-10 Read-Write Separation Overview
• 21-11 Data source configuration
• 21-12 System performance optimization - AOP switching data source
• 21-13 System performance optimization - AOP switching data source 2
• 21-14 System performance optimization - application optimization