Anyone Can recommend me How to Optimize Config ?

[Pasit Chatcharoenkit]

We are have Many User around 10000 user Use Connection Database  and Large Transactions information. Please help suggest Config for Optimize about Server I using Hight Performance We have many cpu core , many memory 5 Server. Use for Keep Database Production Environment. 

Thank you.

[Matt Horwood]

Hey,

We a tool called MySQL tuner to see what config changes will improve the performance -> https://github.com/major/MySQLTuner-perl

[Pasit Chatcharoenkit]

This is Current My Configuration on Mariadb

[mysqld]

# Basic settings

bind-address=0.0.0.0
port=3306
datadir=/var/lib/mysql
binlog_format=row
default_storage_engine=InnoDB
innodb_autoinc_lock_mode=2
query_cache_size=0
query_cache_type=0
max_allowed_packet=64M
wait_timeout=300
interactive_timeout=300
max_connections=20000
thread_cache_size=100
table_open_cache=2000
innodb_buffer_pool_size=8G
innodb_flush_log_at_trx_commit=2
innodb_flush_method=O_DIRECT
innodb_io_capacity=1000
# Galera settings

wsrep_on=ON
wsrep_provider=/usr/lib/galera/libgalera_smm.so
wsrep_provider_options="gcs.fc_limit=256; evs.suspect_timeout=PT120S; evs.inactive_timeout=PT1M; pc.weight=1"
wsrep_cluster_address="gcomm://192.168.29.121,192.168.29.122,192.168.29.123"
wsrep_cluster_name="my_galera_cluster"
wsrep_node_name="mariadb11" # Change this to node2, node3 on other servers
#wsrep_sst_method=rsync
wsrep_sst_method=mariabackup
wsrep_slave_threads=4
wsrep_max_ws_size=2M

# Replication user

wsrep_sst_auth="rep_user:password"

ในวันที่ วันพุธที่ 16 ตุลาคม ค.ศ. 2024 เวลา 13 นาฬิกา 56 นาที 33 วินาที UTC+7 matt.h...@mayden.co.uk เขียนว่า:

[Pasit Chatcharoenkit]

Hi bro , 

Thank you for reply. I will find how to use this tool.

ในวันที่ วันพุธที่ 16 ตุลาคม ค.ศ. 2024 เวลา 13 นาฬิกา 56 นาที 33 วินาที UTC+7 matt.h...@mayden.co.uk เขียนว่า:

Hey,

[Omid Reza Bagheri]

Hey,

Regarding the slow performance you're seeing with your MariaDB database, one thing that could really help is adjusting the `innodb_buffer_pool_size` parameter. This setting controls how much memory MariaDB can use to cache data, and having it set as high as possible can make a big difference in speeding things up.

Ideally, you want to set the `innodb_buffer_pool_size` to around 70-80% of your server's total RAM. So, for example, if your server has 32 GB of RAM, you should aim to set it to about 25-26 GB. This will allow MariaDB to keep more data in memory, which means less disk I/O and faster queries overall. Just make sure you leave enough memory for the OS and other processes.

---------------------------------------------
Omidreza Bagheri
Linux servers administrator
Infrastructure Unit,
Information & Communication Technology Center,
Ferdowsi University of Mashhad

--
You received this message because you are subscribed to the Google Groups "codership" group.
To unsubscribe from this group and stop receiving emails from it, send an email to codership-tea...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/codership-team/9c8d9ab0-d468-42e8-81a5-7caf762cc3a9n%40googlegroups.com.