Hi,
i’m not a DB Manager, but i’m facing a challenge with one server hosted on Digital ocean.
The Specs are:
32 GB Ram
12 Core
SSD Hard Disk.
i have a data around 1 GB where most of the data is related to Sales invoices.
but when ever i tried to open any report related to analysis or 5 or 6 7 users access the site. it’s start giving errors. i have a doubt that my sql parameters are not correct. here is my.cnf file…
any help will be highly appreciated.
Regards,
Adnan
Import all .cnf files from configuration directory
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mariadb.conf.d/
[mysqld]
innodb-file-format=barracuda
innodb-file-per-table=1
innodb-large-prefix=1
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
skip-grant-tables
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
bind-address = 0.0.0.0
max_allowed_packet=500M
MyISAM
key-buffer-size = 512M
CACHES AND LIMITS
tmp-table-size = 256M
max-heap-table-size = 256M
query-cache-type = 1
query-cache-size = 1024M
max-connections = 500
thread-cache-size = 100
open-files-limit = 65535
table-definition-cache = 4096
table-open-cache = 4096
INNODB
innodb-log-files-in-group = 2
innodb-log-file-size = 2047M
innodb-flush-log-at-trx-commit = 1
innodb-file-per-table = 1
innodb-buffer-pool-size = 26G
LOGGING
log-error = /var/log/mysql/mysql-error.log
log-queries-not-using-indexes = 1
slow-query-log = 1
slow-query-log-file = /var/log/mysql/mysql-slow.log
[mysql]
default-character-set = utf8mb4