10 MySQL customer startup options you should know

Source: Internet
Author: User
Most server administrators know that the MySQL database management system (RDBMS) is a highly flexible software block with a wide range of startup options that can be used to modify related behaviors. However, most people do not know that the standard MySQL client has an equivalent number of startup options, some of which are extremely useful in daily MySQL interaction. These options are not a secret.

Most server administrators know that the MySQL database management system (RDBMS) is a highly flexible software block with a wide range of startup options that can be used to modify related behaviors. However, most people do not know that the standard MySQL client has an equivalent number of startup options, some of which are extremely useful in daily MySQL interaction. These options are not a secret.

Most server administrators know that the MySQL database management system (RDBMS) is a highly flexible software block with a wide range of startup options that can be used to modify related behaviors. However, most people do not know that the standard MySQL client has an equivalent number of startup options, some of which are extremely useful in daily MySQL interaction. These options are not "secret" in themselves, but many of them are not used, and some of them can significantly facilitate the process of server interaction.

Table A shows some of the well-known MySQL client startup options. Each entry in the table explains the functions and usage of each option. This will give you some ideas about MySQL application scope and depth, and help you complete daily application development.

Table

Option

Function

When to use

Compression

This option compresses the upstream and downstream data packet transmission between the customer and the server. Assume that both ends of the connection support this compression.

This option improves the performance when the communication bandwidth is restricted-for example, using a slow network connection

Debugging

This option forces MySQL to write debugging data to a specified log file, including startup and shutdown, and process processing. It can be used in combination with other debugging information options of -- debug-info.

When handling experienced servers or customers, use this option to obtain detailed MySQL diagnostic information.

Force

This option forces MySQL to continue processing SQL commands, even when an error occurs.

Use this option in the automated installation/uninstallation Program-for example, when you try to add a large number of injection records to the database as part of the program installation and do not want to copy entries to interrupt the process

Pager

This option exports the MySQL query output to an external "pager" program, such as cat, with few or more

This option is used when your query returns a large result setting, and you want to flip the page through interactive screen

Xml

This option is used to format your MySQL query results as well-formatted XML

When you want to output the query package in a standard format, it is usually used as a prelude to a combination with a third-party program.

Single-Database

In addition to the database naming options, this option tells MySQL to ignore all commands.

Use this option to leak actions related to a single database from the SQL Injection file, or skip a database update.

Letter T

This option allows you to record all query output logs to an external file.

,

Use this option when you need a transaction processing record, or for future reference, or to retain the audit Index

-- Wait

Wait

In general, if you cannot connect to the server, the MySQL client will automatically interrupt the exception. This option forces it to wait for the defined interval and then try again.

Use this option to cut down on keystrokes when attempting to contact a remote or non-responsive MySQL server.

When you try to connect to a remote or unresponsive MySQL server, use this option to disconnect the key

Security Update

This option tells MySQL to ignore all unqualified DML commands-that is, this command does not contain filtering criteria, such as the WHERE, LIMIT or HAVING clause. This provides a security network that prevents accidental modification or deletion of the entire table or database.

This option is used when you automatically protect yourself from dangerous queries, which may cause damage or loss of widely distributed data

-- Prompt

Prompt

This option allows you to change the standard mysql> command prompt to use various undefined formats.

Using this option will enable your MySQL to print useful navigation or temporary information-for example, the current date or time, server statistics and mud location at the database/list level

You can read more related content (and other options.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.