Search Results
https://dev.mysql.com/doc/internals/en/guided-tour-flow.html
The flow works like this: First, the client routines get an SQL statement from a user, allowing edit, performing initial checks, and so on. Then, via the vio routines, the somewhat-massaged statement goes off to the server. Next, the sql routines ...
https://dev.mysql.com/doc/internals/en/os-directory.html
The files in this directory are the product of the efforts of three people from outside MySQL: Yuri Dario, Timo Maier, and John M Alfredsson.
https://dev.mysql.com/doc/internals/en/row-based-binary-logging.html
Logging in this format can be done independent of whether the log is used for replication. That is, replication need not figure into the use of the binary log at all. Similar remarks apply to the terms "statement-based logging" (SBL) versus ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-query-profiling.html
Performance Schema displays event timer information in picoseconds (trillionths of a second) to normalize timing data to a standard unit. In the following example, TIMER_WAIT values are divided by 1000000000000 to show data in units of seconds. The ... The following example demonstrates how to use Performance Schema statement events and stage events to retrieve data comparable to profiling information provided by SHOW PROFILES and SHOW PROFILE ...
https://dev.mysql.com/doc/refman/8.4/en/set-variable.html
A SET statement that assigns variable values is not written to the binary log, so in replication scenarios it affects only the host on which you execute it. To affect all replication hosts, execute the statement on each host. User-Defined Variable ...variable: { user_var_name | param_name | local_var_name | {GLOBAL | @@GLOBAL.} system_var_name | {PERSIST | @@PERSIST.} system_var_name | {PERSIST_ONLY | @@PERSIST_ONLY.} system_var_name | [SESSION | ...
https://dev.mysql.com/doc/refman/8.4/en/stop-replica.html
When the timeout value is reached, the issuing client returns an error message and stops waiting, but the STOP REPLICA instruction remains in effect. If the replica is stopped unexpectedly (for example due to an error in a worker thread, or another ...Recommended best practice is to execute STOP REPLICA on the replica before stopping the replica server (see Section 7.1.19, “The Server Shutdown Process”, for more ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-fieldtype.html
This class provides all supported MySQL field or data types. They can be useful when dealing with raw data or defining your own converters. The field type is stored with every cursor in the description for each column. The following example shows ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-fieldtype.html
This class provides all supported MySQL field or data types. They can be useful when dealing with raw data or defining your own converters. The field type is stored with every cursor in the description for each column. The following example shows ...
https://dev.mysql.com/doc/refman/8.4/en/program-variables.html
For example, the first of the following lines is legal at program invocation time, but the second is not: $> mysql --max_allowed_packet=16M $> mysql --max_allowed_packet=16*1024*1024 Conversely, the second of the following lines is legal at runtime, ... Many MySQL programs have internal variables that can be set at runtime using the SET ...See Section ...
https://dev.mysql.com/doc/workbench/en/wb-default-schema.html
When you first open MySQL Workbench a default schema, mydb appears as the leftmost tab of the Physical Schemas section of MySQL Workbench as the following figure shows. You can begin designing a database by using this default schema. Figure 9.32 ...