Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysqlcheck.html
--bind-address=ip_address Command-Line Format --bind-address=ip_address On a computer having multiple network interfaces, use this option to select which interface to use for connecting to the MySQL server. The mysqlcheck client performs table ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlshow.html
--bind-address=ip_address Command-Line Format --bind-address=ip_address On a computer having multiple network interfaces, use this option to select which interface to use for connecting to the MySQL server. The mysqlshow client can be used to ...
https://dev.mysql.com/doc/refman/8.4/en/null-values.html
For text file import or export operations performed with LOAD DATA or SELECT ... The NULL value means “no data.” NULL can be written in any lettercase. Be aware that the NULL value is different from values such as 0 for numeric types or the ...
https://dev.mysql.com/doc/refman/8.4/en/obtaining-loadable-function-information.html
The Performance Schema user_defined_functions table contains information about the currently installed loadable functions: SELECT * FROM performance_schema.user_defined_functions; The mysql.func system table also lists installed loadable functions, ...The user_defined_functions table lists loadable functions installed using CREATE FUNCTION as well as loadable functions installed automatically by components or ...
https://dev.mysql.com/doc/refman/8.4/en/optimization-indexes.html
The best way to improve the performance of SELECT operations is to create indexes on one or more of the columns that are tested in the query. The index entries act like pointers to the table rows, allowing the query to quickly determine which rows ...
https://dev.mysql.com/doc/refman/8.4/en/optimize-table.html
OPTIMIZE TABLE reorganizes the physical storage of table data and associated index data, to reduce storage space and improve I/O efficiency when accessing the table. The exact changes made to each table depend on the storage engine used by that ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-many-tables.html
Since this overhead only applies to the initial table open operation, to “warm up” a table for later use, access it immediately after startup by issuing a statement such as SELECT 1 FROM tbl_name LIMIT 1. If you have configured non-persistent ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-transaction-management.html
Alternatively, for transactions that consist only of a single SELECT statement, turning on AUTOCOMMIT helps InnoDB to recognize read-only transactions and optimize them. To optimize InnoDB transaction processing, find the ideal balance between the ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-myisam-bulk-data-loading.html
For a MyISAM table, you can use concurrent inserts to add rows at the same time that SELECT statements are running, if there are no deleted rows in middle of the data file. These performance tips supplement the general guidelines for fast inserts ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-queries-myisam.html
Try to avoid complex SELECT queries on MyISAM tables that are updated frequently, to avoid problems with table locking that occur due to contention between readers and writers. Some general tips for speeding up queries on MyISAM tables: To help ...