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/information-schema-events-table.html
DEFINER The account named in the DEFINER clause (often the user who created the event), in 'user_name'@'host_name' format. The following statements are equivalent: SELECT EVENT_SCHEMA, EVENT_NAME, DEFINER, TIME_ZONE, EVENT_TYPE, EXECUTE_AT, ... The ...The EVENTS table has these columns: EVENT_CATALOG The name of the catalog to which the event ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-overview.html
Typical users aim to get the best database performance out of their existing software and hardware configurations. Database performance depends on several factors at the database level, such as tables, queries, and configuration settings. Advanced ...As you work on database performance, you start by learning the high-level rules and guidelines for the software side, and measuring performance using wall-clock ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-server.html
To start up MySQL using this method, append a command like the one following to the appropriate startup file: /bin/sh -c 'cd /usr/local/mysql; ./bin/mysqld_safe --user=mysql &' For other systems, consult your operating system documentation to see ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndbd.html
This recovery of data occurs automatically, and requires no user intervention in an NDB Cluster that is running normally. Optionally, you can specify a name for the service; if not set, the service name defaults to ndbd. --logbuffer-size=# ...In an ... The ndbd binary provides the single-threaded version of the process that is used to handle all the data in tables employing the NDBCLUSTER storage ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-system-tables.html
Traditionally, you would get this type of information using the techniques from Section 14.18, “InnoDB Monitors”, setting up InnoDB monitors and parsing the output from the SHOW ENGINE INNODB STATUS statement. The first index is GEN_CLUST_INDEX, ... You can extract metadata about schema objects managed by InnoDB using InnoDB INFORMATION_SCHEMA system ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-usage.html
The system tablespace (space 0, the .ibdata files) can contain user-created tables, but it also contains internal system data, which is never compressed. Creating a Compressed Table in File-Per-Table Tablespace To create a compressed table in a ...
https://dev.mysql.com/doc/refman/5.7/en/macos-installation-notes.html
For use in single user mode, an entry for _mysql (note the underscore prefix) should already exist within the system /etc/passwd file. Choosing "Don't Allow" means this password won't be visible for use. You may need (or want) to create a specific ... You should keep the following issues and notes in mind: As of macOS 10.14 (Majave), the macOS MySQL 5.7 Installer application requires permission to control System Events so it can display a generated (temporary) MySQL root ...
https://dev.mysql.com/doc/refman/5.7/en/column-count-limit.html
The maximum row size for an InnoDB table, which applies to data stored locally within a database page, is slightly less than half a page for 4KB, 8KB, 16KB, and 32KB innodb_page_size settings. InnoDB restricts row size (for data stored locally ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-log-events.html
Table 21.58 Events relating to single user mode Event Priority Severity Level Description SingleUser 7 INFO Entering or exiting single user mode BACKUP Events These events provide information about backups being created or restored. SINGLEUSER ...In ...
https://dev.mysql.com/doc/refman/5.7/en/windows-restrictions.html
This is because the physical address limit on Windows 32-bit is 4GB and the default setting within Windows is to split the virtual address space between kernel (2GB) and user/applications (2GB). The following restrictions apply to use of MySQL on ...Alternatively, to use more than 2GB, use a 64-bit version of ...