mysql access日志_日志写入数据库实战案例

[root@es102.yinzhengjie.com ~]# apt -y install mysql-server

Reading package lists... Done

Building dependency tree

Reading state information... Done

The following additional packages will be installed:

libaio1 libcgi-fast-perl libcgi-pm-perl libencode-locale-perl libevent-core-2.1-6 libfcgi-perl libhtml-parser-perl libhtml-tagset-perl libhtml-template-perl libhttp-date-perllibhttp-message-perl libio-html-perl liblwp-mediatypes-perl libtimedate-perl liburi-perl mysql-client-5.7 mysql-client-core-5.7 mysql-common mysql-server-5.7 mysql-server-core-5.7Suggested packages:

libdata-dump-perl libipc-sharedcache-perl libwww-perlmailx tinyca

The following NEW packages will be installed:

libaio1 libcgi-fast-perl libcgi-pm-perl libencode-locale-perl libevent-core-2.1-6 libfcgi-perl libhtml-parser-perl libhtml-tagset-perl libhtml-template-perl libhttp-date-perllibhttp-message-perl libio-html-perl liblwp-mediatypes-perl libtimedate-perl liburi-perl mysql-client-5.7 mysql-client-core-5.7 mysql-common mysql-server mysql-server-5.7mysql-server-core-5.7

0 upgraded, 21 newly installed, 0 to remove and 83not upgraded.

Need to get19.7MB of archives.

After this operation,156MB of additional disk space will be used.

Get:1 http://mirrors.aliyun.com/ubuntu bionic/main amd64 mysql-common all 5.8+1.0.4 [7,308 B]

Get:2 http://mirrors.aliyun.com/ubuntu bionic-updates/main amd64 libaio1 amd64 0.3.110-5ubuntu0.1 [6,476 B]

Get:3 http://mirrors.aliyun.com/ubuntu bionic-security/main amd64 mysql-client-core-5.7 amd64 5.7.30-0ubuntu0.18.04.1 [6,649 kB]

Get:4 http://mirrors.aliyun.com/ubuntu bionic-security/main amd64 mysql-client-5.7 amd64 5.7.30-0ubuntu0.18.04.1 [1,945 kB]

Get:5 http://mirrors.aliyun.com/ubuntu bionic-security/main amd64 mysql-server-core-5.7 amd64 5.7.30-0ubuntu0.18.04.1 [7,437 kB]

Get:6 http://mirrors.aliyun.com/ubuntu bionic/main amd64 libevent-core-2.1-6 amd64 2.1.8-stable-4build1 [85.9 kB]

Get:7 http://mirrors.aliyun.com/ubuntu bionic-security/main amd64 mysql-server-5.7 amd64 5.7.30-0ubuntu0.18.04.1 [2,929 kB]

Get:8 http://mirrors.aliyun.com/ubuntu bionic/main amd64 libhtml-tagset-perl all 3.20-3 [12.1 kB]

Get:9 http://mirrors.aliyun.com/ubuntu bionic/main amd64 liburi-perl all 1.73-1 [77.2 kB]

Get:10 http://mirrors.aliyun.com/ubuntu bionic/main amd64 libhtml-parser-perl amd64 3.72-3build1 [85.9 kB]

Get:11 http://mirrors.aliyun.com/ubuntu bionic/main amd64 libcgi-pm-perl all 4.38-1 [185 kB]

Get:12 http://mirrors.aliyun.com/ubuntu bionic/main amd64 libfcgi-perl amd64 0.78-2build1 [32.8 kB]

Get:13 http://mirrors.aliyun.com/ubuntu bionic/main amd64 libcgi-fast-perl all 1:2.13-1 [9,940 B]

Get:14 http://mirrors.aliyun.com/ubuntu bionic/main amd64 libencode-locale-perl all 1.05-1 [12.3 kB]

Get:15 http://mirrors.aliyun.com/ubuntu bionic/main amd64 libhtml-template-perl all 2.97-1 [59.0 kB]

Get:16 http://mirrors.aliyun.com/ubuntu bionic/main amd64 libtimedate-perl all 2.3000-2 [37.5 kB]

Get:17 http://mirrors.aliyun.com/ubuntu bionic/main amd64 libhttp-date-perl all 6.02-1 [10.4 kB]

Get:18 http://mirrors.aliyun.com/ubuntu bionic/main amd64 libio-html-perl all 1.001-1 [14.9 kB]

Get:19 http://mirrors.aliyun.com/ubuntu bionic/main amd64 liblwp-mediatypes-perl all 6.02-1 [21.7 kB]

Get:20 http://mirrors.aliyun.com/ubuntu bionic/main amd64 libhttp-message-perl all 6.14-1 [72.1 kB]

