PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-example-data.html
mysql> We simply use the MySQL server's root account and assume that you have followed the standard security precautions for installing a MySQL server, including setting a strong root password. Setting or changing MySQL user accounts (including the ...If no primary key is defined by the user when a table is created, the NDBCLUSTER storage engine automatically generates a hidden ...
https://dev.mysql.com/doc/refman/5.7/en/bnl-bka-optimization.html
Then the BKA algorithm builds keys to access the table to be joined for all rows in the buffer and submits these keys in a batch to the database engine for index lookups. For BKA to be used, the batched_key_access flag of the optimizer_switch system ...Benefits of BKA include improved join performance due to more efficient table ... In MySQL, a Batched Key Access (BKA) Join ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-locking-reads.html
All locks set by LOCK IN SHARE MODE and FOR UPDATE queries are released when the transaction is committed or rolled back. Here, LOCK IN SHARE MODE is not a good solution because if two users read the counter at the same time, at least one of them ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-system-tables.html
Traditionally, you would get this type of information using the techniques from Section 14.18, “InnoDB Monitors”, setting up InnoDB monitors and parsing the output from the SHOW ENGINE INNODB STATUS statement. The first index is GEN_CLUST_INDEX, ... You can extract metadata about schema objects managed by InnoDB using InnoDB INFORMATION_SCHEMA system ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-events-table.html
DEFINER The account named in the DEFINER clause (often the user who created the event), in 'user_name'@'host_name' format. The following statements are equivalent: SELECT EVENT_SCHEMA, EVENT_NAME, DEFINER, TIME_ZONE, EVENT_TYPE, EXECUTE_AT, ... The ...The EVENTS table has these columns: EVENT_CATALOG The name of the catalog to which the event ...
21.7.9.1 NDB Cluster Replication: Automating Synchronization of the Replica to the Source Binary Log
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-auto-sync.html
#!/user/bin/perl -w # file: reset-replica.pl # Copyright (c) 2005, 2020, Oracle and/or its affiliates. The following Perl script reset-replica.pl serves as an example of how you can do this. # This program is distributed in the hope that it will be ... It is possible to automate much of the process described in the previous section (see Section 21.7.9, “NDB Cluster Backups With NDB Cluster ...
https://dev.mysql.com/doc/refman/5.7/en/query-cache-configuration.html
Setting the GLOBAL query_cache_type value determines query cache behavior for all clients that connect after the change is made. Individual clients can control cache behavior for their own connection by setting the SESSION query_cache_type value.
https://dev.mysql.com/doc/refman/5.7/en/optimize-overview.html
Typical users aim to get the best database performance out of their existing software and hardware configurations. Database performance depends on several factors at the database level, such as tables, queries, and configuration settings. Advanced ...As you work on database performance, you start by learning the high-level rules and guidelines for the software side, and measuring performance using wall-clock ...
https://dev.mysql.com/doc/refman/5.7/en/resignal.html
The last (stacked) diagnostics area, which has the condition areas that were set up before the handler took control. SET is not an exception, it clears, performs the operation, and produces a result of “success.” The diagnostics area stack now ...RESIGNAL may change some or all information before passing it ...RESIGNAL also can make some procedures shorter if a given handler can handle part of a ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-usage.html
The system tablespace (space 0, the .ibdata files) can contain user-created tables, but it also contains internal system data, which is never compressed. Creating a Compressed Table in File-Per-Table Tablespace To create a compressed table in a ...