PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-ndb-sync-excluded-objects-table.html
This table provides information about NDB database objects which cannot be automatically synchronized between NDB Cluster's dictionary and the MySQL data dictionary. Example information about NDB database objects which cannot be synchronized with ...row *************************** SCHEMA_NAME: NULL NAME: lg1 TYPE: LOGFILE GROUP REASON: Injected failure *************************** ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-setup-instruments-table.html
When an instrument is enabled and executed, instrumented instances are created, which are visible in the xxx_instances tables, such as file_instances or rwlock_instances. This column uses the SET data type, so multiple flags from the following list ... The setup_instruments table lists classes of instrumented objects for which events can be collected: mysql> SELECT * FROM performance_schema.setup_instruments\G *************************** ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-backups-read-only.html
You should not attempt to use these instructions to make a binary backup by copying files directly because the server may still have modified data cached in memory and not flushed to disk. Note The instructions in this section place the server to be ...The following instructions describe how to do this for a source and for a ...This strategy applies to backing up a source in a ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-views.html
The view with the x$ prefix that displays the same values in raw form is intended more for use with other tools that perform their own processing on the data. The sys schema contains many views that summarize Performance Schema tables in various ...
https://dev.mysql.com/doc/refman/8.0/en/drop-database.html
In this case, you must remove any remaining files or directories manually and issue the DROP DATABASE statement again. IF EXISTS is used to prevent an error from occurring if the database does not exist. The DROP DATABASE statement removes from the ... DROP {DATABASE | SCHEMA} [IF EXISTS] db_name DROP DATABASE drops all tables in the database and deletes the ...
https://dev.mysql.com/doc/refman/8.0/en/charset-gb18030.html
Chinese characters are sorted according to the Pinyin collation defined in the Unicode Common Locale Data Repository (CLDR 24). In MySQL, the gb18030 character set corresponds to the “Chinese National Standard GB 18030-2005: Information ...Case ...
https://dev.mysql.com/doc/refman/8.0/en/counting-rows.html
The use of COUNT() in conjunction with GROUP BY is useful for characterizing your data under various groupings. Counting the total number of animals you have is the same question as “How many rows are in the pet table?” because there is one ...
https://dev.mysql.com/doc/refman/8.0/en/semijoins.html
It must not contain any aggregate functions (whether it is explicitly or implicitly grouped). The statement must not use the STRAIGHT_JOIN join type in the outer query. The number of outer and inner tables together must be less than the maximum ...
https://dev.mysql.com/doc/refman/8.0/en/full-text-adding-collation.html
General information about adding collations is given in Section 12.14, “Adding a Collation to a Character Set”; it is assumed that you have read it and are familiar with the files involved. The instructions here add a collation for a simple ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-enterprise-backup.html
For these reasons, hot backups are desirable when your database “grows up” -- when the data is large enough that the backup takes significant time, and when your data is important enough to your business that you must capture every last change, ...The product is architected for efficient and reliable backups of tables created by the InnoDB storage ...