Search Results
https://dev.mysql.com/doc/refman/9.7/en/system-schema.html
Note Like the mysql.func system table, the Performance Schema user_defined_functions table lists loadable functions installed using CREATE FUNCTION. Previously, these tables were created in individual tablespace files in the mysql database directory. Grant System Tables These system tables contain grant information about user accounts and the privileges held by ...
https://dev.mysql.com/doc/refman/9.7/en/mysqlslap.html
Invoke mysqlslap like this: mysqlslap [options] Some options such as --create or --query enable you to specify a string containing an SQL statement or a file containing statements. mysqlslap runs in three stages: Create schema, table, and optionally ... mysqlslap is a diagnostic program designed to emulate client load for a MySQL server and to report the timing of each ...
https://dev.mysql.com/doc/refman/9.7/en/account-locking.html
MySQL supports locking and unlocking user accounts using the ACCOUNT LOCK and ACCOUNT UNLOCK clauses for the CREATE USER and ALTER USER statements: When used with CREATE USER, these clauses specify the initial locking state for a new account. The ...In the absence of either clause, the account is created in an unlocked ...
https://dev.mysql.com/doc/refman/9.7/en/validate-password.html
This applies to the ALTER USER, CREATE USER, and SET PASSWORD statements. For CREATE USER statements, validate_password requires that a password be given, and that it satisfies the password policy. Note For statements that assign or modify account ...In addition, validate_password supports the capability of rejecting passwords that match the user name part of the effective user account for the current session, either forward or in ...
https://dev.mysql.com/doc/refman/9.7/en/mysqlcheck.html
mysqlcheck uses the SQL statements CHECK TABLE, REPAIR TABLE, ANALYZE TABLE, and OPTIMIZE TABLE in a convenient way for the user. --defaults-extra-file=file_name Command-Line Format --defaults-extra-file=file_name Type File name Read this option ...
https://dev.mysql.com/doc/refman/9.7/en/mysqld-safe.html
--core-file-size=size Command-Line Format --core-file-size=size Type String The size of the core file that mysqld should be able to create. Linux users can use the libtcmalloc_minimal.so library on any platform for which a tcmalloc package is ...
https://dev.mysql.com/doc/refman/9.7/en/rewriter-query-rewrite-plugin-usage.html
Statements run by users with the SKIP_QUERY_REWRITE privilege are not subject to rewriting, provided that the rewriter_enabled_for_threads_without_privilege_checks system variable is set to OFF (default ON). This can be used for control statements ... To enable or disable the plugin, enable or disable the rewriter_enabled system ...
https://dev.mysql.com/doc/workbench/en/wb-performance-reports.html
Initially, this loads an Easy Setup tab that is enough for most users. Top Memory by User – Shows users consuming the most memory. Top I/O by User/Thread – Shows the top I/O time consumers by user and thread. Waits by User by Time – Lists the ... Performance schema based reports provide insight into the MySQL server operations through helpful high-level ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/connecting-to-a-single-mysqld-node-setup.html
In this example a connection to a local MySQL Server instance running X Plugin on the default TCP/IP port 33060 is established using the MySQL user account user with its password. You are prompted to enter the user name and password in this case.
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/connecting-to-a-single-mysqld-node-setup.html
In this example a connection to a local MySQL Server instance running X Plugin on the default TCP/IP port 33060 is established using the MySQL user account user with its password. You are prompted to enter the user name and password in this case.