MySQL 8.0 Reference Manual 28.4.1 sys Schema Object Index ................................................................................... 5134 28.4.2 sys Schema Tables and Triggers ........................................................................ 5138 28.4.3 sys Schema Views ............................................................................................. 5140 28.4.4 sys Schema Stored Procedures .......................................................................... 5182 28.4.5 sys Schema Stored Functions ............................................................................. 5202 29 Connectors and APIs ............................................................................................................... 5215 29.1 MySQL Connector/C++ ................................................................................................. 5218 29.2 MySQL Connector/J ...................................................................................................... 5218 29.3 MySQL Connector/NET ................................................................................................. 5218 29.4 MySQL Connector/ODBC .............................................................................................. 5218 29.5 MySQL Connector/Python ............................................................................................. 5218 29.6 MySQL Connector/Node.js ............................................................................................ 5218 29.7 MySQL C API ............................................................................................................... 5219 29.8 MySQL PHP API .......................................................................................................... 5219 29.9 MySQL Perl API ........................................................................................................... 5219 29.10 MySQL Python API ..................................................................................................... 5220 29.11 MySQL Ruby APIs ...................................................................................................... 5220 29.11.1 The MySQL/Ruby API ...................................................................................... 5220 29.11.2 The Ruby/MySQL API ...................................................................................... 5220 29.12 MySQL Tcl API ........................................................................................................... 5220 29.13 MySQL Eiffel Wrapper ................................................................................................. 5220 30 MySQL Enterprise Edition ........................................................................................................ 5221 30.1 MySQL Enterprise Monitor Overview .............................................................................. 5221 30.2 MySQL Enterprise Backup Overview .............................................................................. 5222 30.3 MySQL Enterprise Security Overview ............................................................................. 5223 30.4 MySQL Enterprise Encryption Overview ......................................................................... 5223 30.5 MySQL Enterprise Audit Overview ................................................................................. 5223 30.6 MySQL Enterprise Firewall Overview ............................................................................. 5224 30.7 MySQL Enterprise Thread Pool Overview ...................................................................... 5224 30.8 MySQL Enterprise Data Masking and De-Identification Overview ..................................... 5224 31 MySQL Workbench .................................................................................................................. 5225 32 MySQL on the OCI Marketplace ............................................................................................... 5227 32.1 Prerequisites to Deploying MySQL EE on Oracle Cloud Infrastructure .............................. 5227 32.2 Deploying MySQL EE on Oracle Cloud Infrastructure ...................................................... 5227 32.3 Configuring Network Access .......................................................................................... 5229 32.4 Connecting ................................................................................................................... 5229 32.5 Maintenance ................................................................................................................. 5230 A MySQL 8.0 Frequently Asked Questions .................................................................................... 5231 A.1 MySQL 8.0 FAQ: General ............................................................................................... 5231 A.2 MySQL 8.0 FAQ: Storage Engines .................................................................................. 5233 A.3 MySQL 8.0 FAQ: Server SQL Mode ................................................................................ 5234 A.4 MySQL 8.0 FAQ: Stored Procedures and Functions ......................................................... 5235 A.5 MySQL 8.0 FAQ: Triggers .............................................................................................. 5238 A.6 MySQL 8.0 FAQ: Views .................................................................................................. 5241 A.7 MySQL 8.0 FAQ: INFORMATION_SCHEMA .................................................................... 5241 A.8 MySQL 8.0 FAQ: Migration ............................................................................................. 5242 A.9 MySQL 8.0 FAQ: Security ............................................................................................... 5243 A.10 MySQL 8.0 FAQ: NDB Cluster ...................................................................................... 5244 A.11 MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets ...................... 5257 A.12 MySQL 8.0 FAQ: Connectors & APIs ............................................................................ 5268 A.13 MySQL 8.0 FAQ: C API, libmysql .................................................................................. 5269 A.14 MySQL 8.0 FAQ: Replication ........................................................................................ 5270 A.15 MySQL 8.0 FAQ: MySQL Enterprise Thread Pool .......................................................... 5274 A.16 MySQL 8.0 FAQ: InnoDB Change Buffer ....................................................................... 5275 xxvi