## LOAD DATA LOCAL 

Section 13.2.7, “LOAD DATA Statement” Section 4.5.1.1, “mysql Client Options” Section 2.9.7, “MySQL Source-Configuration Options” Section 4.6.9, “mysqlbinlog — Utility for Processing Binary Log Files” Section 6.1.6, “Security Considerations for LOAD DATA LOCAL” Section 5.1.8, “Server System Variables” 

## LOAD DATA LOCAL INFILE 

Section 6.1.6, “Security Considerations for LOAD DATA LOCAL” 

## LOAD INDEX INTO CACHE 

Section 13.7.8.2, “CACHE INDEX Statement” Section 8.10.2.4, “Index Preloading” Section 13.7.8.5, “LOAD INDEX INTO CACHE Statement” Section 13.3.3, “Statements That Cause an Implicit Commit” 

## LOAD INDEX INTO CACHE ... IGNORE LEAVES 

Section 13.7.8.5, “LOAD INDEX INTO CACHE Statement” 

## LOAD XML 

Section 13.1.2, “ALTER DATABASE Statement” Section 13.1.20.6, “CHECK Constraints” Section 13.1.20.10, “Invisible Columns” Section 13.2.8, “LOAD XML Statement” Section 24.1, “Overview of Partitioning in MySQL” Section 24.5, “Partition Selection” Section 5.1.11, “Server SQL Modes” Section 1.3, “What Is New in MySQL 8.0” 

## LOAD XML ... IGNORE 

Section 13.1.20.6, “CHECK Constraints” 

## LOAD XML LOCAL 

Section 13.2.8, “LOAD XML Statement” 

## LOCK INSTANCE FOR BACKUP 

Section 6.2.2, “Privileges Provided by MySQL” Section 5.1.8, “Server System Variables” Section 1.3, “What Is New in MySQL 8.0” 

## LOCK TABLE 

Section 8.11.3, “Concurrent Inserts” Section 8.14.3, “General Thread States” Section B.3.6.1, “Problems with ALTER TABLE” 

## LOCK TABLES 

Section 13.1.10, “ALTER TABLESPACE Statement” Section 15.1.2, “Best Practices for InnoDB Tables” Section 8.6.2, “Bulk Data Loading for MyISAM Tables” Section 13.1.12, “CREATE DATABASE Statement” 

