PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/spatial-convenience-functions.html
If any geometry argument is not a syntactically well-formed geometry byte string, an ER_GIS_INVALID_DATA error occurs. The only valid empty geometry is represented in the form of an empty geometry collection value. ST_IsValid() works only for the ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-server-clients.html
"mysql_read_default_file=/usr/local/mysql/data/my.cnf"; $dbh = DBI->connect($dsn, $user, $password); See Section 27.9, “MySQL Perl API”. On Unix, set the MYSQL_UNIX_PORT and MYSQL_TCP_PORT environment variables to point to the Unix socket file ...For TCP/IP connections, you may also need to specify --host and --port ...Start the client with --protocol=TCP to connect using TCP/IP, --protocol=SOCKET to connect using a Unix socket file, --protocol=PIPE to ...
https://dev.mysql.com/doc/refman/5.7/en/replication-snapshot-method.html
For more information, see Section 4.5.4, “mysqldump — A Database Backup Program”. For InnoDB, all tables in all databases are stored in the system tablespace files, unless you have the innodb_file_per_table option enabled. The following files ... If the database on the source contains existing data it is necessary to copy this data to each ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-spin_lock_polling.html
InnoDB mutexes and rw-locks are typically reserved for short intervals. On a multi-core system, it can be more efficient for a thread to continuously check if it can acquire a mutex or rw-lock for a period of time before it sleeps. InnoDB minimizes ...If the mutex or rw-lock becomes available during this period, the thread can continue immediately, in the same time ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-importing-data.html
Within a mysql client session, you can perform the import using the following SQL statements: SET ndb_use_transactions=0; SET foreign_key_checks=0; source path/to/dumpfile; SET ndb_use_transactions=1; SET foreign_key_checks=1; When performing the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-schema.html
This type of tuning is primarily for expert users who evaluate optimization strategies to overcome performance bottlenecks. To view InnoDB-related instruments, you can query the setup_instruments table for instrument names that contain 'innodb'.
https://dev.mysql.com/doc/refman/5.7/en/triggers.html
Additional Resources You may find the MySQL User Forums helpful when working with triggers. A trigger is a named database object that is associated with a table, and that activates when a particular event occurs for the table. A trigger can be set ...Some uses for triggers are to perform checks of values to be inserted into a table or to perform calculations on values involved in an ...
https://dev.mysql.com/doc/refman/5.7/en/error-message-elements.html
As just illustrated, the client may display the error message so the user can take corrective measures. Error Message Sources Error Message Elements Error Message Sources Error messages can originate on the server side or the client side: On the ...
https://dev.mysql.com/doc/refman/5.7/en/show-engine.html
An internal buffer that is exposed as a table in the performance_schema database is named after the table, without parentheses. The Status information is in the form of comma-delimited set of name/value pairs. SHOW ENGINE engine_name {STATUS | ...
https://dev.mysql.com/doc/refman/5.7/en/log-file-maintenance.html
For the binary log, you can set the expire_logs_days system variable to expire binary log files automatically after a given number of days (see Section 5.1.7, “Server System Variables”). To rename the general query log or slow query log at ...On ... As described in Section 5.4, “MySQL Server Logs”, MySQL Server can create several different log files to help you see what activity is taking ...