Search results

It's likely being set somewhere else; try looking in /etc/my.cnf

It sounds like your MariaDB setup is limited by memory - What are the values of these two set to? innodb_buffer_pool_size innodb_log_file_size (generally 25% of your innodb_buffer_pool_size) With 8 GB of total available memory, you might want to start with: This would give MariaDB up to...

You can either allocate more memory to the PHP process or disable PCRE entirely by editing the PHP ini via the Plesk control panel (Tools and Setting > PHP Settings > 8.3 FPM handler > php.ini ) and look for the pcre.jit variable, changing it to the following and setting a semicolon: pcre.jit=0

To follow-up on this thread, here is a quick way to take advantage of the built-in Plesk plesk-modsecurity jail which might handle requests a bit faster than scanning individual fail2ban regex/domain logs for bad bots user agent matches. First, build a file in a path such as...

Just based on that entry it was restarted 25 minutes ago so that indicates a crash/restart or possible OOM killer if you didn't kick off any updates. Have you checked your /var/log/mariadb/ log as well as the /var/log/messages log file for activity around that time? If Plesk and the websites...

What is the output of

This might be a bit more efficient, especially than using Fail2Ban which has to scan quite a few log files at scale (and there is a delay in looking at those). That script looks like it needs exact matches so it would be nice if it supported wildcard bot names.

Indeed, it would be nice if Plesk included this in the GUI MariaDB upgrade workflow.

The first place to start might be to check that the value that you're setting is actually in both places: [mysql] AND in the [mysqldump] sections. Then restart the MySQL or MariaDB service and try again.

Better question is, has your website back-end performance improved and has the MariaDB IO dropped a bit? It will still be present but writing to disk directly is slower than memory

Assuming that these are SSD drives, try setting your swapiness to 1 and this time, restart the server.

Now that you've given MariaDB more memory (disk IO, even with SSDs, can be clogged), by changing swapiness the goal is to lower swap access thrashing and prioritize memory. If you want to experiment without restarts of any kind, try: # sudo sysctl vm.swappiness=1 Hopefully throughout the day...

If it's an SSD array (or NVMe), try 1 first and then evaluate after a period. Personally I'd shoot for a reboot but you could use sysctl as an alternative.

Given that you've now given MariaDB more memory and assuming that you have SSDs or faster, try lowering vm.swappiness to a value such as 1 and the evaluate ensure that after you restart, that the value correctly survives the restart: Between the MariaDB changes above and this change, you...

ChatGPT has no actual understanding of the optimizing a database. It can only regurgitate answers based on what it collects around the Internet so if this is important to you, ChatGPT isn't going to be resource that makes sense here. From the official MariaDB website, this post touches on...

That is a tiny, tiny, tiny, tiny innodb_buffer_pool_size and possibly causing you issues, especially with 150 websites-hungry WordPress websites. Try running this command: SELECT CEILING(Total_InnoDB_Bytes*1.6/POWER(1024,3)) RIBPS FROM (SELECT SUM(data_length+index_length) Total_InnoDB_Bytes...

Be very careful as that would effectively remove those files for all domains in that vhosts directory (including any third party CMS plugins that use JPG files).

The Plesk CLI documentation page doesn't make any reference to the usage of semicolons versus spaces so what does that mean in the context of mixing IPs with CIDR ranges? For example, does the full Googlebot IP set (with a description) become: # plesk bin ip_ban --add-trusted...

Since adding these one by one is somewhat cumbersome, it would be great to see a one-click "Add/Update Googlebot known IP addresses" given their importance in the search world but in the meantime, based on the currently published IP list above, would this command work? # plesk bin ip_ban...

Rudimentary question but are you actually accessing it over HTTPS and are are all elements being loaded over HTTPS? It's possible to successfully issue an SSL but if traffic is still being served over HTTP (i.e. not being redirected over HTTP or it's being referenced with HTTP, then it would...