mysql 8 debian max-limit tasks

If you need to increase max task on your mysql8 server specially on Debian or Ubuntu

# service mysql status


Install MySQL8 with Ubuntu/Debian APT

/lib/systemd/system/mysql.service

[Service]
User=mysql
Group=mysql
Type=notify
PermissionsStartOnly=true
ExecStartPre=/usr/share/mysql-8.0/mysql-systemd-start pre
ExecStart=/usr/sbin/mysqld
TimeoutSec=0
LimitNOFILE = 10000
TasksMax=8096
Restart=on-failure
RestartPreventExitStatus=1

the important was TasksMax which default was 4951

after changing it at /lib/systemd/system/mysql.service

Source
https://www.percona.com/blog/2019/01/02/tasksmax-another-setting-that-can-cause-mysql-error-messages/

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.