Get:21 http://mirrors.aliyun.com/ubuntu bionic-security/main amd64 mysql-server all 5.7.30-0ubuntu0.18.04.1 [9,948 B]

Fetched 19.7 MB in 7s (2,992 kB/s)

Preconfiguring packages ...

Selecting previously unselected package mysql-common.

(Reading database ...126818files and directories currently installed.)

Preparing to unpack .../0-mysql-common_5.8+1.0.4_all.deb ...

Unpacking mysql-common (5.8+1.0.4) ......................................................................................................................................................]

Selecting previously unselected package libaio1:amd64....................................................................................................................................]

Preparing to unpack .../1-libaio1_0.3.110-5ubuntu0.1_amd64.deb ...

Unpacking libaio1:amd64 (0.3.110-5ubuntu0.1) ............................................................................................................................................]

Selecting previously unselected package mysql-client-core-5.7............................................................................................................................]

Preparing to unpack .../2-mysql-client-core-5.7_5.7.30-0ubuntu0.18.04.1_amd64.deb ...

Unpacking mysql-client-core-5.7 (5.7.30-0ubuntu0.18.04.1) ...............................................................................................................................]

Selecting previously unselected package mysql-client-5.7.................................................................................................................................]

Preparing to unpack .../3-mysql-client-5.7_5.7.30-0ubuntu0.18.04.1_amd64.deb ...

Unpacking mysql-client-5.7 (5.7.30-0ubuntu0.18.04.1) ....................................................................................................................................]

Selecting previously unselected package mysql-server-core-5.7............................................................................................................................]

Preparing to unpack .../4-mysql-server-core-5.7_5.7.30-0ubuntu0.18.04.1_amd64.deb ...

Unpacking mysql-server-core-5.7 (5.7.30-0ubuntu0.18.04.1) ...............................................................................................................................]

Selecting previously unselected package libevent-core-2.1-6:amd64........................................................................................................................]

Preparing to unpack .../5-libevent-core-2.1-6_2.1.8-stable-4build1_amd64.deb ...

Unpacking libevent-core-2.1-6:amd64 (2.1.8-stable-4build1) ..............................................................................................................................]

Setting up mysql-common (5.8+1.0.4) ...#####.............................................................................................................................................]

update-alternatives: using /etc/mysql/my.cnf.fallback to provide /etc/mysql/my.cnf (my.cnf) inauto mode.................................................................................]

Selecting previously unselected package mysql-server-5.7.................................................................................................................................]

(Reading database ...126986files and directories currently installed.)

Preparing to unpack .../00-mysql-server-5.7_5.7.30-0ubuntu0.18.04.1_amd64.deb ...

Unpacking mysql-server-5.7 (5.7.30-0ubuntu0.18.04.1) ....................................................................................................................................]

Selecting previously unselected package libhtml-tagset-perl..............................................................................................................................]

Preparing to unpack .../01-libhtml-tagset-perl_3.20-3_all.deb ...

Unpacking libhtml-tagset-perl (3.20-3) ...#############..................................................................................................................................]

Selecting previously unselected package liburi-perl.######...............................................................................................................................]

Preparing to unpack .../02-liburi-perl_1.73-1_all.deb ...

Unpacking liburi-perl (1.73-1) ...##########################.............................................................................................................................]

Selecting previously unselected package libhtml-parser-perl.###..........................................................................................................................]

Preparing to unpack .../03-libhtml-parser-perl_3.72-3build1_amd64.deb ...

Unpacking libhtml-parser-perl (3.72-3build1) ...#################........................................................................................................................]

Selecting previously unselected package libcgi-pm-perl.#############.....................................................................................................................]

Preparing to unpack .../04-libcgi-pm-perl_4.38-1_all.deb ...

Unpacking libcgi-pm-perl (4.38-1) ...################################....................................................................................................................]

Selecting previously unselected package libfcgi-perl.####################................................................................................................................]

Preparing to unpack .../05-libfcgi-perl_0.78-2build1_amd64.deb ...

Unpacking libfcgi-perl (0.78-2build1) ...

Selecting previously unselected package libcgi-fast-perl.####################............................................................................................................]

Preparing to unpack .../06-libcgi-fast-perl_1%3a2.13-1_all.deb ...

Unpacking libcgi-fast-perl (1:2.13-1) ...######################################..........................................................................................................]

Selecting previously unselected package libencode-locale-perl.####################.......................................................................................................]

Preparing to unpack .../07-libencode-locale-perl_1.05-1_all.deb ...

Unpacking libencode-locale-perl (1.05-1) ...########################################.....................................................................................................]

Selecting previously unselected package libhtml-template-perl.#########################..................................................................................................]

