MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 861 to 869 of 869 total results

« Previous
85
86
87
Next »

https://dev.mysql.com/doc/refman/5.7/en/table-size-limit.html

ALTER TABLE tbl_name MAX_ROWS=1000000000 AVG_ROW_LENGTH=nnn; You have to specify AVG_ROW_LENGTH only for tables with BLOB or TEXT columns; in this case, MySQL cannot optimize the space required based only on the number of rows. The effective ...

6.4.1.12 Test Pluggable Authentication

https://dev.mysql.com/doc/refman/5.7/en/test-pluggable-authentication.html

For example: $> mysql --user=testuser --password Enter password: testpassword The plugin fetches the password as received from the client and compares it with the value stored in the authentication_string column of the account row in the mysql.user ... MySQL includes a test plugin that checks account credentials and logs success or failure to the server error ...

2.9.3 Testing the Server

https://dev.mysql.com/doc/refman/5.7/en/testing-server.html

For more information about mysql, mysqladmin, and mysqlshow, see Section 4.5.1, “mysql — The MySQL Command-Line Client”, Section 4.5.2, “mysqladmin — A MySQL Server Administration Program”, and Section 4.5.7, “mysqlshow — Display ...

8.14.2 Thread Command Values

https://dev.mysql.com/doc/refman/5.7/en/thread-commands.html

A thread can have any of the following Command values: Binlog Dump This is a thread on a replication source for sending binary log contents to a replica. Daemon This thread is internal to the server, not a thread that services a client connection.

8.15.5 Tracing Memory Usage

https://dev.mysql.com/doc/refman/5.7/en/tracing-memory-usage.html

If this limit is reached, the current trace is not extended, which means the trace is incomplete; in this case the MISSING_BYTES_BEYOND_MAX_MEM_SIZE column shows the number of bytes missing from the trace. Each stored trace is a string, which is ...

1.2.1 What is MySQL?

https://dev.mysql.com/doc/refman/5.7/en/what-is-mysql.html

The logical model, with objects such as databases, tables, views, rows, and columns, offers a flexible programming environment. MySQL, the most popular Open Source SQL database management system, is developed, distributed, and supported by Oracle ...

2.3.6 Windows Postinstallation Procedures

https://dev.mysql.com/doc/refman/5.7/en/windows-postinstallation.html

GUI tools exist that perform most of the tasks described in this section, including: MySQL Installer: Used to install and upgrade MySQL products. If necessary, initialize the data directory and create the MySQL grant tables. Windows distributions ...

Chapter 29 MySQL Workbench

https://dev.mysql.com/doc/refman/5.7/en/workbench.html

The Table Editor provides easy-to-use facilities for editing Tables, Columns, Indexes, Triggers, Partitioning, Options, Inserts and Privileges, Routines and Views. MySQL Workbench provides a graphical tool for working with MySQL servers and ...

13.3.7.1 XA Transaction SQL Statements

https://dev.mysql.com/doc/refman/5.7/en/xa-statements.html

To perform XA transactions in MySQL, use the following statements: XA {START|BEGIN} xid [JOIN|RESUME] XA END xid [SUSPEND [FOR MIGRATE]] XA PREPARE xid XA COMMIT xid [ONE PHASE] XA ROLLBACK xid XA RECOVER [CONVERT XID] For XA START, the JOIN and ...