Search Results
https://dev.mysql.com/doc/refman/8.4/en/partitioning.html
Note Table partitioning differs from partitioning as used by window functions. MySQL 8.4 does not currently support partitioning of tables using any storage engine other than InnoDB or NDB, such as MyISAM. An attempt to create a partitioned tables ...In MySQL 8.4, partitioning support is provided by the InnoDB and NDB storage ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-status-variables.html
Performance Schema status variables have the following meanings: Performance_schema_accounts_lost The number of times a row could not be added to the accounts table because it was full. Performance_schema_digest_lost The number of digest instances ...This can be nonzero if the value of performance_schema_digests_size is too ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-flush.html
Some forms of the FLUSH statement are not logged because they could cause problems if replicated to a replica: FLUSH LOGS and FLUSH TABLES WITH READ LOCK. The FLUSH TABLES, ANALYZE TABLE, OPTIMIZE TABLE, and REPAIR TABLE statements are written to ...These statements are written to the binary log unless you specify NO_WRITE_TO_BINLOG or its alias ...
https://dev.mysql.com/doc/refman/8.4/en/silent-column-changes.html
In some cases, MySQL silently changes column specifications from those given in a CREATE TABLE or ALTER TABLE statement. See Section 10.4.7, “Limits on Table Column Count and Row Size”. Trailing spaces are automatically deleted from ENUM and ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/plugin-types.html
The plugin API enables creation of plugins that implement several capabilities: Loadable functions (UDFs) Storage engines Full-text parsers Daemons INFORMATION_SCHEMA tables Semisynchronous replication Auditing Authentication Password validation ...
https://dev.mysql.com/doc/relnotes/mysql-cluster/8.4/en/dynxml-auto-changelog-difflist-mysqld-8.4.1-ndb-8.4.1.html
It was removed due to a critical issue that could stop the server from restarting following the creation of a very large number of tables (8001 or more). ndbinfo Information Database: Added a type column to the transporter_details table in the ...
https://dev.mysql.com/doc/refman/8.4/en/webauthn-pluggable-authentication.html
Table 8.26 Plugin and Library Names for WebAuthn Authentication Plugin or File Plugin or File Name Server-side plugin authentication_webauthn Client-side plugin authentication_webauthn_client Library file authentication_webauthn.so, ... Note ...
https://dev.mysql.com/doc/internals/en/charsets.html
Character sets are recorded against individual tables and returned as part of the field data. You can obtain a list of the available character sets configured within a server by running SHOW COLLATION, or by running a query on the ... Character sets ...
https://dev.mysql.com/doc/ndbapi/en/mccj-using-clusterj-operations.html
To insert a new row into the table, first create a new instance of Employee. This can be accomplished by calling the Session method newInstance(), as shown here: Employee newEmployee = session.newInstance(Employee.class); Set the Employee instance ...For example, the following sets the id, firstName, lastName, and started ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-post-install.html
This includes the server data directory containing the files that implement the privilege tables. In addition to user data, the data directory contains data dictionary and system tables, which store sensitive information about database objects, ...