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/loading-tables.html
Suppose that Diane gets a new hamster named “Puffball.” You could add a new record using an INSERT statement like this: mysql> INSERT INTO pet VALUES ('Puffball','Diane','hamster','f','1999-03-30',NULL); String and date values are specified as ...You could create a text file pet.txt containing one record per line, with values separated by tabs, and given in the order in which the columns were listed in the CREATE TABLE ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-metrics-table.html
(The _RESET columns act like the lap counter on a stopwatch: you can measure the activity during some time interval, while the cumulative figures are still available in COUNT, MAX_COUNT, and so on.) MAX_COUNT_RESET The maximum counter value since it ...With more detailed queries, you can diagnose issues such as performance bottlenecks, resource shortages, and application ... The INNODB_METRICS table provides a ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-space-requirements.html
If the operation takes a long time and concurrent DML modifies the table so much that the size of the temporary log file exceeds the value of innodb_online_alter_log_max_size, the online DDL operation fails with a DB_ONLINE_LOG_TOO_BIG error, and ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-error-reporter.html
The archive is named ndb_error_report_YYYYMMDDhhmmss.tar.bz2, where YYYYMMDDhhmmss is a datetime string. ndb_error_reporter also accepts the options listed here: --connection-timeout=timeout Command-Line Format --connection-timeout=# Type Integer ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-mutex-instances-table.html
The work performed while holding a mutex is said to be in a “critical section,” and multiple queries do execute this critical section in a serialized way (one at a time), which is a potential bottleneck. When a thread succeeds in locking a ...A ... The mutex_instances table lists all the mutexes seen by the Performance Schema while the server ...
https://dev.mysql.com/doc/refman/8.0/en/x-plugin-system-monitoring.html
Issue: mysql-py> \sql SELECT NAME, ENABLED, TIMED FROM performance_schema.setup_instruments WHERE NAME LIKE 'statement/%' AND NOT (ENABLED and TIMED) If this statement reports at least one row, you need to enable the instruments. When you execute a ... For general X Plugin monitoring, use the status variables that it ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-rotation.html
If you flush the error log using a FLUSH ERROR LOGS or FLUSH LOGS statement, or a mysqladmin flush-logs command, the server closes and reopens any error log file to which it is writing. For example, assuming a log file name of host_name.err, use ...
https://dev.mysql.com/doc/refman/8.0/en/exists-and-not-exists-subqueries.html
If a subquery returns any rows at all, EXISTS subquery is TRUE, and NOT EXISTS subquery is FALSE. For example: SELECT column1 FROM t1 WHERE EXISTS (SELECT * FROM t2); Traditionally, an EXISTS subquery starts with SELECT *, but it could begin with ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-disk-management.html
As a DBA, you must manage disk I/O to keep the I/O subsystem from becoming saturated, and manage disk space to avoid filling up storage devices. Within these constraints, InnoDB tries to optimize the database work and the organization of disk files ...The ACID design model requires a certain amount of I/O that might seem redundant, but helps to ensure data ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-javascript-download.html
You can either: Start MySQL Shell in SQL mode and import the file by issuing: mysqlsh -u root --sql --file /tmp/world_x-db/world_x.sql Enter password: **** Set MySQL Shell to SQL mode while it is running and source the schema file by issuing: \sql ... As part of this quick-start guide, an example schema is provided which is referred to as the world_x ...