[Q] The Best my.cnf for 24 core and 48Gb Ram

SaeedTJ

Verified User
Joined
Aug 20, 2017
Messages
34
Hello all
I want to know what is The Best my.cnf for 24 core and 48Gb Ram (using MariaDB 10.3)
I searched but all the answers are about 4 core or 8 core and maximum 32GB Ram
and also I wanna to ask is comments effective in processing?
I do not know if I opened the topic in right place or not so forgive me
 
The mysqltuner script is widely used for my.cnf optimizations: https://raw.githubusercontent.com/major/MySQLTuner-perl/master/mysqltuner.pl

Thank you but no special change occurred :(
before tuning my config was this:

Code:
#
# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

after running the script the recommendation of MYSQLTuner was this:

Code:
-------- Recommendations ---------------------------------------------------------------------------
General recommendations:
    Control warning line(s) into /var/lib/mysql/srv.iranet.co.err file
    MySQL was started within the last 24 hours - recommendations may be inaccurate
    Configure your accounts with ip or subnets only, then update your configuration with skip-name-resolve=1
    When making adjustments, make tmp_table_size/max_heap_table_size equal
    Reduce your SELECT DISTINCT queries which have no LIMIT clause
    Performance schema should be activated for better diagnostics
    Consider installing Sys schema from https://github.com/mysql/mysql-sys
    Before changing innodb_log_file_size and/or innodb_log_files_in_group read this: https://bit.ly/2TcGgtU
Variables to adjust:
    query_cache_size (=0)
    query_cache_type (=0)
    query_cache_limit (> 1M, or use smaller result sets)
    tmp_table_size (> 16M)
    max_heap_table_size (> 16M)
    performance_schema = ON enable PFS
    innodb_buffer_pool_size (>= 517.8M) if possible.
    innodb_log_file_size should be (=16M) if possible, so InnoDB total log files size equals to 25% of buffer pool size.

and this is the result:
Code:
#
# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]

#
# include all files from the config directory
#
query_cache_size = 0
query_cache_type = 0
query_cache_limit = 1M
tmp_table_size = 8G
max_heap_table_size = 8G
performance_schema = ON
innodb_buffer_pool_size = 2G
innodb_log_file_size = 16M
!includedir /etc/my.cnf.d

I see lots of websites which their hardware is half of what I have
but they run WordPress about 3X faster
so whats the problem exactly?
I am really nervous about this
 
Yes but you can't just put everything in what mysqltuner is stating.
There are forums however who can advise on tuning mysql with the resources you have and the output of mysqltuner in mind.
 
Yes but you can't just put everything in what mysqltuner is stating.
There are forums however who can advise on tuning mysql with the resources you have and the output of mysqltuner in mind.

as I said I searched about it and found for 32Gb RAM and 4 core
I think there is no way for optimizing my.cnf for my hardware config
but anyway thank you for your reply <3
 
Back
Top