Movatterモバイル変換

Several system status variables provide information about usage of MLE stored programs. Themle_stored_procedures,mle_stored_functions, andmle_stored_programs status variables show, respectively, the numbers of MLE stored procedures, MLE stored functions, and MLE stored programs which are presently cached, across all user sessions.

Additional MLE stored program metrics can be obtained from two status variablesmle_stored_program_bytes_max, which provides the size, in bytes, of the largest current MLE stored program, andmle_stored_program_sql_max shows the maximum number of SQL statements executed by any MLE stored program.

Other information about MLE stored programs can be found in the Information SchemaROUTINES table.

MLE stored programs in MySQL Enterprise Edition 9.2 support imported JavaScript libraries. Information about MLE JavaScript libraries is available in the two Information Schema tablesLIBRARIES andROUTINE_LIBRARIES. For more information and examples of their use, see the descriptions of these tables, as well asSection 27.3.8, “Using JavaScript Libraries”.