|

MySQL log file quickly filling and growing large

BywpComet

While optimizing our MySQL server we noticed our mysqld.log was huge in size – 1GB+ – and it was filling every moment with the below message:

[Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'

Below article explains the issue
https://support.cpanel.net/hc/en-us/articles/16550190886935-MySQL-log-warning-mysql-native-password-is-deprecated-and-will-be-removed-in-a-future-release

But it seems there is no solution for it yet. We applied the workaround by setting log_error_verbosity to 1 from 2. Which is not ideal, since we will have less info on whats going on, but it was growing pretty rapidly and was pretty unbearable so we had to do it.

The topic was identified 8 months ago and still waiting for a fix

Similar Posts

Elementor loop grid “no results” Unknown column ‘t.term_order’ in ‘order clause’

BywpComet

We added a loop grid and a taxonomy filter for our products but when clicked on  any filter – product tag in our case – there was no results.  Query monitor gave the error : Unknown column ‘t.term_order’ in ‘order clause’ But the default wp _terms table did not have a term_order column anyway. So…

Making WooCommerce coupon codes work with accented – special – characters
|

Making WooCommerce coupon codes work with accented – special – characters

BywpComet

We were promoting our codes with capital letters as a style choice But while the code “burhi” worked the code BURHİ did not because Turkish, “i” and “İ” are considered as different characters, and the lowercase of “İ” is “i”, not “ı”. T. The code should work for other international accented diacritic characters like umlauts

WooCommerce notice not going away or stuck

WooCommerce notice not going away or stuck

BywpComet

Sometimes WooCommerce notices get stuck for different reasons, but we’ve had this particular woocommerce notice persisting in more than one woocommerce sites. To get rid of this “Critical vulnerabilities in WooCommerce” notice you have to set the notice to “actioned”. In order to that, you can either go to phpMyAdmin and do it manually like…

Calculating average amount of memory used by each Apache process
|

Calculating average amount of memory used by each Apache process

BywpComet

You might need to calculate average amount of memory used by each Apache process for several reasons. One being deciding on MaxRequestWorkers . You can do it by running: ps -ylC httpd –sort:rss | awk ‘{x += $8;y += 1} END {print “Apache Memory Usage (MB): “x/1024; print “Average Process Size (MB): “x/((y-1)*1024)}’ Apache Memory…

Leave a Reply

Your email address will not be published. Required fields are marked *