Preparing to unpack .../08-libhtml-template-perl_2.97-1_all.deb ...

Unpacking libhtml-template-perl (2.97-1) ...############################################.................................................................................................]

Selecting previously unselected package libtimedate-perl.###################################.............................................................................................]

Preparing to unpack .../09-libtimedate-perl_2.3000-2_all.deb ...

Unpacking libtimedate-perl (2.3000-2) ...####################################################............................................................................................]

Selecting previously unselected package libhttp-date-perl.######################################.........................................................................................]

Preparing to unpack .../10-libhttp-date-perl_6.02-1_all.deb ...

Unpacking libhttp-date-perl (6.02-1) ...##########################################################.......................................................................................]

Selecting previously unselected package libio-html-perl.#############################################....................................................................................]

Preparing to unpack .../11-libio-html-perl_1.001-1_all.deb ...

Unpacking libio-html-perl (1.001-1) ...

Selecting previously unselected package liblwp-mediatypes-perl.###########################################...............................................................................]

Preparing to unpack .../12-liblwp-mediatypes-perl_6.02-1_all.deb ...

Unpacking liblwp-mediatypes-perl (6.02-1) ...##############################################################..............................................................................]

Selecting previously unselected package libhttp-message-perl.#################################################...........................................................................]

Preparing to unpack .../13-libhttp-message-perl_6.14-1_all.deb ...

Unpacking libhttp-message-perl (6.14-1) ...#####################################################################.........................................................................]

Selecting previously unselected package mysql-server.##############################################################......................................................................]

Preparing to unpack .../14-mysql-server_5.7.30-0ubuntu0.18.04.1_all.deb ...

Unpacking mysql-server (5.7.30-0ubuntu0.18.04.1) ...#################################################################....................................................................]

Setting up libhtml-tagset-perl (3.20-3) ...#############################################################################.................................................................]

Setting up libevent-core-2.1-6:amd64 (2.1.8-stable-4build1) ...############################################################..............................................................]

Processing triggersfor ureadahead (0.100.0-21) ...###########################################################################...........................................................]

Setting up libencode-locale-perl (1.05-1) ...

Setting up libtimedate-perl (2.3000-2) ...######################################################################################.........................................................]

Setting up libio-html-perl (1.001-1) ...#############################################################################################....................................................]

Setting up liblwp-mediatypes-perl (6.02-1) ...##########################################################################################.................................................]

Processing triggersfor libc-bin (2.27-3ubuntu1) ...#######################################################################################..............................................]

Setting up libaio1:amd64 (0.3.110-5ubuntu0.1) ...

Setting up liburi-perl (1.73-1) ...###########################################################################################################...........................................]

Processing triggersfor systemd (237-3ubuntu10.38) ...###########################################################################################........................................]

Setting up libhtml-parser-perl (3.72-3build1) ...

Setting up libcgi-pm-perl (4.38-1) ...##############################################################################################################.....................................]

Processing triggersfor man-db (2.8.3-2ubuntu0.1) ...##################################################################################################..................................]

Setting up mysql-client-core-5.7 (5.7.30-0ubuntu0.18.04.1) ...

Setting up libfcgi-perl (0.78-2build1) ...#################################################################################################################..............................]

Setting up libhttp-date-perl (6.02-1) ...###################################################################################################################.............................]

Setting up libhtml-template-perl (2.97-1) ...####################################################################################################################........................]

Setting up mysql-server-core-5.7 (5.7.30-0ubuntu0.18.04.1) ...######################################################################################################.....................]

Setting up libcgi-fast-perl (1:2.13-1) ...#############################################################################################################################..................]

Setting up libhttp-message-perl (6.14-1) ...##############################################################################################################################...............]

Setting up mysql-client-5.7 (5.7.30-0ubuntu0.18.04.1) ...####################################################################################################################............]

Setting up mysql-server-5.7 (5.7.30-0ubuntu0.18.04.1) ...########################################################################################################################........]

update-alternatives: using /etc/mysql/mysql.cnf to provide /etc/mysql/my.cnf (my.cnf) inauto mode################################################################################.......]

Renaming removed key_buffer and myisam-recover options (ifpresent)

Created symlink/etc/systemd/system/multi-user.target.wants/mysql.service → /lib/systemd/system/mysql.service.

Setting up mysql-server (5.7.30-0ubuntu0.18.04.1) ...###############################################################################################################################.....]

Processing triggersfor libc-bin (2.27-3ubuntu1) ...###################################################################################################################################..]

Processing triggersfor systemd (237-3ubuntu10.38) ...

Processing triggersfor ureadahead (0.100.0-21) ...

[root@es102.yinzhengjie.com~]#