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/optimize-benchmarking.html
To measure performance, consider the following factors: Whether you are measuring the speed of a single operation on a quiet system, or how a set of operations (a “workload”) works over a period of time. For benchmarking, sometimes you must ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-config.html
mysql_config provides you with useful information for compiling your MySQL client and connecting it to MySQL. It is a shell script, so it is available only on Unix and Unix-like systems. Note As of MySQL 5.7.9, pkg-config can be used as an ...
https://dev.mysql.com/doc/refman/5.7/en/show-status.html
mysql> SHOW STATUS; +--------------------------+------------+ | Variable_name | Value | +--------------------------+------------+ | Aborted_clients | 0 | | Aborted_connects | 0 | | Bytes_received | 155372598 | | Bytes_sent | 1176560426 | | ... SHOW ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-enabling-monitors.html
When InnoDB monitors are enabled for periodic output, InnoDB writes the output to mysqld server standard error output (stderr) every 15 seconds, approximately. If you want to direct the output to the console window rather than to the error log, ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html
The error message looks like this: InnoDB: Error: table test/parent already exists in InnoDB internal InnoDB: data dictionary. You can drop the orphan table by following the instructions given in the error message. [ERROR] InnoDB: The error means ...
https://dev.mysql.com/doc/refman/5.7/en/constraint-invalid-data.html
MySQL permits you to store certain incorrect date values into DATE and DATETIME columns (such as '2000-02-31' or '2000-02-00'). If you try to store NULL into a column that does not take NULL values, an error occurs for single-row INSERT statements.
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-examples.html
Identifying Blocking Transactions It is sometimes helpful to identify which transaction blocks another. Each session corresponds to a MySQL thread, and executes one transaction after another. For example, if the blocking_pid is 6, issue this query: ...The tables that contain information about InnoDB transactions and data locks enable you to determine which transaction is waiting for another, and which resource is being ...
https://dev.mysql.com/doc/refman/5.7/en/create-user.html
An error occurs if you try to create an account that already exists. If the IF NOT EXISTS clause is given, the statement produces a warning for each named account that already exists, rather than an error. Order of WITH options does not matter, ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-summary-tables.html
Summary tables provide aggregated information for terminated events over time. That might be useful, for example, after you have made a runtime configuration change. The tables in this group summarize event data in different ways. Each summary ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines-privileges.html
Also, the default SQL SECURITY characteristic for a routine is DEFINER, which enables users who have access to the database with which the routine is associated to execute the routine. If the automatic_sp_privileges system variable is 0, the EXECUTE ... The MySQL grant system takes stored routines into account as follows: The CREATE ROUTINE privilege is needed to create stored ...