MySQL Advanced Advanced Video Tutorial

mysql encoding settings 1

mysql encoding setting 2

Session variables and global variables

Stored procedure 1

Stored procedure 2 (definition of variables)

Stored procedure 3 (parameter type)

Flow control statement selection statement 1

Process control (select statement case branch)

Process control (while loop statement)

Process control (loop repeat and loop statements)

Define conditions and processing [vxia.net]

Stored procedure management

Creation of functions

View creation 1

View management

Application of trigger 1

Trigger application 2

My ISAM table lock (shared read lock)

My ISAM table lock (exclusive write lock)

MyISAM table lock (concurrent insert)

Application of business 1

Application of business 2.

Slow query 1 (see slow query)

Slow query 2 (slow query configuration)

Index 1 (category of index)

Index 2 (full text index)

Optimize SQL with indexes

Table optimization

Partition 1 of the table (Range partition)

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

Mysql memory optimization

mysql application optimization

mysql account permission grant

mysql account permission management

mysql monitoring

mysql scheduled maintenance [vxia.net]

mysql backup and restore

mysql advanced project