Search Results
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-truncate-all-tables.html
Truncates all Performance Schema summary tables, resetting all aggregated instrumentation as a snapshot. Parameters in_verbose BOOLEAN: Whether to display each TRUNCATE TABLE statement before executing it. Example mysql> CALL ...
https://dev.mysql.com/doc/workbench/en/wb-what-is-new-60.html
Figure 1.41 Cascading SELECT Table Templates Define templates of tables with commonly used columns, to be used to create new tables in a live connection or in an EER model. In the SQL Editor, choose Create Table Like, or in Modeling, use the right ...Figure 1.36 Comparing the SQL Editor interface for Workbench 5.2 and 6.0 Table Data Search You can select schemas, tables, or both to perform client-side searches for user specified strings and ...
https://dev.mysql.com/doc/refman/8.4/en/insert-on-duplicate.html
In general, you should try to avoid using an ON DUPLICATE KEY UPDATE clause on tables with multiple unique indexes. It is possible to use IGNORE with ON DUPLICATE KEY UPDATE in an INSERT statement, but this may not behave as you expect when ... If ...
https://dev.mysql.com/doc/ndbapi/en/overview-operations.html
Create a scan operation (NdbScanOperation) on this table myOperation= myTransaction->getNdbScanOperation(myTable); // 3. We have created a very simple benchmark to check the performance of each of these. Unique key accesses are similar to primary ...
https://dev.mysql.com/doc/refman/8.4/en/connection-access.html
The server performs identity and credentials checking using columns in the user table, accepting the connection only if these conditions are satisfied: The client host name and user name match the Host and User columns in some user table row. When ...
https://dev.mysql.com/doc/refman/8.4/en/sql-prepared-statements.html
To create a test case that reproduces a problem with prepared statements, so that you can file a bug report. If you create a prepared statement within a stored routine, it is not deallocated when the stored routine ends. To guard against too many ...
https://dev.mysql.com/doc/refman/8.4/en/string-type-syntax.html
In some cases, MySQL may change a string column to a type different from that given in a CREATE TABLE or ALTER TABLE statement. Specifying the CHARACTER SET binary attribute for a character string data type causes the column to be created as the ...
https://dev.mysql.com/doc/refman/8.4/en/optimizer-statistics.html
The table is persistent so that column statistics need not be created each time the server starts. This histogram type is created when the number of distinct values in the column is less than or equal to the number of buckets specified in the ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor-indexes-tab.html
The Indexes subtab contains all of the index information for your table. The following figure shows an example of the layout with the PRIMARY index of the customer table selected and both the index columns and index options shown. Figure 8.15 The ...Click an index name to display the Index Columns section with information about the selected ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor-partitioning-tab.html
To enable partitioning for your table, check the Enable Partitioning check box. Figure 8.18 The Partitioning Tab The Partition By pop-up menu displays the types of partitions you can create: HASH LINEAR HASH KEY LINEAR KEY RANGE LIST Use the ...