Search results

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...

Indeed, there are cases that could be made to offer a paid low domain license so if the powers that be at Plesk could see the value in this, it would be a nice way to transition from web admin to something more!

We were able to track this down and as much as we wanted it to be a Plesk or CentOS/AlmaLinux problem, it turns out that it was a security endpoint policy with an HTTPS stream inspection that would cause this behavior. Adding an exception fixed it for FTPS transfers!

So it's not a port issue as we've disabled iptables and border firewall traffic restrictions. Hopefully this thread gets the attention of a Plesk staff member!

This was not the fix as it failed again soon after. Not sure what's going on!

This seems to have resolved it however it's unclear what changed or why: https://support.plesk.com/hc/en-us/articles/12377595891991-FTP-connection-is-randomly-dropped-during-file-transfer-on-Plesk-for-Linux-server-with-SELinux

I'm going to bump this thread and add that this has started to happen with large file uploads but exact date when it started isn't clear. It's present on AlmaLinux 8/9 and CentOS 7.

Once you're happy with the matched results, then use the following (replacing the last value with the name of your jail) to commit the changes without having to restart the Fail2Ban service:

And now for the part II - The CPU consuming bots of the world unite! Use at your own risk and note that some bots below are "legitimate" but blocked due to irrelevant traffic: