PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/keyring-component-installation.html
For example, the InnoDB storage engine uses the keyring for tablespace encryption, so a keyring component or plugin must be loaded and available prior to InnoDB initialization. Alternatively, to use a global and local manifest file pair, the global ... Keyring service consumers require that a keyring component or plugin be installed: To use a keyring component, begin with the instructions ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-privilege-synchronization.html
NDB Cluster 8.0 does not support distribution of MySQL users and privileges across SQL nodes in an NDB Cluster by altering the MySQL privilege tables such that they used the NDB storage engine as in NDB 7.6 and earlier releases (see Distributed ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-mgmd.html
All options that can be used with ndb_mgmd are shown in the following table. By default, the management server looks for a file named config.ini in the same directory as the ndb_mgmd executable; otherwise the file name and location must be specified ... The management server is the process that reads the cluster configuration file and distributes this information to all nodes in the cluster that request ...
https://dev.mysql.com/doc/refman/8.0/en/show-procedure-status.html
To use either statement, you must be the user named as the routine DEFINER, have the SHOW_ROUTINE privilege, have the SELECT privilege at the global level, or have the CREATE ROUTINE, ALTER ROUTINE, or EXECUTE privilege granted at a scope that ...
https://dev.mysql.com/doc/refman/8.0/en/stored-objects.html
Trigger: An object created with CREATE TRIGGER that is associated with a table. A trigger is activated when a particular event occurs for the table, such as an insert or update. The following sections provide additional information about SQL syntax ... This chapter discusses stored database objects that are defined in terms of SQL code that is stored on the server for later ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-save.html
This enables you to alter the configuration temporarily for debugging or other purposes, then restore it to the previous state by invoking the ps_setup_reload_saved() procedure. It is intended you call ps_setup_reload_saved() later within the same ...To prevent other simultaneous calls to save the configuration, ps_setup_save() acquires an advisory lock named sys.ps_setup_save by calling the GET_LOCK() ...
https://dev.mysql.com/doc/refman/8.0/en/apache.html
There are programs that let you authenticate your users from a MySQL database and also let you write your log files into a MySQL table.
https://dev.mysql.com/doc/refman/8.0/en/audit-log-logging-configuration.html
For example, if the configured audit_log_file value is audit.log, the effective file name is one of the values shown in the following table. In that case, an archived audit log file has one of the names shown in the following table. This section ...
https://dev.mysql.com/doc/refman/8.0/en/binary-varbinary.html
Instead, it causes the binary (_bin) collation for the column character set (or the table default character set if no column character set is specified) to be used, and the column itself stores nonbinary character strings rather than binary byte ...
https://dev.mysql.com/doc/refman/8.0/en/calculating-days.html
CREATE TABLE t1 (year YEAR, month INT UNSIGNED, day INT UNSIGNED); INSERT INTO t1 VALUES(2000,1,1),(2000,1,20),(2000,1,30),(2000,2,2), (2000,2,23),(2000,2,23); The example table contains year-month-day values representing visits by users to the page. The following example shows how you can use the bit group functions to calculate the number of days per month a user has visited a Web ...