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 A.17 MySQL 8.0 FAQ: InnoDB Data-at-Rest Encryption ................................................................. 5277 A.18 MySQL 8.0 FAQ: Virtualization Support ................................................................................. 5279 A.1.1 Which version of MySQL is production-ready (GA)? .............................................................. 5231 A.1.2 Why did MySQL version numbering skip versions 6 and 7 and go straight to 8.0? .................... 5232 A.1.3 Can MySQL 8.0 do subqueries? .......................................................................................... 5232 A.1.4 Can MySQL 8.0 perform multiple-table inserts, updates, and deletes? .................................... 5232 A.1.5 Does MySQL 8.0 have Sequences? ..................................................................................... 5232 A.1.6 Does MySQL 8.0 have a  NOW()  function with fractions of seconds? ....................................... 5232 A.1.7 Does MySQL 8.0 work with multi-core processors? ............................................................... 5232 A.1.8 Why do I see multiple processes for  mysqld ? ...................................................................... 5232 A.1.9 Can MySQL 8.0 perform ACID transactions? ........................................................................ 5233 A.1 MySQL 8.0 FAQ: General A.1.1. Which version of MySQL is production-ready (GA)? MySQL 8.0, 5.7, and MySQL 5.6 are supported for production use. MySQL 8.0 achieved General Availability (GA) status with MySQL 8.0.11, which was released for production use on 19 April 2018. MySQL 5.7 achieved General Availability (GA) status with MySQL 5.7.9, which was released for production use on 21 October 2015. MySQL 5.6 achieved General Availability (GA) status with MySQL 5.6.10, which was released for production use on 5 February 2013. MySQL 5.5 achieved General Availability (GA) status with MySQL 5.5.8, which was released for production use on 3 December 2010. Active development for MySQL 5.5 has ended. MySQL 5.1 achieved General Availability (GA) status with MySQL 5.1.30, which was released for production use on 14 November 2008. Active development for MySQL 5.1 has ended. 5231 Table of Contents Appendix A MySQL 8.0 Frequently Asked Questions