PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-tablespaces-table.html
It is ready to be dropped or made active again by an ALTER UNDO TABLESPACE ... The INNODB_TABLESPACES table provides metadata about InnoDB file-per-table, general, and undo tablespaces. For related usage information and examples, see Section ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-general-info.html
While many standard MySQL schemas and applications can work using NDB Cluster, it is also true that unmodified applications and database schemas may be slightly incompatible or have suboptimal performance when run using NDB Cluster (see Section ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-pitr.html
To perform point-in-time recovery of NDB Cluster, it is necessary to follow the steps shown here: Back up all NDB databases in the cluster, using the START BACKUP command in the ndb_mgm client (see Section 25.6.8, “Online Backup of NDB Cluster”). Point-in-time recovery—that is, recovery of data changes made since a given point in time—is performed after restoring a full backup that returns the server to its state when the backup was ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-installer-workflow.html
The configuration options presented during this step are specific to the version of database or router that you selected to install. MySQL Installer provides a wizard-like tool to install and configure new MySQL products for Windows. Unlike the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-optimization.html
Applications that monitor databases may make frequent use of Performance Schema tables. Performance Schema indexes are predefined and cannot be dropped, added, or altered. To write queries for these tables most efficiently, take advantage of their ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-status-monitoring.html
However, the content of the tables in the performance_schema database misses events. The Performance_schema_mutex_classes_lost status variable is the only visible sign to indicate that some events were dropped internally due to failure to create ...
https://dev.mysql.com/doc/refman/8.0/en/query-attributes.html
Examples of the ways query attributes may be used: A web application produces pages that generate database queries, and for each query must track the URL of the page that generated it. Because installing and uninstalling the query_attributes ... The ...
https://dev.mysql.com/doc/refman/8.0/en/rename-user.html
However, RENAME USER does not automatically drop or invalidate databases or objects within them that the old user created. RENAME USER old_user TO new_user [, old_user TO new_user] ... An error occurs for old accounts that do not exist or new ...
https://dev.mysql.com/doc/refman/8.0/en/select-optimization.html
Queries, in the form of SELECT statements, perform all the lookup operations in the database. Scalability means that your application can handle more simultaneous users, larger requests, and so on without experiencing a big drop in performance.
https://dev.mysql.com/doc/refman/8.0/en/statement-caching.html
Metadata changes occur for DDL statements such as those that create, drop, alter, rename, or truncate tables, or that analyze, optimize, or repair tables. Reparsing uses the default database and SQL mode that were in effect for the original ... For ...