PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/events-overview.html
An event can be modified by any user having the EVENT privilege on the database for which the event is defined. Users can create, modify, and drop scheduled events using SQL statements intended for these purposes. While there is no provision in the ...When you create an event, you are creating a named database object containing one or more SQL statements to be executed at one or more regular intervals, beginning and ending at a specific date and ...
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption-usage.html
SET @ciphertext = asymmetric_encrypt(@algo, 'My secret text', @pub); SET @plaintext = asymmetric_decrypt(@algo, @ciphertext, @priv); In either case, the algorithm specified for the encryption and decryption functions must match that used to generate ... To use MySQL Enterprise Encryption in applications, invoke the functions that are appropriate for the operations you wish to ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-security.html
memcp --servers=localhost:11211 --binary --username=testname --password=password myfile.txt memcat --servers=localhost:11211 --binary --username=testname --password=password myfile.txt If you specify an incorrect user name or password, the operation ...Password-Protecting memcached Using SASL SASL support provides the capability to protect your MySQL database from unauthenticated access through memcached ... Caution ...Because memcached does not use an authentication mechanism by default, and the optional SASL authentication is not as strong as traditional DBMS security ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-internals.html
flags The InnoDB table columns that are used as flags (a user-defined numeric value that is stored and retrieved along with the main value) for memcached. mysql> USE innodb_memcache; Database changed mysql> SHOW TABLES; +---------------------------+ ... InnoDB API for the InnoDB memcached Plugin The InnoDB memcached engine accesses InnoDB through InnoDB APIs, most of which are directly adopted from embedded ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-conflict-resolution.html
Conflict resolution in NDB Cluster Replication provides a means of resolving such conflicts by permitting a user-defined resolution column to be used to determine whether or not an update on a given source should be applied on the replica. Some ...
https://dev.mysql.com/doc/refman/5.7/en/windows-postinstallation.html
If you install MySQL using MySQL Installer, the root user is created automatically with the password you supplied. Windows distributions prior to MySQL 5.7.7 include a data directory with a set of preinitialized accounts in the mysql database. (See ... GUI tools exist that perform most of the tasks described in this section, including: MySQL Installer: Used to install and upgrade MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/sys-user-summary-by-file-io.html
Rows for which the USER column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of background. ios The total number of file I/O events for the user. io_latency The total ...
https://dev.mysql.com/doc/refman/5.7/en/starting-server.html
Start the MySQL server like this if your installation includes mysqld_safe: $> bin/mysqld_safe --user=mysql & Note For Linux systems on which MySQL is installed using RPM packages, server startup and shutdown is managed using systemd rather than ...
https://dev.mysql.com/doc/refman/5.7/en/source-configuration-options.html
OFF WITH_EXTRA_CHARSETS Which extra character sets to include all WITH_GMOCK Path to googlemock distribution WITH_INNODB_EXTRA_DEBUG Whether to include extra debugging support for InnoDB. To set the value for the libmysqld embedded server, use ...
https://dev.mysql.com/doc/refman/5.7/en/select-into.html
For the INTO var_list variant: var_list names a list of one or more variables, each of which can be a user-defined variable, stored procedure or function parameter, or stored program local variable. The reason for this is that the MySQL server ...