DETAILS OF MYSQLTUNER and MY.CNF and SERVER – Please suggest what I can do

I have no idea what should be in my.cnf. Can anyone take a look at this and suggest to me what I should edit the file my.cnf? I'm hosting a Crea8social site. Thank you in advance for any experience you may offer.

HERE IS THE SERVER INFORMATION

Code:

Processor information
Total processors: 8
Processor # 1
Seller
GenuineIntel
First name
Intel (R) Xeon (R) CPU E3-1270 V2 to 3.50GHz
Speed
1600.250 MHz
Cache
8192 KB
Processor # 2
Seller
GenuineIntel
First name
Intel (R) Xeon (R) CPU E3-1270 V2 to 3.50GHz
Speed
1683.349 MHz
Cache
8192 KB
Processor # 3
Seller
GenuineIntel
First name
Intel (R) Xeon (R) CPU E3-1270 V2 to 3.50GHz
Speed
1613.922 MHz
Cache
8192 KB
Processor # 4
Seller
GenuineIntel
First name
Intel (R) Xeon (R) CPU E3-1270 V2 to 3.50GHz
Speed
1607.727 MHz
Cache
8192 KB
Processor # 5
Seller
GenuineIntel
First name
Intel (R) Xeon (R) CPU E3-1270 V2 to 3.50GHz
Speed
1999.938 MHz
Cache
8192 KB
Processor # 6
Seller
GenuineIntel
First name
Intel (R) Xeon (R) CPU E3-1270 V2 to 3.50GHz
Speed
1601.959 MHz
Cache
8192 KB
Processor # 7
Seller
GenuineIntel
First name
Intel (R) Xeon (R) CPU E3-1270 V2 to 3.50GHz
Speed
1914.489 MHz
Cache
8192 KB
Processor # 8
Seller
GenuineIntel
First name
Intel (R) Xeon (R) CPU E3-1270 V2 to 3.50GHz
Speed
1608.581 MHz
Cache
8192 KB

Memory information
[    0.000000] Memory: 5227304k / 34340864k available (kernel code 7664k, 814612k absent, 794872k reserved, 6055k data, initial 1876k)

System information
Linux server1.anymood.org 3.10.0-957.1.3.el7.x86_64 # 1 SMP Thu november 29 14:49:43 UTC 2018 x86_64 x86_64 x86_64 GNU / Linux

Physical discs
[    1.852306] sd 1: 0: 0: 0: [sdb] 976773168 logical blocks of 512 bytes: (500 GB / 465 GiB)
[    1.852360] sd 1: 0: 0: 0: [sdb] Write Protect is disabled
[    1.852361] sd 1: 0: 0: 0: [sdb] Mode sense: 00 3a 00 00
[    1.852379] sd 1: 0: 0: 0: [sdb] Write cache: enabled, read cache: enabled, not compatible with DPO or FUA
[    1.852414] sd 0: 2: 0: 0: [sda] 7812939776 logical blocks of 512 bytes: (4.00 TB / 3.63 TiB)
[    1.852542] sd 0: 2: 0: 0: [sda] Write Protect is disabled
[    1.852544] sd 0: 2: 0: 0: [sda] Mode sense: 1f 00 00 08
[    1.852617] sd 0: 2: 0: 0: [sda] Write cache: enabled, read cache: enabled, not compatible with DPO or FUA
[    1.853274]  sdb: sdb1 sdb2 sdb3
[    1.853547] sd 1: 0: 0: 0: [sdb] Enclosed SCSI disk
[    1.853755] sd 0: 2: 0: 0: [sda] Enclosed SCSI disk
[    5.491483] sd 0: 2: 0: 0: attached scsi generic sg1 type 0
[    5.491529] sd 1: 0: 0: 0: attached scsi generic sg2 type 0


Current memory usage
total used free shared buff / cache available
Mem: 32752400 3456172 27632256 20640 1663972 28889364
Swap: 2097148 0 2097148
Total: 34849548 3456172 29729404

Current disk usage
File system size used Avail Use% Assembled in
/ dev / sdb2 456G 12G 421G 3% /
devtmpfs 16G 0 16G 0% / dev
tmpfs 16G 0 16G 0% / dev / shm
tmpfs 16G 9.0M 16G 1% / run
tmpfs 16G 0 16G 0% / sys / fs / cgroup
/ dev / sdb1 976M 145M 765M 16% / boot
/ dev / loop0 3.9G 8.4M 3.7G 1% / tmp
tmpfs 3.2G 0 3.2G 0% / run / user / 0

MYSQLTUNER EXIT

Code:

