Search Results
https://dev.mysql.com/doc/refman/8.4/en/partitioning.html
Note Table partitioning differs from partitioning as used by window functions. In MySQL 8.4, partitioning support is provided by the InnoDB and NDB storage engines. MySQL 8.4 does not currently support partitioning of tables using any storage engine ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-statements-current-table.html
The table stores one row per thread showing the current status of the thread's most recent monitored statement event, so there is no system variable for configuring the table size. Of the tables that contain statement event rows, ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-connection-configuration-table.html
This table shows the configuration parameters used by the replica for connecting to the source. Parameters stored in the table can be changed at runtime with the CHANGE REPLICATION SOURCE TO statement. It contains values that define how the replica ...
https://dev.mysql.com/doc/refman/8.4/en/persisted-system-variables.html
The MySQL server maintains system variables that configure its operation. A system variable can have a global value that affects server operation as a whole, a session value that affects the current session, or both. Many system variables are ...
https://dev.mysql.com/doc/refman/8.4/en/replication-formats.html
Replication works because events written to the binary log are read from the source and then processed on the replica. The events are recorded within the binary log in different formats according to the type of event. The different replication ...
https://dev.mysql.com/doc/refman/8.4/en/resource-groups.html
MySQL supports creation and management of resource groups, and permits assigning threads running within the server to particular groups so that threads execute according to the resources available to the group. Group attributes enable control over ...
https://dev.mysql.com/doc/refman/8.4/en/security-plugins.html
MySQL includes several components and plugins that implement security features: Plugins for authenticating attempts by clients to connect to MySQL Server. For general discussion of the authentication process, see Section 8.2.17, “Pluggable ...
https://dev.mysql.com/doc/refman/8.4/en/set-password.html
SET PASSWORD [FOR user] auth_option [REPLACE 'current_auth_string'] [RETAIN CURRENT PASSWORD] auth_option: { = 'auth_string' | TO RANDOM } The SET PASSWORD statement assigns a password to a MySQL user account. The password may be either explicitly ...
https://dev.mysql.com/doc/refman/8.4/en/sql-prepared-statements.html
Using prepared statements with placeholders for parameter values has the following benefits: Less overhead for parsing the statement each time it is executed. Typically, database applications process large volumes of almost-identical statements, ...
https://dev.mysql.com/doc/refman/8.4/en/table-size-limit.html
The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits. For up-to-date information operating system file size limits, refer to the documentation ...