Shulou(Shulou.com)06/01 Report--

This article mainly tells you how to configure MYSQL database files and permissions. You can check the relevant professional terms on the Internet or find some related books to supplement them. We will not dabble here, so let's go straight to the topic. I hope this article on how to configure MYSQL database files and permissions can bring you some practical help.

Description of common parameters for "1" MYSQL configuration file:

IP bound after the bind-address:MYSQL instance is started

Port: the port on which the MYSQL instance listens after it is started

Socket: SOCKET file path when logging in to MYSQL in local SOCKET mode

Datadir: home directory of data files related to MYSQL database

Tmpdir: the path where MYSQL saves temporary files

Skip-external-locking: skip external locking

Back_log: the maximum number of connections allowed to be stored in the MYSQL connection request waiting queue

Character-set-server:MYSQL default character set

Key_buffer_size: index buffer, which determines the speed of index processing in MYISAM database

Maximum number of connections allowed by max_connection:MYSQL

Max_connect_errors: after a specified number of client connections, the CVM will block the connection of the host

Table_cache: sets the number of table caches

Max_allowed_packet: the maximum amount of messages transmitted at a time in network transmission

Binlog_cache_size: the cache size that holds binary log SQL statements during a transaction

Sort_buffer_size: the buffer size used by the thread to complete the sort operation

Join_buffer_size: a join buffer will be allocated for each full join between the two tables

Thread_cache_size: the maximum number of threads that can be held in the thread buffer

Thread_concurrency: limits how many threads can enter the kernel at a time

Query_cache_size: the amount of memory allocated for caching query results

Query_cache_limit: query results that exceed the size set by this parameter will not be cached

Ft_min_word_len: the minimum length of words to be indexed

Thread_stack: memory allocated when each connection is created

Transaction_isolation:MYSQL database transaction isolation level

Tmp_table_size: the maximum size of the temporary table

Net_buffer_length: length of buffer used for communication between CVM and customer

Read_rnd_buffer_size: is the MYSQL random read buffer size

Maximum allowed value for max_heap_table_size:HEAP table

The default character set when default_storage_engine:MYSQL creates a table

The path and file name of the log-bin:MYSQL binary BINLOG

Server-id: identifies the unique MYSQL instance when master-slave synchronization

Slow_query_log: whether to enable slow query. A value of 1 means enabling it.

Long_query_time: if it exceeds this value, it is considered as a slow query and recorded in the slow query log.

Log-queries-not-using-indexes: if the SQL statement does not use an index, log the SQL statement to the slow query log

Maximum retention time of expire-logs-days:MYSQL binary log BINLOG

Tables ignored during master-slave synchronization in replicate_wild_ignore_table:MYSQL

Replicate_wild_do_table: in contrast to REPLICATE_WILD_IGNORE_TABLE, specify the tables that need to be synchronized when the master and slave of MYSQL synchronize

Directory of innodb_data_home_dir:INNODB data files

Innodb_file_per_table: start independent tablespaces

Innodb_data_file_path:INNODB data file location

Innodb_log_group_home_dir: the directory path where the INNODB log files are stored

Memory pool size of data catalog information and other internal data structures stored by innodb_additional_mem_pool_size:INNODB

Maximum memory buffer size for table and index data of the innodb_buffer_pool_size:INNODB storage engine

Maximum number of threads for innodb_file_io_threads:I/O operation

Number of innodb_thread_concurrency:INNODB concurrent threads

Innodb_flush_log_at_trx_commit:INNODB log submission method

Innodb_log_buffer_size:INNODB log buffer size

Innodb_log_file_size:INNODB log file size

Innodb_log_files_in_group: the number of posts per day in INODB

Innodb_max_dirty_pages_pct: when the number of dirty pages in memory reaches this proportion of INNODB_BUFFER_POOL size (%), refresh the dirty pages to disk

Deadlock wait time caused by innodb_lock_wait_timeout:INNODB row lock

Slave_compressed_protocol: whether to use compressed transmission BINLOG when master-slave synchronization

Skip-name-resolve: skip domain name resolution

"2" MYSQL permission description:

CREATE: creating databases, tables

DROP: deleting databases, tables

GRANT OPTION: permissions that can be granted to users

REFERENCES: you can create foreign keys

ALTER: modify database, table properties

DELETE: deleting data in a table

INDEX: creating and deleting indexes

INSERT: adding data to a table

SELECT: querying data from tables

UPDATE: modifying data in a table

CREATE VIEW: creating view

SHOW VIEW: definition of display view

ALTER ROUTINE: modifying stored procedures

CREATE ROUTINE: creating stored procedures

EXECUTE: executing stored procedures

FILE: read and write files on the CVM

CREATE TEMPORARY TABLES: creating temporary tables

LOCK TABLES: locking tabl

CREATE USER: creating user

PROCESS: manages the connection process between CVM and customers

RELOAD: overloaded service

REPLICATION CLIENT: for replication

REPLICATION SLAVE: for replication

SHOW DATABASES: displaying database

SHUTDOWN: shut down the CVM

SUPER: superuser

MYSQL database files and permissions should be configured to tell you here, for other related issues you want to know can continue to pay attention to our industry information. Our section will capture some industry news and professional knowledge to share with you every day.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.