Search Results
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.dfs-san.html
When system administrators attempt to set up MySQL and MySQL Enterprise Backup in an environment that uses a distributed file system (DFS) or a storage access network (SAN), the MySQL server, the server's data directory, MySQL Enterprise Backup, ...
https://dev.mysql.com/doc/refman/8.4/en/glossary.html
A company might establish policies regarding salary maximums, minimums, and adjustments, in addition to basic sanity checks such as the salary not being a negative number. For example, applications might be able to access a database server over a ...
https://dev.mysql.com/doc/refman/8.4/en/order-by-optimization.html
This section describes when MySQL can use an index to satisfy an ORDER BY clause, the filesort operation used when an index cannot be used, and execution plan information available from the optimizer about ORDER BY. An ORDER BY with and without ...
https://dev.mysql.com/doc/internals/en/optimizer-order-by-clauses.html
In general, the optimizer will skip the sort procedure for the ORDER BY clause if it sees that the rows will be in order anyway. For the query: SELECT column1 FROM Table1 ORDER BY 'x'; the optimizer will throw out the ORDER BY clause. For the ...
https://dev.mysql.com/doc/internals/en/row-order-within-result-sets.html
Please keep in mind that the row order within a significant number of result sets depends on storage engine properties and in worst cases the current load (NDB!, partitioning?, parallel query?) on the testing box. Either use --sorted_result SELECT ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-_query-ordering.html
Ordering 4.3.1.20.1 Synopsis public static final class Query.Ordering extends, Enum<Ordering> {// Public Static Fields public static final Ordering ASCENDING ; public static final Ordering DESCENDING ;// Public Static Methods public static Ordering ...
https://dev.mysql.com/doc/refman/8.4/en/server-system-variables.html
The server permits the client to connect but puts it in sandbox mode. If disconnect_on_expired_password: is disabled, the server permits the client to connect but puts it in sandbox mode. sql_mode Command-Line Format --sql-mode=name System Variable ... The MySQL server maintains many system variables that affect its ...
https://dev.mysql.com/doc/refman/8.4/en/lock-order-tool.html
The MySQL server is a multithreaded application that uses numerous internal locking and lock-related primitives, such as mutexes, rwlocks (including prlocks and sxlocks), conditions, and files. Within the server, the set of lock-related objects ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-parameters.html
(In practice, it is most valuable for MySQL systems with hundreds or thousands of simultaneous connections.) For more information, see Section 17.8.4, “Configuring Thread Concurrency for InnoDB”. On some systems where InnoDB data and log files ... InnoDB Startup Options InnoDB System Variables System variables that are true or false can be enabled at server startup by naming them, or disabled by using a --skip- ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-options-variables.html
This section provides information about MySQL server options, server and status variables that are specific to NDB Cluster. For general information on using these, and for other options and variables not specific to NDB Cluster, see Section 7.1, ...