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/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/multiple-unix-servers.html
-DMYSQL_TCP_PORT=port_number \ -DMYSQL_UNIX_ADDR=file_name \ -DCMAKE_INSTALL_PREFIX=/usr/local/mysql-8.0.44 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 ...
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/monitor-mysql-memory-use.html
The following query returns memory data for the InnoDB buffer pool. Memory instruments have names in the form of memory/code_area/instrument_name, where code_area is a value such as sql or innodb, and instrument_name is the instrument detail. For ...
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/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/charset-applications.html
Note If you use ALTER DATABASE to change the database default character set or collation, existing stored routines in the database that use those defaults must be dropped and recreated so that they use the new defaults. For example, to specify the ... For applications that store data using the default MySQL character set and collation (utf8mb4, utf8mb4_0900_ai_ci), no special configuration should be ...If applications require ...
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 ...