Section1 mysql encoding settings 1

13 minutes52 seconds

Section2 mysql encoding setting 2

14 minutes19 seconds

Section3 Session variables and global variables

13 minutes31 seconds

Section4 Stored procedure 1

12 minutes59 seconds

Section5 Stored procedure 2 (definition of variables)

14 minutes40 seconds

Section6 Stored procedure 3 (parameter type)

13 minutes23 seconds

Section7 Flow control statement selection statement 1

12 minutes35 seconds

Section8 Process control (select statement case branch)

16 minutes23 seconds

Section9 Process control (while loop statement)

13 minutes33 seconds

Section10 Process control (loop repeat and loop statements)

12 minutes43 seconds

Section11 Define conditions and processing [vxia.net]

14 minutes30 seconds

Section12 Stored procedure management

11 minutes23 seconds

Section13 Creation of functions

14 minutes50 seconds

Section14 View creation 1

14 minutes40 seconds

Section15 View management

16 minutes30 seconds

Section16 Application of trigger 1

14 minutes57 seconds

Section17 Trigger application 2

12 minutes23 seconds

Section18 My ISAM table lock (shared read lock)

12 minutes56 seconds

Section19 My ISAM table lock (exclusive write lock)

10 minutes31 seconds

Section20 MyISAM table lock (concurrent insert)

11 minutes41 seconds

Section21 Application of business 1

13 minutes44 seconds

Section22 Application of business 2.

14 minutes01 seconds

Section23 Slow query 1 (see slow query)

13 minutes16 seconds

Section24 Slow query 2 (slow query configuration)

11 minutes47 seconds

Section25 Index 1 (category of index)

14 minutes01 seconds

Section26 Index 2 (full text index)

14 minutes21 seconds

Section27 Optimize SQL with indexes

15 minutes31 seconds

Section28 Table optimization

13 minutes26 seconds

Section29 Partition 1 of the table (Range partition)

13 minutes53 seconds

Section30 Partition 2 of the table (List partition, Hash, Keys partition)

14 minutes45 seconds

Section31 Mysql memory optimization

13 minutes51 seconds

Section32 mysql application optimization

14 minutes28 seconds

Section33 mysql account permission grant

15 minutes56 seconds

Section34 mysql account permission management

12 minutes38 seconds

Section35 mysql monitoring

14 minutes54 seconds

Section36 mysql scheduled maintenance [vxia.net]

13 minutes13 seconds

Section37 mysql backup and restore

14 minutes20 seconds

Section38 mysql advanced project

08 minutes23 seconds