Search Results
https://dev.mysql.com/doc/workbench/en/wb-migration-install-odbc-drivers.html
For each RDBMS, you need its corresponding ODBC driver, which must also be installed on the same machine that MySQL Workbench is running on. Typically you need to provide a name for the data source (the DSN), in addition to the database server IP, ...This driver is usually provided by the RDBMS manufacturer, but in some cases they can also be provided by third party vendors or open source ...
https://dev.mysql.com/doc/internals/en/support-for-insert.html
A basic storage engine could simply advance to the end of the data file and append the contents of the buffer directly (this would also make reading rows easier as you could read the row and pass it directly into the buffer parameter of the ...*/ if ... Once you have read support in your storage engine, the next feature to implement is support for INSERT ...With INSERT support in place, your ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-utilities.html
show errors Display errors captured during the execution of the utilities. show last error Display the last error captured during the execution of the utilities help | help commands Show this list. These utilities encapsulate a set of primitive ...
https://dev.mysql.com/doc/workbench/en/wb-view-editor.html
To invoke the view editor, double-click a view object on the EER Diagram canvas or double-click a view in the Physical Schemas section on the MySQL Model page. This opens the view editor docked at the bottom of the application. Any number of views ...
https://dev.mysql.com/doc/workbench/en/wb-scripting-shell-window.html
Figure C.2 The Workbench Scripting Shell: Snippets Opened script file tabs are to the right of the Snippets tab. Script tabs are labeled with the script's filename, or Unnamed for snippets without a name. While individual commands can be entered ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log.html
InnoDB support for two-phase commit in XA transactions ensures that the binary log and InnoDB data files are synchronized. MySQL binary log files and relay log files can be encrypted, helping to protect these files and the potentially sensitive data ... The binary log contains “events” that describe database changes such as table creation operations or changes to table ...It also contains events for ...
https://dev.mysql.com/doc/workbench/en/wb-what-is-new-61.html
It also displays traditional EXPLAIN output in a separate tab, and the Raw Explain Data (as JSON) in another. This section summarizes many of the new features added to MySQL Workbench 6.1, in relation to the MySQL Workbench 6.0 release. New ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-mysqlserver-ddlstatementactivity-category.html
Table 6.5 DDL Statement Activity Metrics NameDescriptionAlter DB (Delta) The total number of ALTER DATABASE statements executed. Alter DB Upgrade (Delta) The total number of ALTER DATABASE ... Create DB (Delta) The total number of CREATE DATABASE ...
https://dev.mysql.com/doc/mysql-installer/en/mysql-installer-change-path-proc.html
Note Starting with MySQL Installer 1.4.39, if you move the data directory of an installed server manually, MySQL Installer identifies the change and can process a reconfiguration operation without errors. You can change the default installation ...
https://dev.mysql.com/doc/refman/8.4/en/connection-options.html
The password must be given interactively; it cannot be stored in a file. --ssl-session-data=file_name Command-Line Format --ssl-session-data=file_name Type File name The path name of the client SSL session data file in PEM format for session reuse.