[root@server1 ~]# curl -L http://mysqltuner.pl/ | perl
% Total% received% Xferd Average speed Time Time Current time
Total Load Load of Left Spent Speed
0 0 0 0 0 0 0 0 -: -: - -: -: - -: -: - 0
0 0 0 0 0 0 0 0 -: -: - 0:00:01 -: -: - 0
100 216k 100 216k 0 0 111k 0 0:00:01 0:00:01 -: -: - 111k
>> MySQLTuner 1.7.14 - Major Hayden 
 >> Error reports, feature requests and downloads at http://mysqltuner.com/
>> Run with & # 39; - help & # 39; for additional options and output filtering

[--] Verification of the omitted version for the MySQLTuner script
[OK] Currently running MySQL support version 10.2.19-MariaDB
[OK] Operating in 64-bit architecture

-------- Recommendations of the registry file ------------------------------------- - ---------------------------
[--] Log file: /var/lib/mysql/server1.anymood.org.err(24K)
[OK] The log file /var/lib/mysql/server1.anymood.org.err exists
[OK] The log file /var/lib/mysql/server1.anymood.org.err is readable.
[OK] The log file /var/lib/mysql/server1.anymood.org.err is not empty
[OK] The log file /var/lib/mysql/server1.anymood.org.err is smaller than 32 Mb
[!!] /var/lib/mysql/server1.anymood.org.err contains 10 warnings.
[!!] /var/lib/mysql/server1.anymood.org.err contains 6 errors.
[--] 5 start (s) detected in /var/lib/mysql/server1.anymood.org.err
[--] 1) 2018-12-06 22:37:13 140333955983552 [Note] / usr / sbin / mysqld: ready for connections.
[--] 2) 2018-12-06 20:24:22 140083038988480 [Note] / usr / sbin / mysqld: ready for connections.
[--] 3) 2018-12-06 20:01:02 140436577986752 [Note] / usr / sbin / mysqld: ready for connections.
[--] 4) 2018-12-06 20:00:59 140379482245312 [Note] / usr / sbin / mysqld: ready for connections.
[--] 5) 2018-12-06 20:00:50 140368649152704 [Note] / usr / sbin / mysqld: ready for connections.
[--] 5 stops detected in /var/lib/mysql/server1.anymood.org.err
[--] 1) 2018-12-07 0:02:52 140333495113472 [Note] / usr / sbin / mysqld: Full shutdown
[--] 2) 2018-12-06 22:33:36 140082598475520 [Note] / usr / sbin / mysqld: Full shutdown
[--] 3) 2018-12-06 20:24:22 140436442830592 [Note] / usr / sbin / mysqld: Full shutdown
[--] 4) 2018-12-06 20:01:01 140379347396352 [Note] / usr / sbin / mysqld: Full shutdown
[--] 5) 2018-12-06 20:00:59 140368208774912 [Note] / usr / sbin / mysqld: Full shutdown

-------- Storage Engine Statistics ------------------------------------- - ----------------------------
[--] Status: + Aria + CSV + InnoDB + MEMORY + MRG_MyISAM + MyISAM + PERFORMANCE_SCHEMA + SEQUENCE
[--] Data in InnoDB tables: 18.7M (Tables: 100)
[OK] Total of fragmented tables: 0

-------- Analysis performance metrics ------------------------------------- - -----------------------
[--] innodb_stats_on_metadata: OFF
[OK] There are no statistics updates during the INFORMATION_SCHEMA query.

-------- Security recommendations --------------------------------------- - ----------------------------
[OK] There are no anonymous accounts for any user of the database.
[OK] All users of the database have passwords assigned
[!!] There is no list of basic password files!

-------- CVE security recommendations -------------------------------------- - -----------------------
[--] Omitted due to the option --cvefile not defined

-------- Performance Metrics --------------------------------------- - -------------------------------
[--] For: 15m 7s (16K q [17.731 qps], 795 conn, TX: 30M, RX: 2M)
[--] Readings / Writings: 88% / 12%
[--] The binary record is disabled
[--] Physical memory: 31.2G
[--] Maximum MySQL memory: 39.8G
[--] Other process memory: 0B
[--] Total buffers: 20.3G global + 132.4M per thread (151 maximum threads)
[--] P_S Maximum memory usage: 0B
[--] Memory usage Galera GCache Max: 0B
[OK] Maximum memory usage reached: 20.7G (66.18% of installed RAM)
[!!] Maximum possible memory usage: 39.8G (127.44% of installed RAM)
[!!] The possible memory usage in general with another process exceeded the memory
[OK] Slow queries: 0% (0 / 16K)
[OK] Greater use of available connections: 1% (3/151)
[OK] Aborted connections: 0.00% (0/795)
[!!] Name resolution is active: reverse name resolution is performed for each new connection and can reduce performance
[!!] The query cache may be disabled by default due to muting contention.
[!!] Efficiency of the query cache: 0.0% (0 cache / 12K selects)
[OK] Check prunes daily: 0
[OK] Classifications that require temporary tables: 0% (0 temporary classifications / 1K classifications)
[!!] Unions made without indexes: 250
[OK] Temporary tables created on the disk: 23% (275 on disk / 1K in total)
[OK] Thread cache hit rate: 99% (3 created / 795 connections)
[OK] Table cache hit rate: 91% (66 open / 72 open)
[OK] Open file limit used: 0% (23 / 10K)
[OK] Table locks purchased immediately: 100% (17 immediate blocks / 17)

