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/loading-tables.html
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 statement. In its simplest form, you supply values for each column, in ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-accounts-table.html
The accounts table contains a row for each account that has connected to the MySQL server. For each account, the table counts the current and total number of connections. To set the table size explicitly, set the performance_schema_accounts_size ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-hosts-table.html
The hosts table contains a row for each host from which clients have connected to the MySQL server. For each host name, the table counts the current and total number of connections. To set the table size explicitly, set the ...This is NULL for an ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-applier-status-by-worker-table.html
If the replica is not multithreaded, this table shows the status of the applier thread. Otherwise, the replica uses multiple worker threads and a coordinator thread to manage them, and this table shows the status of the worker threads. For a ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-applier-status-table.html
This table shows the current general transaction execution status on the replica. The table provides information about general aspects of transaction applier status that are not specific to any thread involved. Thread-specific status information is ...There is always a default replication channel, and more replication channels can be ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-connection-configuration-table.html
This table shows the configuration parameters used by the replica for connecting to the source. Parameters stored in the table can be changed at runtime with the CHANGE MASTER TO statement, as indicated in the column descriptions. The column ...It ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-instruments-table.html
The setup_instruments table lists classes of instrumented objects for which events can be collected: mysql> SELECT * FROM performance_schema.setup_instruments; +---------------------------------------------------+---------+-------+ | NAME | ENABLED ...| stage/sql/end | NO | NO | | stage/sql/executing | NO | NO | | stage/sql/init | NO | NO | | stage/sql/insert | NO | NO | ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-timers-table.html
To avoid unpredictable results after you make timer changes, use TRUNCATE TABLE to reset Performance Schema statistics. The setup_timers table has these columns: NAME The type of instrument the timer is used for. The setup_timers.TIMER_NAME value ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-users-table.html
The users table contains a row for each user who has connected to the MySQL server. For each user name, the table counts the current and total number of connections. To set the table size explicitly, set the performance_schema_users_size system ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-defragmenting.html
To speed up index scans, you can periodically perform a “null” ALTER TABLE operation, which causes MySQL to rebuild the table: ALTER TABLE tbl_name ENGINE=INNODB You can also use ALTER TABLE tbl_name FORCE to perform a “null” alter operation ...One symptom of fragmentation is that a table takes more space than it “should” ... Random ...