Movatterモバイル変換

You can obtain metadata about JavaScript stored programs in the same ways in which you can do so for SQL stored programs; seeSection 27.2.3, “Stored Routine Metadata”.

Additional information relating to the MLE component which provides JavaScript stored program functionality can be obtained by checking the values of server system and status variables which this component makes available. SeeSection 7.5.6.2, “MLE Component Status and Session Information”, for information about these.

For information about memory usage by JavaScript stored programs, seeSection 7.5.6.3, “MLE Component Memory and Thread Usage”

You can retrieve the statement that was used to create an MLE stored routine usingSHOW CREATE FUNCTION orSHOW CREATE PROCEDURE, as with any other MySQL stored routine. Stored routine metadata can be retrieved by querying the Information SchemaROUTINES table, or by issuingSHOW FUNCTION STATUS orSHOW PROCEDURE STATUS as appropriate. This metadata is stored in the MySQL data dictionary, and is persistent.

Information about the component's state in the current user session can be acquired using the loadable functionmle_session_state(), which is described elsewhere in this section.