[Warning] Could not increase number of max_open_files to more than 1024 (request: 32183)

Mar 16 14:33:10 centos8.1 mysql-prepare-db-dir[2205]: https://mariadb.org/get-involved/
Mar 16 14:33:10 centos8.1 mysqld[2308]: 2021-03-16 14:33:10 0 [Note] /usr/libexec/mysqld (mysqld 10.3.27-MariaDB) starting as process 2308 …
Mar 16 14:33:10 centos8.1 mysqld[2308]: 2021-03-16 14:33:10 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 32183)
Mar 16 14:33:10 centos8.1 mysqld[2308]: 2021-03-16 14:33:10 0 [Warning] Changed limits: max_open_files: 1024 max_connections: 151 (was 151) table_cache: 421 (was 2000)
Mar 16 14:33:10 centos8.1 systemd[1]: Started MariaDB 10.3 database server.

解决方法：
1.修改内核参数
vim /etc/security/limits.conf

*               soft    nofile          8192
*               hard    nofile          8192

2.取消限制
vim /usr/lib/systemd/system/mariadb.service
#在[service]下面加

[Service]
LimitNOFILE=infinity

加载配置
systemctl daemon-reload
重启服务
systemctl restart mariadb.service