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/multiple-windows-command-line-servers.html
For example, the C:\my-opts1.cnf file might be written like this: [mysqld] datadir = C:/mydata1 port = 3307 enable-named-pipe socket = mypipe1 Modify C:\my-opts2.cnf similarly for use by the second server. To start multiple servers this way, you can ... The procedure for starting a single MySQL server manually from the command line is described in Section 2.3.4.6, “Starting MySQL from the Windows Command ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-functions-general-purpose.html
The keyring functions are contained in a plugin library file, which also contains a keyring_udf plugin that must be enabled prior to function invocation. For these functions to be used, a keyring plugin such as keyring_file or keyring_okv, or a ...
https://dev.mysql.com/doc/refman/8.0/en/windows-installation.html
MySQL and Virus Checking Software Virus-scanning software such as Norton/Symantec Anti-Virus on directories containing MySQL data and temporary tables can cause issues, both in terms of the performance of MySQL and the virus-scanning software ...
https://dev.mysql.com/doc/refman/8.0/en/blackhole-storage-engine.html
The BLACKHOLE storage engine acts as a “black hole” that accepts data but throws it away and does not store it. When you create a BLACKHOLE table, the server creates the table definition in the global data dictionary. Inserts into a BLACKHOLE ...To examine the source for the BLACKHOLE engine, look in the sql directory of a MySQL source ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-transactions.html
NDBCLUSTER stores only part of a column value that uses any of MySQL's BLOB or TEXT data types in the table visible to MySQL; the remainder of the BLOB or TEXT is stored in a separate internal table that is not accessible to MySQL. This means that ... A number of limitations exist in NDB Cluster with regard to the handling of ...To ensure that a given ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-connection-attribute-tables.html
For connections initiated using the C API, the libmysqlclient library imposes a limit of 64KB on the aggregate size of connection attribute data on the client side: Calls to mysql_options() that cause this limit to be exceeded produce a ...FEDERATED ... Connection attributes are key-value pairs that application programs can pass to the server at connect ...Attribute names that ...
https://dev.mysql.com/doc/refman/8.0/en/recovery-from-backups.html
The full backup file is just a set of SQL statements, so restoring it is very easy: $> mysql < backup_sunday_1_PM.sql At this point, the data is restored to its state as of Sunday 1 p.m.. To restore the changes made since then, we must use the ...To ... Now, suppose that we have a catastrophic unexpected exit on Wednesday at 8 ...
https://dev.mysql.com/doc/refman/8.0/en/insert-optimization.html
Ideally, you make a single connection, send the data for many new rows at once, and delay all index updates and consistency checking until the very end. If you are adding data to a nonempty table, you can tune the bulk_insert_buffer_size variable to ...The size of the table slows down the insertion of indexes by log N, assuming B-tree ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-plugin-installation.html
MySQL provides these keyring plugin choices: keyring_file (deprecated as of MySQL 8.0.34): Stores keyring data in a file local to the server host. keyring_encrypted_file (deprecated as of MySQL 8.0.34): Stores keyring data in an encrypted, ...A ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-unix-servers.html
-DMYSQL_TCP_PORT=port_number \ -DMYSQL_UNIX_ADDR=file_name \ -DCMAKE_INSTALL_PREFIX=/usr/local/mysql-8.0.43 Here, port_number and file_name must be different from the default TCP/IP port number and Unix socket file path name, and the ...Compiling in ... Note The discussion here uses mysqld_safe to launch multiple instances of ...For MySQL installation using an RPM ...