Hello corus9
The following is error log today by running wo log show lovcour.com --nginx --mysql --php --wp
after Mysql accidently got down.
I submited the report at WordOps/WordOps#516, but there is no reply from @VirtuBox
I actually try to import the database into a fresh Wordpress, but the issue is exactly same.
It would be great if someone could help and guide me how to resolve the issue.
Thanks
2023/07/01 00:11:38 [error] 40915#40915: *14966 access forbidden by rule, client: 138.201.201.81, server: mysite.com, request: "POST /xmlrpc.php HTTP/1.1", host: "mysite.com"
2023/07/01 02:22:13 [error] 40915#40915: *15957 access forbidden by rule, client: 128.199.17.245, server: mysite.com, request: "POST /xmlrpc.php HTTP/1.1", host: "mysite.com"
2023/07/01 02:29:16 [error] 40915#40915: *16150 limiting requests, excess: 200.700 by zone "flood", client: 24.199.120.100, server: mysite.com, request: "GET /wp-includes/js/backbone.min.js?ver=1.4.1 HTTP/2.0", host: "mysite.com"
2023/07/01 02:29:16 [error] 40915#40915: *16150 limiting requests, excess: 200.700 by zone "flood", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/plugins/elementor/assets/lib/backbone/backbone.marionette.min.js?ver=2.4.5.e1 HTTP/2.0", host: "mysite.com"
2023/07/01 02:29:16 [error] 40915#40915: *16150 limiting requests, excess: 200.700 by zone "flood", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/plugins/elementor/assets/lib/backbone/backbone.radio.min.js?ver=1.0.4 HTTP/2.0", host: "mysite.com"
2023/07/01 02:29:16 [error] 40915#40915: *16150 limiting requests, excess: 200.700 by zone "flood", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/plugins/elementor/assets/js/common-modules.min.js?ver=3.14.1 HTTP/2.0", host: "mysite.com"
2023/07/01 02:29:16 [error] 40915#40915: *16150 limiting requests, excess: 200.700 by zone "flood", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/plugins/elementor/assets/js/web-cli.min.js?ver=3.14.1 HTTP/2.0", host: "mysite.com"
2023/07/01 02:29:16 [error] 40915#40915: *16150 limiting requests, excess: 200.700 by zone "flood", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/plugins/elementor/assets/lib/dialog/dialog.min.js?ver=4.9.0 HTTP/2.0", host: "mysite.com"
2023/07/01 02:29:16 [error] 40915#40915: *16150 limiting requests, excess: 200.700 by zone "flood", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/plugins/elementor/assets/js/dev-tools.min.js?ver=3.14.1 HTTP/2.0", host: "mysite.com"
2023/07/01 02:29:16 [error] 40915#40915: *16150 limiting requests, excess: 200.700 by zone "flood", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/plugins/elementor/assets/js/common.min.js?ver=3.14.1 HTTP/2.0", host: "mysite.com"
2023/07/01 02:29:16 [error] 40915#40915: *16150 limiting requests, excess: 200.700 by zone "flood", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/plugins/elementor/assets/js/app-loader.min.js?ver=3.14.1 HTTP/2.0", host: "mysite.com"
2023/07/01 02:29:16 [error] 40915#40915: *16150 limiting requests, excess: 200.700 by zone "flood", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/plugins/woocommerce-free-shipping-bar/assets/js/woocommerce-free-shipping-bar-frontend.js?ver=1.1.17 HTTP/2.0", host: "mysite.com"
2023/07/01 02:29:16 [error] 40915#40915: *16150 limiting requests, excess: 200.700 by zone "flood", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/plugins/woo-variation-swatches-pro/assets/js/add-to-cart-variation.min.js?ver=1687867647 HTTP/2.0", host: "mysite.com"
2023/07/01 02:29:16 [error] 40915#40915: *16150 limiting requests, excess: 200.700 by zone "flood", client: 24.199.120.100, server: mysite.com, request: "GET /wp-includes/js/wp-embed.min.js?ver=6.2.2 HTTP/2.0", host: "mysite.com"
2023/07/01 02:29:16 [error] 40915#40915: *16150 limiting requests, excess: 200.700 by zone "flood", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/plugins/simple-cloudflare-turnstile/js/disable-submit.js?ver=4.0 HTTP/2.0", host: "mysite.com"
2023/07/01 02:29:16 [error] 40915#40915: *16150 limiting requests, excess: 200.700 by zone "flood", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/plugins/simple-cloudflare-turnstile/js/integrations/woocommerce.js?ver=1.1 HTTP/2.0", host: "mysite.com"
2023/07/01 02:29:16 [error] 40915#40915: *16150 limiting requests, excess: 200.700 by zone "flood", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/themes/savoy/assets/js/plugins/lazysizes.min.js?ver=4.0.1 HTTP/2.0", host: "mysite.com"
2023/07/01 02:29:16 [error] 40915#40915: *16150 limiting requests, excess: 200.700 by zone "flood", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/themes/savoy/assets/js/nm-shop-quickview.min.js?ver=2.8.2 HTTP/2.0", host: "mysite.com"
2023/07/01 02:29:16 [error] 40915#40915: *16150 limiting requests, excess: 200.700 by zone "flood", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/themes/savoy/assets/js/plugins/jquery.pin.min.js?ver=1.0.3 HTTP/2.0", host: "mysite.com"
2023/07/01 02:29:16 [error] 40915#40915: *16150 limiting requests, excess: 200.700 by zone "flood", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/plugins/nm-wishlist/assets/js/nm-wishlist.min.js?ver=2.4.2 HTTP/2.0", host: "mysite.com"
2023/07/01 02:29:16 [error] 40915#40915: *16150 limiting requests, excess: 200.700 by zone "flood", client: 24.199.120.100, server: mysite.com, request: "GET /wp-includes/js/wp-emoji-release.min.js?ver=6.2.2 HTTP/2.0", host: "mysite.com"
2023/07/01 02:29:16 [error] 40915#40915: *16150 limiting requests, excess: 200.700 by zone "flood", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/themes/savoy/assets/img/transparent.gif HTTP/2.0", host: "mysite.com"
2023/07/01 02:29:16 [error] 40915#40915: *16150 limiting requests, excess: 200.700 by zone "flood", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/plugins/gtranslate/js/dwf.js?ver=6.2.2 HTTP/2.0", host: "mysite.com"
2023/07/01 02:29:16 [error] 40915#40915: *16150 limiting requests, excess: 200.700 by zone "flood", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/uploads/letter-avatar/15843c3ac26d33a8c607a06bd63b696a.svg HTTP/2.0", host: "mysite.com"
2023/07/01 02:29:16 [error] 40915#40915: *16150 limiting requests, excess: 200.700 by zone "flood", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/uploads/letter-avatar/987ef03146b849618717a48cca5c2d25.svg HTTP/2.0", host: "mysite.com"
2023/07/01 02:32:29 [error] 40916#40916: *16439 FastCGI sent in stderr: "PHP message: PHP Warning: Trying to access array offset on value of type bool in /var/www/mysite.com/htdocs/wp-content/themes/savoy/includes/woocommerce/search-suggestions.php on line 176; PHP message: PHP Warning: Trying to access array offset on value of type bool in /var/www/mysite.com/htdocs/wp-content/themes/savoy/includes/woocommerce/search-suggestions.php on line 176; PHP message: PHP Warning: Trying to access array offset on value of type bool in /var/www/mysite.com/htdocs/wp-content/themes/savoy/includes/woocommerce/search-suggestions.php on line 176" while reading response header from upstream, client: 108.225.62.170, server: mysite.com, request: "POST /?wc-ajax=nm_suggestions_product_data HTTP/2.0", upstream: "fastcgi://unix:/var/run/php/php82-two-fpm.sock:", host: "mysite.com", referrer: "https://mysite.com/shop/happy-school-bag/17-inch-canvas-college-schoolbag-laptop-backpack/?attribute_pa_color=white&attribute_pa_size=17-inch&attribute_pa_material=canvas&utm_source=google&utm_medium=cpc&utm_campaign=feedshopping&utm_term=bags&utm_content=bags&wmc-currency=USD&srsltid=ASuE1wRvYlMnLmG334hLE0KsyzWTuhUzsccEra3w9u9ZCkUCVnjJ1yPIAa4"
2023/07/01 02:33:01 [error] 40915#40915: *16448 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /laptop-backpack/26l-32l-16-9-women-multifunction-duffel-gym-laptop-backpacks/embed/ HTTP/2.0", host: "mysite.com"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/plugins/woocommerce-multi-currency/css/images/flags-64.png HTTP/2.0", host: "mysite.com", referrer: "https://mysite.com/wp-content/cache/autoptimize/1/css/autoptimize_ba03b5d86d2c232d6fbda9b6ecb3c534.css"
2023/07/01 02:33:01 [error] 40915#40915: *16448 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /laptop-backpack/23l-16-5-inch-women-backpacks-for-15-6-laptop-multifunction-duffel-gym/embed/ HTTP/2.0", host: "mysite.com"
2023/07/01 02:33:01 [error] 40915#40915: *16448 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /laptop-backpack/33-liters-17-7-waterproof-nylon-women-expandable-travel-backpacks-for-15-6-laptop/embed/ HTTP/2.0", host: "mysite.com"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/plugins/woocommerce-multi-currency/css/images/flags-64.png HTTP/2.0", host: "mysite.com", referrer: "https://mysite.com/wp-content/cache/autoptimize/1/css/autoptimize_ba03b5d86d2c232d6fbda9b6ecb3c534.css"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-includes/js/dist/i18n.min.js?ver=9e794f35a71bb98672ae HTTP/2.0", host: "mysite.com"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-includes/js/dist/url.min.js?ver=16185fce2fb043a0cfed HTTP/2.0", host: "mysite.com"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-includes/js/dist/api-fetch.min.js?ver=bc0029ca2c943aec5311 HTTP/2.0", host: "mysite.com"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-includes/js/dist/i18n.min.js?ver=9e794f35a71bb98672ae HTTP/2.0", host: "mysite.com"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-includes/js/dist/url.min.js?ver=16185fce2fb043a0cfed HTTP/2.0", host: "mysite.com"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-includes/js/dist/api-fetch.min.js?ver=bc0029ca2c943aec5311 HTTP/2.0", host: "mysite.com"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-includes/js/dist/i18n.min.js?ver=9e794f35a71bb98672ae HTTP/2.0", host: "mysite.com"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-includes/js/dist/url.min.js?ver=16185fce2fb043a0cfed HTTP/2.0", host: "mysite.com"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-includes/js/dist/api-fetch.min.js?ver=bc0029ca2c943aec5311 HTTP/2.0", host: "mysite.com"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-includes/js/dist/i18n.min.js?ver=9e794f35a71bb98672ae HTTP/2.0", host: "mysite.com"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-includes/js/dist/url.min.js?ver=16185fce2fb043a0cfed HTTP/2.0", host: "mysite.com"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-includes/js/dist/api-fetch.min.js?ver=bc0029ca2c943aec5311 HTTP/2.0", host: "mysite.com"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-includes/js/dist/i18n.min.js?ver=9e794f35a71bb98672ae HTTP/2.0", host: "mysite.com"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-includes/js/dist/url.min.js?ver=16185fce2fb043a0cfed HTTP/2.0", host: "mysite.com"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-includes/js/dist/api-fetch.min.js?ver=bc0029ca2c943aec5311 HTTP/2.0", host: "mysite.com"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/plugins/woocommerce-multi-currency/css/images/flags-64.png HTTP/2.0", host: "mysite.com", referrer: "https://mysite.com/wp-content/cache/autoptimize/1/css/autoptimize_ba03b5d86d2c232d6fbda9b6ecb3c534.css"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/plugins/woocommerce-multi-currency/css/images/flags-64.png HTTP/2.0", host: "mysite.com", referrer: "https://mysite.com/wp-content/cache/autoptimize/1/css/autoptimize_ba03b5d86d2c232d6fbda9b6ecb3c534.css"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/plugins/woocommerce-multi-currency/css/images/flags-64.png HTTP/2.0", host: "mysite.com", referrer: "https://mysite.com/wp-content/cache/autoptimize/1/css/autoptimize_ba03b5d86d2c232d6fbda9b6ecb3c534.css"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/plugins/woocommerce-multi-currency/css/images/flags-64.png HTTP/2.0", host: "mysite.com", referrer: "https://mysite.com/wp-content/cache/autoptimize/1/css/autoptimize_ba03b5d86d2c232d6fbda9b6ecb3c534.css"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/plugins/woocommerce-multi-currency/css/images/flags-64.png HTTP/2.0", host: "mysite.com", referrer: "https://mysite.com/wp-content/cache/autoptimize/1/css/autoptimize_ba03b5d86d2c232d6fbda9b6ecb3c534.css"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/themes/savoy/assets/img/transparent.gif HTTP/2.0", host: "mysite.com"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/cache/autoptimize/1/css/autoptimize_ba03b5d86d2c232d6fbda9b6ecb3c534.css HTTP/2.0", host: "mysite.com"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-includes/js/jquery/jquery.min.js?ver=3.6.4 HTTP/2.0", host: "mysite.com"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/cache/autoptimize/1/css/autoptimize_ba03b5d86d2c232d6fbda9b6ecb3c534.css HTTP/2.0", host: "mysite.com"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-includes/js/jquery/jquery.min.js?ver=3.6.4 HTTP/2.0", host: "mysite.com"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/themes/savoy/assets/img/select-arrow@2x.gif HTTP/2.0", host: "mysite.com", referrer: "https://mysite.com/wp-content/cache/autoptimize/1/css/autoptimize_ba03b5d86d2c232d6fbda9b6ecb3c534.css"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/themes/savoy/assets/img/transparent.gif HTTP/2.0", host: "mysite.com"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/themes/savoy/assets/img/transparent.gif HTTP/2.0", host: "mysite.com"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/themes/savoy/assets/img/transparent.gif HTTP/2.0", host: "mysite.com"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/themes/savoy/assets/img/transparent.gif HTTP/2.0", host: "mysite.com"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/themes/savoy/assets/img/transparent.gif HTTP/2.0", host: "mysite.com"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/themes/savoy/assets/img/transparent.gif HTTP/2.0", host: "mysite.com"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/plugins/autoptimize/classes/external/js/lazysizes.min.js?ao_version=3.1.8.1 HTTP/2.0", host: "mysite.com"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/themes/savoy/assets/img/transparent.gif HTTP/2.0", host: "mysite.com"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/plugins/autoptimize/classes/external/js/lazysizes.min.js?ao_version=3.1.8.1 HTTP/2.0", host: "mysite.com"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/plugins/autoptimize/classes/external/js/lazysizes.min.js?ao_version=3.1.8.1 HTTP/2.0", host: "mysite.com"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/plugins/autoptimize/classes/external/js/lazysizes.min.js?ao_version=3.1.8.1 HTTP/2.0", host: "mysite.com"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/plugins/autoptimize/classes/external/js/lazysizes.min.js?ao_version=3.1.8.1 HTTP/2.0", host: "mysite.com"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/plugins/autoptimize/classes/external/js/lazysizes.min.js?ao_version=3.1.8.1 HTTP/2.0", host: "mysite.com"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/plugins/autoptimize/classes/external/js/lazysizes.min.js?ao_version=3.1.8.1 HTTP/2.0", host: "mysite.com"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/themes/savoy/assets/img/transparent.gif HTTP/2.0", host: "mysite.com"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/cache/autoptimize/1/css/autoptimize_ba03b5d86d2c232d6fbda9b6ecb3c534.css HTTP/2.0", host: "mysite.com"
2023/07/01 02:33:01 [error] 40915#40915: *16448 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /laptop-backpack/26l-32l-16-9-women-multifunction-duffel-gym-laptop-backpacks/embed/ HTTP/2.0", host: "mysite.com"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/themes/savoy/assets/img/transparent.gif HTTP/2.0", host: "mysite.com"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/themes/savoy/assets/img/transparent.gif HTTP/2.0", host: "mysite.com"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/plugins/autoptimize/classes/external/js/lazysizes.min.js?ao_version=3.1.8.1 HTTP/2.0", host: "mysite.com"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/cache/autoptimize/1/css/autoptimize_ba03b5d86d2c232d6fbda9b6ecb3c534.css HTTP/2.0", host: "mysite.com"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/plugins/autoptimize/classes/external/js/lazysizes.min.js?ao_version=3.1.8.1 HTTP/2.0", host: "mysite.com"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/themes/savoy/assets/img/transparent.gif HTTP/2.0", host: "mysite.com"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/plugins/autoptimize/classes/external/js/lazysizes.min.js?ao_version=3.1.8.1 HTTP/2.0", host: "mysite.com"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/themes/savoy/assets/img/transparent.gif HTTP/2.0", host: "mysite.com"
2023/07/01 02:32:52 [error] 40914#40914: *16565 limiting connections by zone "addr", client: 24.199.120.100, server: mysite.com, request: "GET /wp-content/plugins/autoptimize/classes/external/js/lazysizes.min.js?ao_version=3.1.8.1 HTTP/2.0", host: "mysite.com"
2023/07/01 02:36:06 [error] 40915#40915: *16448 FastCGI sent in stderr: "PHP message: PHP Warning: Attempt to read property "post_status" on null in /var/www/mysite.com/htdocs/wp-content/plugins/elementor/core/base/document.php on line 1742; PHP message: PHP Warning: Attempt to read property "post_status" on null in /var/www/mysite.com/htdocs/wp-content/plugins/elementor/core/base/document.php on line 1751" while reading response header from upstream, client: 24.199.120.100, server: mysite.com, request: "GET /laptop-backpack/32l-19-6-women-laptop-travel-backpack-with-shoes-compartment/embed/ HTTP/2.0", upstream: "fastcgi://unix:/var/run/php/php82-two-fpm.sock:", host: "mysite.com"
2023/07/01 02:37:42 [error] 40915#40915: *16448 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 24.199.120.100, server: mysite.com, request: "GET /laptop-backpack/32l-19-6-women-laptop-travel-backpack-with-shoes-compartment/embed/ HTTP/2.0", upstream: "fastcgi://unix:/var/run/php/php82-two-fpm.sock", host: "mysite.com"
2023/07/01 02:37:42 [error] 40915#40915: *16448 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 24.199.120.100, server: mysite.com, request: "GET /laptop-backpack/23l-16-5-inch-women-backpacks-for-15-6-laptop-multifunction-duffel-gym/embed/ HTTP/2.0", upstream: "fastcgi://unix:/var/run/php/php82-fpm.sock", host: "mysite.com"
2023/07/01 02:37:42 [error] 40915#40915: *16448 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 24.199.120.100, server: mysite.com, request: "GET /laptop-backpack/32l-19-6-women-laptop-travel-backpack-with-shoes-compartment/embed/ HTTP/2.0", upstream: "fastcgi://unix:/var/run/php/php82-fpm.sock", host: "mysite.com"
2023/07/01 02:37:42 [error] 40915#40915: *16448 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 24.199.120.100, server: mysite.com, request: "GET /laptop-backpack/32l-19-6-women-laptop-travel-backpack-with-shoes-compartment/embed/ HTTP/2.0", upstream: "fastcgi://unix:/var/run/php/php82-two-fpm.sock", host: "mysite.com"
2023/07/01 02:37:42 [error] 40915#40915: *16448 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 24.199.120.100, server: mysite.com, request: "GET /laptop-backpack/23l-16-5-inch-women-backpacks-for-15-6-laptop-multifunction-duffel-gym/embed/ HTTP/2.0", upstream: "fastcgi://unix:/var/run/php/php82-fpm.sock", host: "mysite.com"
2023/07/01 02:37:42 [error] 40915#40915: *16448 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 24.199.120.100, server: mysite.com, request: "GET /laptop-backpack/32l-19-6-women-laptop-travel-backpack-with-shoes-compartment/embed/ HTTP/2.0", upstream: "fastcgi://unix:/var/run/php/php82-two-fpm.sock", host: "mysite.com"
2023/07/01 02:37:42 [error] 40915#40915: *16448 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 24.199.120.100, server: mysite.com, request: "GET /laptop-backpack/23l-16-5-inch-women-backpacks-for-15-6-laptop-multifunction-duffel-gym/embed/ HTTP/2.0", upstream: "fastcgi://unix:/var/run/php/php82-fpm.sock", host: "mysite.com"
2023/07/01 02:37:43 [error] 40915#40915: *16448 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 24.199.120.100, server: mysite.com, request: "GET /laptop-backpack/26l-32l-16-9-women-multifunction-duffel-gym-laptop-backpacks/embed/ HTTP/2.0", upstream: "fastcgi://unix:/var/run/php/php82-two-fpm.sock", host: "mysite.com"
2023/07/01 02:37:43 [error] 40915#40915: *16448 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 24.199.120.100, server: mysite.com, request: "GET /laptop-backpack/23l-16-5-inch-women-backpacks-for-15-6-laptop-multifunction-duffel-gym/embed/ HTTP/2.0", upstream: "fastcgi://unix:/var/run/php/php82-fpm.sock", host: "mysite.com"
2023/07/01 02:37:43 [error] 40915#40915: *16448 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 24.199.120.100, server: mysite.com, request: "GET /laptop-backpack/32l-19-6-women-laptop-travel-backpack-with-shoes-compartment/embed/ HTTP/2.0", upstream: "fastcgi://unix:/var/run/php/php82-two-fpm.sock", host: "mysite.com"
2023/07/01 02:37:43 [error] 40915#40915: *16448 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 24.199.120.100, server: mysite.com, request: "GET /laptop-backpack/23l-16-5-inch-women-backpacks-for-15-6-laptop-multifunction-duffel-gym/embed/ HTTP/2.0", upstream: "fastcgi://unix:/var/run/php/php82-fpm.sock", host: "mysite.com"
2023/07/01 02:37:43 [error] 40915#40915: *16448 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 24.199.120.100, server: mysite.com, request: "GET /laptop-backpack/26l-32l-16-9-women-multifunction-duffel-gym-laptop-backpacks/embed/ HTTP/2.0", upstream: "fastcgi://unix:/var/run/php/php82-fpm.sock", host: "mysite.com"
2023/07/01 02:37:44 [error] 40915#40915: *16448 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 24.199.120.100, server: mysite.com, request: "GET /laptop-backpack/33-liters-17-7-waterproof-nylon-women-expandable-travel-backpacks-for-15-6-laptop/embed/ HTTP/2.0", upstream: "fastcgi://unix:/var/run/php/php82-fpm.sock", host: "mysite.com"
2023/07/01 02:37:45 [error] 40915#40915: *16448 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 24.199.120.100, server: mysite.com, request: "GET /laptop-backpack/23l-16-5-inch-women-backpacks-for-15-6-laptop-multifunction-duffel-gym/embed/ HTTP/2.0", upstream: "fastcgi://unix:/var/run/php/php82-fpm.sock", host: "mysite.com"
2023/07/01 02:38:02 [error] 40915#40915: *16646 no live upstreams while connecting to upstream, client: 24.199.120.100, server: mysite.com, request: "GET / HTTP/2.0", upstream: "fastcgi://php82", host: "mysite.com", referrer: "https://mysite.com/wp-admin/post.php?post=1691956&action=edit"
2023/07/01 02:38:03 [error] 40915#40915: *16649 no live upstreams while connecting to upstream, client: 144.126.223.134, server: mysite.com, request: "POST /wp-cron.php?doing_wp_cron=1688179083.2022299766540527343750 HTTP/1.1", upstream: "fastcgi://php82", host: "mysite.com"
2023/07/01 02:41:49 [error] 11546#11546: *190 FastCGI sent in stderr: "PHP message: PHP Warning: Trying to access array offset on value of type bool in /var/www/mysite.com/htdocs/wp-content/themes/savoy/includes/woocommerce/search-suggestions.php on line 176; PHP message: PHP Warning: Trying to access array offset on value of type bool in /var/www/mysite.com/htdocs/wp-content/themes/savoy/includes/woocommerce/search-suggestions.php on line 176; PHP message: PHP Warning: Trying to access array offset on value of type bool in /var/www/mysite.com/htdocs/wp-content/themes/savoy/includes/woocommerce/search-suggestions.php on line 176" while reading response header from upstream, client: 201.241.155.16, server: mysite.com, request: "POST /?wc-ajax=nm_suggestions_product_data HTTP/2.0", upstream: "fastcgi://unix:/var/run/php/php82-two-fpm.sock:", host: "mysite.com", referrer: "https://mysite.com/shop/wallets/leather-foldable-wallet-bank-credit-card-purse/?attribute_pa_color=coffee&utm_source=google&utm_medium=cpc&utm_campaign=feedshopping&utm_term=bags&utm_content=bags&wmc-currency=USD&srsltid=ASuE1wSxZKRDciLwT2UOOznLQ8jaER_zEY-OFIoYzR-T4uV3vr_xc30d9Yk"
2023/07/01 02:41:59 [error] 11548#11548: *198 FastCGI sent in stderr: "PHP message: PHP Warning: Trying to access array offset on value of type bool in /var/www/mysite.com/htdocs/wp-content/themes/savoy/includes/woocommerce/search-suggestions.php on line 176; PHP message: PHP Warning: Trying to access array offset on value of type bool in /var/www/mysite.com/htdocs/wp-content/themes/savoy/includes/woocommerce/search-suggestions.php on line 176; PHP message: PHP Warning: Trying to access array offset on value of type bool in /var/www/mysite.com/htdocs/wp-content/themes/savoy/includes/woocommerce/search-suggestions.php on line 176" while reading response header from upstream, client: 69.204.110.160, server: mysite.com, request: "POST /?wc-ajax=nm_suggestions_product_data HTTP/2.0", upstream: "fastcgi://unix:/var/run/php/php82-fpm.sock:", host: "mysite.com", referrer: "https://mysite.com/product-category/unisex-retro-style-bags/"
If run wo log show lovcour.com --mysql
, it will show as following
watching logfile /var/log/mysql/mariadb-slow.log
/usr/sbin/mariadbd, Version: 10.6.14-MariaDB-1:10.6.14+maria~ubu2204-log (mariadb.org binary distribution). started with:
Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
Time Id Command Argument
/usr/sbin/mariadbd, Version: 10.6.14-MariaDB-1:10.6.14+maria~ubu2204-log (mariadb.org binary distribution). started with:
Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
Time Id Command Argument
When run mysqltuner --user dbuser --pass dbPW
, it show:
>> MySQLTuner 2.1.7
* Jean-Marie Renouard <jmrenouard@gmail.com>
* Major Hayden <major@mhtx.net>
>> Bug reports, feature requests, and downloads at http://mysqltuner.pl/
>> Run with '--help' for additional options and output filtering
[--] Skipped version check for MySQLTuner script
[OK] Logged in using credentials passed on the command line
[!!] Failed to execute: SHOW REPLICA STATUS\G
[!!] FAIL Execute SQL / return code: 256
[!!] Failed to execute: SHOW SLAVE STATUS
[!!] FAIL Execute SQL / return code: 256
[OK] Currently running supported MySQL version 10.6.14-MariaDB-1:10.6.14+maria~ubu2204-log
[OK] Operating on 64-bit architecture
-------- Log file Recommendations ------------------------------------------------------------------
[!!] Log file doesn't exist
-------- Storage Engine Statistics -----------------------------------------------------------------
[--] Status: +Aria +CSV +InnoDB +MEMORY +MRG_MyISAM +MyISAM +PERFORMANCE_SCHEMA +SEQUENCE
[--] Data in InnoDB tables: 1.5G (Tables: 253)
[OK] Total fragmented tables: 0
-------- Analysis Performance Metrics --------------------------------------------------------------
[--] innodb_stats_on_metadata: OFF
[OK] No stat updates during querying INFORMATION_SCHEMA.
-------- Views Metrics -----------------------------------------------------------------------------
-------- Triggers Metrics --------------------------------------------------------------------------
-------- Routines Metrics --------------------------------------------------------------------------
-------- Security Recommendations ------------------------------------------------------------------
[OK] No Role user detected
[!!] Failed to execute: SELECT CONCAT(QUOTE(user), '@', QUOTE(host)) FROM mysql.user WHERE (TRIM(USER) = '' OR USER IS NULL)
[!!] FAIL Execute SQL / return code: 256
[OK] There are no anonymous accounts for any database users
[!!] Failed to execute: SELECT CONCAT(QUOTE(user), '@', QUOTE(host)) FROM mysql.global_priv WHERE
( user != ''
AND JSON_CONTAINS(Priv, '"mysql_native_password"', '$.plugin') AND JSON_CONTAINS(Priv, '""', '$.authentication_string')
AND NOT JSON_CONTAINS(Priv, 'true', '$.account_locked')
)
[!!] FAIL Execute SQL / return code: 256
[OK] All database users have passwords assigned
[!!] Failed to execute: SELECT CONCAT(QUOTE(user), '@', QUOTE(host)) FROM mysql.user WHERE user != '' AND (CAST(password as Binary) = PASSWORD(user) OR CAST(password as Binary) = PASSWORD(UPPER(user)) OR CAST(password as Binary) = PASSWORD(CONCAT(UPPER(LEFT(User, 1)), SUBSTRING(User, 2, LENGTH(User)))))
[!!] FAIL Execute SQL / return code: 256
[!!] Failed to execute: SELECT CONCAT(QUOTE(user), '@', host) FROM mysql.user WHERE HOST='%'
[!!] FAIL Execute SQL / return code: 256
[!!] There is no basic password file list!
-------- CVE Security Recommendations --------------------------------------------------------------
[--] Skipped due to --cvefile option undefined
-------- Performance Metrics -----------------------------------------------------------------------
[--] Up for: 51m 43s (623K q [200.890 qps], 605 conn, TX: 8G, RX: 136M)
[--] Reads / Writes: 97% / 3%
[--] Binary logging is disabled
[--] Physical Memory : 7.8G
[--] Max MySQL memory : 4.0G
[--] Other process memory: 0B
[--] Total buffers: 3.2G global + 7.6M per thread (100 max threads)
[--] Performance_schema Max memory usage: 0B
[--] Galera GCache Max memory usage: 0B
[OK] Maximum reached memory usage: 3.3G (42.61% of installed RAM)
[OK] Maximum possible memory usage: 4.0G (51.09% of installed RAM)
[OK] Overall possible memory usage with other process is compatible with memory available
[OK] Slow queries: 0% (0/623K)
[OK] Highest usage of available connections: 11% (11/100)
[OK] Aborted connections: 0.00% (0/605)
[!!] Name resolution is active: a reverse name resolution is made for each new connection which can reduce performance
[OK] Query cache is disabled by default due to mutex contention on multiprocessor machines.
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 95K sorts)
[!!] Joins performed without indexes: 393
[OK] Temporary tables created on disk: 5% (5K on disk / 89K total)
[OK] Thread cache hit rate: 98% (11 created / 605 connections)
[OK] Table cache hit rate: 99% (803K hits / 804K requests)
[OK] table_definition_cache (400) is greater than number of tables (332)
[OK] Open file limit used: 0% (56/500K)
[OK] Table locks acquired immediately: 100% (232 immediate / 232 locks)
-------- Performance schema ------------------------------------------------------------------------
[!!] Performance_schema should be activated.
[--] Sys schema is not installed.
-------- ThreadPool Metrics ------------------------------------------------------------------------
[--] ThreadPool stat is disabled.
-------- MyISAM Metrics ----------------------------------------------------------------------------
[--] No MyISAM table(s) detected ....
-------- InnoDB Metrics ----------------------------------------------------------------------------
[--] InnoDB is enabled.
[OK] InnoDB File per table is activated
[OK] InnoDB buffer pool / data size: 2.4G / 1.5G
[!!] Ratio InnoDB log file size / InnoDB Buffer pool size (12.2121710526316%): 297.0M * 1 / 2.4G should be equal to 25%
[--] Number of InnoDB Buffer Pool Chunk: 19 for 1 Buffer Pool Instance(s)
[OK] Innodb_buffer_pool_size aligned with Innodb_buffer_pool_chunk_size & Innodb_buffer_pool_instances
[OK] InnoDB Read buffer efficiency: 99.94% (81464552 hits / 81515854 total)
[!!] InnoDB Write Log efficiency: 230.11% (8123 hits / 3530 total)
[OK] InnoDB log waits: 0.00% (0 waits / 11653 writes)
-------- Aria Metrics ------------------------------------------------------------------------------
[--] Aria Storage Engine is enabled.
[OK] Aria pagecache size / total Aria indexes: 128.0M/0B
[OK] Aria pagecache hit rate: 99.1% (567K cached / 4K reads)
-------- TokuDB Metrics ----------------------------------------------------------------------------
[--] TokuDB is disabled.
-------- XtraDB Metrics ----------------------------------------------------------------------------
[--] XtraDB is disabled.
-------- Galera Metrics ----------------------------------------------------------------------------
[--] Galera is disabled.
-------- Replication Metrics -----------------------------------------------------------------------
[--] Galera Synchronous replication: NO
[--] No replication slave(s) for this server.
[--] Binlog format: ROW
[--] XA support enabled: ON
[--] Semi synchronous replication Master: OFF
[--] Semi synchronous replication Slave: OFF
[--] This is a standalone server
-------- Recommendations ---------------------------------------------------------------------------
General recommendations:
MySQL was started within the last 24 hours: recommendations may be inaccurate
Configure your accounts with ip or subnets only, then update your configuration with skip-name-resolve=OFF
We will suggest raising the 'join_buffer_size' until JOINs not using indexes are found.
See https://dev.mysql.com/doc/internals/en/join-buffer-size.html
(specially the conclusions at the bottom of the page).
Performance schema should be activated for better diagnostics
Consider installing Sys schema from https://github.com/FromDual/mariadb-sys for MariaDB
Before changing innodb_log_file_size and/or innodb_log_files_in_group read this: https://bit.ly/2TcGgtU
Variables to adjust:
skip-name-resolve=OFF
join_buffer_size (> 256.0K, or always use indexes with JOINs)
performance_schema=ON
innodb_log_file_size should be (=608M) if possible, so InnoDB total log file size equals 25% of buffer pool size.