Shulou(Shulou.com)05/31 Report--

The main content of this article is to explain "what are the knowledge points of mysql". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Next, let the editor take you to learn "what are the knowledge points of mysql?"

Backup viewdb

Mysqldump-uroot-p viewdb > db.sql

Backup tabl

Mysqldump-uroot-p mysql user > user.sql

Open mysql full query log

Slow_query_log=on | off

Slow_query_log_file=filename

Long_query_time=2

Open full query log online

Set global slow_query_log=1

Set global long_query_time=2

Set the slow query time for the current reply

Set long_query_time=2

Show variable like 'long%'

Create a full query

Select sleep (3)

Sleep for 3 seconds to query

Mysql slow query Analysis tool

Mysqldumpslow

Mysqlsla

Percona-toolkit pt-query-digest

Mysqldumpslow filename.log

Categorize the number of mysql queries, average time, lock table time.

. / mysqlsla / var/lib/mysql/host_slow.log

Delete slow query log

Use set to close the full query log

Mysql binary log parameter settings

Long-bin=

Open and work out the binary log file save path and file name

If it is not set, use the default value to store the path to the data file directory by default

Max-binglog-size=500m

Set the maximum value of a single binary log file

Binglog-do-db and binlog-ignore-db

Specify which database operations are recorded by the headset in the log file

Binglog-cache-size=100m

Set the binary cache log size

Sync-binglog=N

Write the binary log in the cache every N seconds. The default value is 0, which is generally set to 1.

The repli environment is generally set to 1, and the following configuration should be enabled

Inodb_flush_log_at_trx_commit=1

Innodb-support-xa=1

At this point, I believe you have a deeper understanding of "what are the knowledge points of mysql?" you might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

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.