Search Results
https://dev.mysql.com/doc/internals/en/guided-tour-chunk.html
Now, having finished with our bird's eye view of the source code from the air, let's take the perspective of the worms on the ground (which is another name for MySQL's developer staff -- turn on laugh track here). if (updated && (error <= 0 || ...
https://dev.mysql.com/doc/internals/en/memory-allocation-mysql-server.html
The basic logic to use: All things that are used only for the duration of a query are allocated in THD::mem_root through sql_alloc() or thd->alloc() except: Things that may grow, like string buffers of type String. Things in libraries that are ...
https://dev.mysql.com/doc/refman/8.4/en/charset-collate.html
With the COLLATE clause, you can override whatever the default collation is for a comparison.
https://dev.mysql.com/doc/refman/8.4/en/mysql-tzinfo-to-sql.html
The mysql_tzinfo_to_sql program loads the time zone tables in the mysql database. If your system does not have a zoneinfo database, you can use the downloadable package described in Section 7.1.15, “MySQL Server Time Zone Support”. It is used ...
https://dev.mysql.com/doc/refman/8.4/en/replication-statements-replica.html
Section 15.4.1, “SQL Statements for Controlling Source Servers”, discusses statements for managing source servers. In addition to the statements described here, SHOW REPLICA STATUS and SHOW RELAYLOG EVENTS are also used with replicas. For ...
https://dev.mysql.com/doc/refman/8.4/en/replication-statements-source.html
Section 15.4.2, “SQL Statements for Controlling Replica Servers”, discusses statements for managing replica servers. In addition to the statements described here, the following SHOW statements are used with source servers in replication. SHOW ...
https://dev.mysql.com/doc/refman/8.4/en/sql-compound-statements.html
These objects are defined in terms of SQL code that is stored on the server for later invocation (see Chapter 27, Stored Objects). END compound statement and other statements that can be used in the body of stored programs: Stored procedures and ...
https://dev.mysql.com/doc/refman/8.4/en/sql-replication-statements.html
Replication can be controlled through the SQL interface using the statements described in this section. Statements are split into a group which controls source servers, a group which controls replica servers, and a group which can be applied to any ...
https://dev.mysql.com/doc/workbench/en/wb-develop-sql-editor-table-export-import.html
Export or import tables using a wizard to assist you. Export a Table Note Alternatively, use Section 6.5, “Data Export and Import” to export larger sets of data, such as entire tables and databases. Import into Table Note Alternatively, use ...
https://dev.mysql.com/doc/workbench/en/wb-develop-sql-editor-table-search.html
Find data across a MySQL connection by using the text search feature on any number of tables and schemas. From the schema tree, select the tables, schemas, or both to search and then right-click the highlighted items and click Search Data Table ...