PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-rwlock-instances-table.html
Depending on how many threads are requesting a lock, and the nature of the locks requested, access can be either granted in shared mode, exclusive mode, shared-exclusive mode or not granted at all, waiting for other threads to finish first. The ...
https://dev.mysql.com/doc/refman/5.7/en/program-variables.html
Many MySQL programs have internal variables that can be set at runtime using the SET statement. See Section 13.7.4.1, “SET Syntax for Variable Assignment”, and Section 5.1.8, “Using System Variables”. Most of these program variables also ...
https://dev.mysql.com/doc/refman/5.7/en/activestate-perl.html
If you cannot get the procedure to work, you should install the ODBC driver instead and connect to the MySQL server through ODBC: use DBI; $dbh= DBI->connect("DBI:ODBC:$dsn",$user,$password) || die "Got error $DBI::errstr when connecting to $dsn\n"; ... On Windows, you should do the following to install the MySQL DBD module with ActiveState Perl: Get ActiveState Perl from http://www.activestate.com/Products/ActivePerl/ and install ...
https://dev.mysql.com/doc/refman/5.7/en/adding-character-set.html
The range of IDs from 1024 to 2047 is reserved for user-defined collations. This section discusses the procedure for adding a character set to MySQL. The proper procedure depends on whether the character set is simple or complex: If the character ...
https://dev.mysql.com/doc/refman/5.7/en/adding-collation-choosing-id.html
The range of IDs from 1024 to 2047 is reserved for user-defined collations. To add a collation, you must choose an ID value that is not currently used. The collation ID that you choose appears in these contexts: The ID column of the Information ...
https://dev.mysql.com/doc/refman/5.7/en/adding-collation-simple-8bit.html
You can check the variable value as follows, although the path name might be different on your system: mysql> SHOW VARIABLES LIKE 'character_sets_dir'; +--------------------+-----------------------------------------+ | Variable_name | Value | ...
https://dev.mysql.com/doc/refman/5.7/en/ansi-diff-select-into-table.html
For example: INSERT INTO tbl_temp2 (fld_id) SELECT tbl_temp1.fld_order_id FROM tbl_temp1 WHERE tbl_temp1.fld_order_id > 100; Alternatively, you can use SELECT ... The same syntax can also be used inside stored routines using cursors and local ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-elements.html
Tables in the mysql system database provide persistent storage of filter and user account data. MySQL Enterprise Audit is based on the audit log plugin and related elements: A server-side plugin named audit_log examines auditable events and ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-legacy-filtering.html
The value for either variable can be NULL or a string containing one or more comma-separated account names, each in user_name@host_name format. Example: To enable audit logging only for the user1 and user2 local host accounts, set the ... Note This ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-restrictions.html
MySQL Enterprise Audit is subject to these general restrictions: Only SQL statements are logged. Changes made by no-SQL APIs, such as memcached, Node.JS, and the NDB API, are not logged. Only top-level statements are logged, not statements within ...