Question Slow import speeds my.cnf woocommerce help/advice

[macandrew89]

Wondering what the best my.cnf config would be for my database.

Currently running woocommerce, not a huge amount of products less than 100 but some products have almost 1000 variations.

I'm currently using wp-import to import products but it is becoming pretty slow. I currently have around 25k variations on the db.

I'm currently running a VPS on OVH, 2 cores 8gb ram. Website is low traffic 75-100 visitors a day. using CentOS 6.9 and Plesk.

Disks are SSD ram not being used 4gb only one cpu core is being used phpmysql version 7.0.27

What would be the best config for my site currently only have the below;

[mysqld]

local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

query_cache_type = 1
query_cache_limit = 256K
query_cache_min_res_unit = 2k
query_cache_size = 80M

key_buffer = 1G

table_cache = 256
table_definition_cache = 256

wait_timeout = 120
connect_timeout = 120
interactive_timeout = 120

innodb_flush_method = O_DIRECT
innodb_flush_log_at_trx_commit = 2
innodb_file_per_table = 1
innodb_buffer_pool_size = 1G

 

[macandrew89]

my database currently contains just under 500k tables, 450k of these are contained within postmeta. the products I sell have a large amount of variations,