PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/insert.html
This is 0 for numeric types, the empty string ('') for string types, and the “zero” value for date and time types. Inserting a value into a date or time column that is illegal for the data type. It is possible, therefore, for a client that ...
https://dev.mysql.com/doc/refman/8.0/en/kerberos-pluggable-authentication.html
On Windows, the authentication_kerberos_client authentication plugin supports two modes, which the client user can set at runtime or specify in an option file: SSPI mode: Security Support Provider Interface (SSPI) implements GSSAPI (see Commands for ... Note Kerberos pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.0/en/kill.html
In most cases, it might take some time for the thread to die because the kill flag is checked only at specific intervals: During SELECT operations, for ORDER BY and GROUP BY loops, the flag is checked after reading a block of rows. The KILL ... KILL ...
https://dev.mysql.com/doc/refman/8.0/en/mathematical-functions.html
One implication of this behavior is that for equal argument values, RAND(N) returns the same value each time, and thus produces a repeatable sequence of column values. Use of a column with RAND() values in an ORDER BY or GROUP BY clause may yield ...
https://dev.mysql.com/doc/refman/8.0/en/memory-storage-engine.html
To replicate this effect to replicas, the first time that the source uses a given MEMORY table after startup, it logs an event that notifies replicas that the table must be emptied by writing a DELETE or (from MySQL 8.0.22) TRUNCATE TABLE statement ... The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-key-caches.html
The CACHE INDEX statement sets up an association between a table and a key cache, but the association is lost each time the server restarts. If you want the association to take effect each time the server starts, one way to accomplish this is to use ... Note As of MySQL 8.0, the compound-part structured-variable syntax discussed here for referring to multiple MyISAM key caches is ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-storage-engine.html
Table 18.2 MyISAM Storage Engine Features Feature Support B-tree indexes Yes Backup/point-in-time recovery (Implemented in the server, rather than in the storage engine.) Yes Cluster database support No Clustered indexes No Compressed data Yes ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-config-file.html
config.ini: This file, sometimes known as the global configuration file, is read only by the NDB Cluster management server, which then distributes the information contained therein to all processes participating in the cluster. (If you build NDB ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-config-starting.html
NoOfFragmentLogFiles=300 DataDir=path/to/data/node/data/directory MaxNoOfConcurrentOperations=100000 SchedulerSpinTimer=400 SchedulerExecutionTimer=100 RealTimeScheduler=1 # Setting these parameters allows you to take advantage of real-time ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-transactions.html
The resulting read is as consistent as a committed read by primary key, returning the last committed value at the time the row is read. It is not possible to know ahead of time when such commits take place. A number of limitations exist in NDB ...