Search Results
https://dev.mysql.com/doc/refman/8.4/en/secure-client-programming.html
If an application generates a query such as SELECT * FROM table WHERE ID=234 when a user enters the value 234, the user can enter the value 234 OR 1=1 to cause the application to generate the query SELECT * FROM table WHERE ID=234 OR 1=1. As a ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-encrypted-innodb.html
For details on how the MySQL server encrypts and decrypts InnoDB tablespaces, see InnoDB Data-at-Rest Encryption—it explains concepts like master key and tablespace keys, which are important for understanding how MySQL Enterprise Backup works with ...Notes Since the keyring_file and the keyring_encrypted_file plugins have been removed from the MySQL Server since release 8.4.0, they are no longer supported by MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndbd.html
The ndbd binary provides the single-threaded version of the process that is used to handle all the data in tables employing the NDBCLUSTER storage engine. Options that can be used with ndbd are shown in the following table. The option also causes ...This data node process enables a data node to accomplish distributed transaction handling, node recovery, checkpointing to disk, online backup, and related ...
https://dev.mysql.com/doc/refman/8.4/en/show-processlist.html
Note An alternative implementation for SHOW PROCESSLIST is available based on the Performance Schema processlist table, which, unlike the default SHOW PROCESSLIST implementation, does not require a mutex and has better performance characteristics.
https://dev.mysql.com/doc/internals/en/item-class.html
To us, the word Item means more than just “thingamabob”; it is a technical term with a precise definition in the context of our source code. In the function category we include operators such as + and ||, because operators are merely functions ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-types.html
MySQL spatial extensions enable the generation, storage, and analysis of geographic features: Data types for representing spatial values Functions for manipulating spatial values Spatial indexing for improved access times to spatial columns The ...
https://dev.mysql.com/doc/workbench/en/wb-preferences-sql-editor.html
For this reason, this facility can be switched off for models containing large numbers of schemas and tables. Figure 3.8 Preferences: SQL Editor: Object Editors Online DDL Default algorithm for ALTER table: [ Default ] Sets the default algorithm ...
https://dev.mysql.com/doc/workbench/en/wb-tutorial-visual-explain-dbt3.html
The initial report shows a Visual Explain image with information that appears when you move your pointer device over the orders table in full table scan. Figure 7.9 DBT-3 Explain Tutorial: Visual Explain with Full Table Scan Optionally, you can ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-examples-programming-net.html
5.6.7.2.1 Using Connector/ODBC with ODBC.NET and C# (C sharp) The following sample creates a table my_odbc_net and demonstrates its use in C#. This section contains simple examples that demonstrate the use of Connector/ODBC drivers with ODBC.NET.
https://dev.mysql.com/doc/internals/en/caching.html
Uses hashing and reverse linked lists for quick caching of the most recently used blocks and quick flushing of changed entries for a specific table. (mysys/mf_keycash.c) Record Cache This is used for quick scanning of all records in a table. (Note ...