-------- Performance schema --------------------------------------- - --------------------------------
[--] The performance scheme is disabled.
[--] Memory used by P_S: 0B
[--] The scheme of the system is installed.

-------- Metrics of ThreadPool --------------------------------------- - --------------------------------
[--] ThreadPool stat is enabled.
[--] Size of the wire array: 8 threads.
[--] Using the default is enough for your version (10.2.19-MariaDB)

-------- MyISAM Metrics --------------------------------------- - ------------------------------------
[!!] Key buffer used: 18.2% (24M used / 134M cache)
[OK] Key Buffer Size / MyISAM Total Index: 128.0M / 64.0K
[!!] Reading key buffer reading speed: 75.0% (24 cache / 6 reads)

-------- Metrics InnoDB ---------------------------------------- ------------------------------------
[--] InnoDB is enabled.
[--] InnoDB thread: 0
[OK] InnoDB file by table is activated
[OK] Size of InnoDB storage / data pool: 20.0G / 18.7M
[!!] Proportion Size of the InnoDB log file / InnoDB buffer pool size (0.46875%): 48.0M * 2 / 20.0G must be equal to 25%
[!!] InnoDB buffer pool instances: 8
[--] Number of InnoDB buffer pool fragments: 160 for 8 buffer pool instances
[OK] Innodb_buffer_pool_size aligned with Innodb_buffer_pool_chunk_size & Innodb_buffer_pool_instances
[OK] InnoDB Efficiency of the reading buffer: 99.98% (8432336 hits / 8434139 total)
[!!] InnoDB Write Log efficiency: 20.31% (199 hits / 980 total)
[OK] InnoDB registration waits: 0.00% (0 waits / 1179 writings)

-------- Metrics of AriaDB --------------------------------------- - ------------------------------------
[--] AriaDB is enabled.
[OK] Aria page size / total Aria indexes: 128.0M / 1B
[!!] Aria pagecache hit rate: 89.4% (2K in cache / 275 reads)

-------- Metrics TokuDB ---------------------------------------- ------------------------------------
[--] TokuDB is disabled.

-------- Metrics of XtraDB --------------------------------------- - ------------------------------------
[--] XtraDB is disabled.

-------- Galera Metrics ---------------------------------------- - ------------------------------------
[--] Galley is disabled.

-------- Replication metrics --------------------------------------- - -------------------------------
[--] Synchronous Replication Gallery: NO
[--] There are no replication slaves for this server.
[--] Binlog format: MIXED
[--] XA support enabled: ON
[--] Master semi-synchronous replication: not activated
[--] Semi-synchronous replication slave: not activated
[--] This is an independent server

-------- Recommendations ----------------------------------------- ----------------------------------
General recommendations:
Check the warning lines in the file /var/lib/mysql/server1.anymood.org.err
Check the error lines in the file /var/lib/mysql/server1.anymood.org.err
MySQL started in the last 24 hours; the recommendations may be inaccurate
Reduce your overall MySQL memory footprint for system stability
Dedicate this server to your database to obtain maximum performance.
Configure your accounts only with ip or subnets, then update your configuration with skip-name-resolution = 1
Adjust your union queries to always use the indexes.
The performance scheme must be activated for a better diagnosis.
Before changing innodb_log_file_size and / or innodb_log_files_in_group, read this: https://bit.ly/2TcGgtU
Variables to adjust:
*** The maximum memory usage of MySQL is dangerously high ***
*** Add RAM before increasing MySQL buffer variables ***
query_cache_size (= 0)
query_cache_type (= 0)
query_cache_limit (> 1M, or use smaller result sets)
join_buffer_size (> 128.0M, or always use indexes with JOINs)
performance_schema = ON enable PFS
innodb_log_file_size must be (= 2G) if possible, so the total size of the InnoDB log files is equal to 25% of the size of the buffer pool.
innodb_buffer_pool_instances (= 20)

EXISTING MY.CNF

Code:

[mysqld]



local-infile = 0
performance scheme = 0
innodb_buffer_pool_size = 20G
join_buffer_size = 128M
sort_buffer_size = 2M
read_rnd_buffer_size = 2M
socket = / var / lib / mysql / mysql.sock
symbolic links = 0
default-storage-engine = myisam
innodb_file_per_table = 1
max_allowed_packet = 1G
open_files_limit = 10000