Search Results
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-query-profiling.html
The setup_actors table can be used to limit the collection of historical events by host, user, or account to reduce runtime overhead and the amount of data collected in history tables. The first step of the example shows how to limit collection of ... The following example demonstrates how to use Performance Schema statement events and stage events to retrieve data comparable to profiling information provided by SHOW PROFILES and SHOW PROFILE ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-variables-info-table.html
This includes option files not covered by EXPLICIT, EXTRA, LOGIN, PERSISTED, SERVER, or USER. LOGIN The variable was set from a user-specific login path file (~/.mylogin.cnf). USER The variable was set from a user-specific ~/.my.cnf option file.
https://dev.mysql.com/doc/refman/9.7/en/secure-client-programming.html
Handle External Data Properly Handle MySQL Error Messages Properly Handle External Data Properly Applications that access MySQL should not trust any data entered by users, who can try to trick your code by entering special or escaped character ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-application-log-introduction.html
The location of the MySQL Shell application log file is the user configuration path and the file is named mysqlsh.log. For example: C:>echo %APPDATA% C:\Users\exampleuser\AppData\Roaming On Windows, the path is the %APPDATA% folder specific to the ...By default, MySQL Shell sends logging information at logging level 5 (error, warning, and informational messages) to this ...
https://dev.mysql.com/doc/mysql-ai/9.7/en/mys-mysqlai-ml-model-load.html
A model remains loaded until the model is unloaded using the ML_MODEL_UNLOAD routine Use ML_MODEL_ACTIVE to check which models are active for which users. All active users and models share the amount of memory defined by the shape, and it might be ... The ML_MODEL_LOAD routine loads a model from the model ...
https://dev.mysql.com/doc/ndbapi/en/ndb-dictionary.html
You should keep in mind that the NDB API does not track allocated event objects, which means that the user must delete the Event that was obtained using createEvent(), after this object is no longer required. The NDB API does not track allocated ...
https://dev.mysql.com/doc/refman/9.7/en/stored-programs-logging.html
On the replica side, the replica uses the trigger DEFINER attribute to determine which user is considered to be the creator of the trigger. The implication is that although a user must have the CREATE ROUTINE privilege to create a function, the user ...In this situation, it is possible for a procedure to follow different execution paths on source and replica servers, so a user could write a routine containing a dangerous statement that executes only on the ...
https://dev.mysql.com/doc/ndbapi/en/ndb-error-codes-single.html
Create foreign key failed - parent key is primary key and on-update-cascade is not allowed 21020 MySQL error. Create foreign key failed in NDB - no more object records 21021 MySQL error. Create foreign key failed in NDB - invalid request 21022 MySQL ... This section lists all NDB errors, ordered by NDB error ...
https://dev.mysql.com/doc/refman/9.7/en/binary-installation.html
Create a mysql User and Group If your system does not already have a user and group to use for running mysqld, you may need to create them. $> groupadd mysql $> useradd -r -g mysql -s /bin/false mysql Note Because the user is required only for ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-replication-preparation.html
If the source cluster is already in use, you can create a backup of the source and load this onto the replica to cut down on the amount of time required for the replica to synchronize itself with the source. ndb-connectstring=management_host[:port] ... Preparing the NDB Cluster for replication consists of the following steps: Check all MySQL servers for version compatibility (see Section 25.7.2, “General Requirements for NDB Cluster ...