Author Topic: Optimizing MySQL/MariaDB for Wordpress/Woocommerce with MySQL Tuner  (Read 6220 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
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?
« Last Edit: September 18, 2020, 06:06:49 AM by meek2100 »

Offline
*****
Re: Optimizing MySQL/MariaDB for Wordpress/Woocommerce with MySQL Tuner
« Reply #1 on: September 18, 2020, 06:55:40 AM »
if you don't have idea what you're doing i recommend you  to don't do it

Offline
*
Re: Optimizing MySQL/MariaDB for Wordpress/Woocommerce with MySQL Tuner
« Reply #2 on: October 01, 2020, 10:43:19 PM »
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

Offline
*****
Re: Optimizing MySQL/MariaDB for Wordpress/Woocommerce with MySQL Tuner
« Reply #3 on: October 03, 2020, 09:50:47 AM »
@meek2100, the best way to ask somebody who knows how and why it works. ;)
You can ask me to solve any problem with your server for some money in pm  ;)
Services Monitoring & RBL Monitoring
http://centos-webpanel.com/services-monitor
Join our Development Team and get paid !
http://centos-webpanel.com/develope-modules-for-cwp

Installation Instructions
http://centos-webpanel.com/installation-instructions
Get Fast Support Here
http://centos-webpanel.com/support-services