optimize Database to prevent slow MySQL queries

I need optimize Database because is generating the slow MySQL queries and my website goind down for heavy file [login to view URL] My website is developed with wordpress/woocommerce with template Flatsome My hosting is siteground and below you can see the message about last Technical Support -------------------------- The previous error was caused by the fact that the server ran out of disk space. Most of the disk space is used by the MySQL slow log. That is the log that stores the slow MySQL queries that your sites are executing on the server. I have managed to free some disk space on the server, however I have noticed that for just a few minutes, the log size increased with more than 500MB. The size of the entire log is currently ~26GB: [/home/eshopdan/public_html]# du -sh /var/lib/mysql/[login to view URL] 26G /var/lib/mysql/[login to view URL] Below are some of the entries in that log: [/home/eshopdan/public_html]# tail -n2 /var/lib/mysql/[login to view URL] SET timestamp=1536344131; INSERT INTO `wpim_options` (`option_name`, `option_value`, `autoload`) VALUES ('_wpml_transient__wpml_st_mo_scan_in_progress', 'a:2:{s:5:\"value\";i:1;s:10:\"expiration\";i:1536344429;}', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`); root@[login to view URL] [/home/eshopdan/public_html]# tail -n3 /var/lib/mysql/[login to view URL] # Bytes_sent: 14 SET timestamp=1536344131; INSERT INTO `wpim_options` (`option_name`, `option_value`, `autoload`) VALUES ('_wpml_transient__wpml_st_mo_scan_in_progress', 'a:2:{s:5:\"value\";i:1;s:10:\"expiration\";i:1536344429;}', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`); root@[login to view URL] [/home/eshopdan/public_html]# tail -n4 /var/lib/mysql/[login to view URL] # Query_time: 1.565067 Lock_time: 0.000049 Rows_sent: 0 Rows_examined: 0 Rows_affected: 1 # Bytes_sent: 14 SET timestamp=1536344131; INSERT INTO `wpim_options` (`option_name`, `option_value`, `autoload`) VALUES ('_wpml_transient__wpml_st_mo_scan_in_progress', 'a:2:{s:5:\"value\";i:1;s:10:\"expiration\";i:1536344429;}', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`);