Optimizing MySQL/MariaDB for Wordpress/Woocommerce with MySQL Tuner

Hi,
I'm trying to optimize my VPS server for Woocommerce as my store has been running slow. 

Here is my current /etc/my.cnf file.

Code: [Select]

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

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

[mysqld]
performance_schema=ON
innodb_buffer_pool_size=1024M
query_cache_limit=16M
query_cache_size=0
query_cache_type=0
innodb_log_file_size=128M
innodb_buffer_pool_instances=1
tmp_table_size=128M
max_heap_table_size=128M


I followed the steps here to switch my database to innodb: https://www.cloudservices.store/cp/index.php/knowledgebase/63/Tune-MySQL-or-mariadb-database-for-WooCommerce-and-WordPress.html

And now I'm using MySQL Tuner to try and optimize the database.  Here is the following recommendations:

Code: [Select]

-------- Recommendations ---------------------------------------------------------------------------
General recommendations:
    Set up a Password for user with the following SQL statement ( SET PASSWORD FOR 'user'@'SpecificDNSorIp' = PASSWORD('secure_password'); )
    MySQL was started within the last 24 hours - recommendations may be inaccurate
    Reduce or eliminate unclosed connections and network issues
    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
    Consider installing Sys schema from https://github.com/mysql/mysql-sys for MySQL
    Consider installing Sys schema from https://github.com/good-dba/mariadb-sys for MariaDB

Will setting a password for mariadb.sys@localhost or skip-name-resolve=1 create any issues for Cent OS Web Panel?

Also I noticed that https://github.com/good-dba/mariadb-sys for MariaDB only supports 10.0.x is there anything newer that this to add the Sys schema support for MariaDB 10.4.x?

if you don't have idea what you're doing i recommend you  to don't do it

For anyone else asking a similar question.  I found this resource which helped me get started on optimizing MariaDB.

https://gist.github.com/fevangelou/fb72f36bbe333e059b66

@meek2100, the best way to ask somebody who knows how and why it works.