Help with mysqltuner for optimizing mariadb on wordops

Endda

I've continued to have issues with my db crashing and could use some help modifying the files.
After a week of the VPS running, here are the recommendations given by mysqltuner. . .

General recommendations:
    Reduce your overall MySQL memory footprint for system stability
    Configure your accounts with ip or subnets only, then update your configurat                                                                                                                                                                             ion with skip-name-resolve=ON
    Performance schema should be activated for better diagnostics
    Be careful, increasing innodb_log_file_size / innodb_log_files_in_group mean                                                                                                                                                                             s higher crash recovery mean time
Variables to adjust:
    skip-name-resolve=ON
    table_definition_cache (400) > 573 or -1 (autosizing if supported)
    performance_schema=ON
    innodb_log_file_size should be (=143M) if possible, so InnoDB total log file                                                                                                                                                                              size equals 25% of buffer pool size.
    innodb_log_buffer_size (> 143M)

I could use some help finding which file needs to be edited, and what needs to be changed within that file.
I'm just not familiar with mysqltuner (or mariadb within wordops) and would greatly appreciate some guidance

Endda

still getting mariadb crashes 🙁

portofacil

It seems your server is undersized to meet your demand. How much RAM do you have?

I suggest at least 4 GB RAM for a full LEMP stack (with or without WO). If your sites do not benefit from cache or have high traffic, perhaps you need even more RAM.

Endda

I used WordOps for many years with this same hardware. The only difference with this latest issue is that I've updated to the latest version of Debian.

It has 2GB of RAM and 2GB of SWAP RAM. That should be enough (it was enough before).

So my question is. . .where can I locate the files within WordOps that I need to edit to make changes that mysqltuner is recommending

portofacil

Understanding the basic system structure and locating standard directories, such as /etc/mysql for MySQL configurations, is essential for any system administrator. I recommend exploring that folder and reading the official documentation for WordOps and MySQL to understand how the configurations are connected. This will not only help you apply the mysqltuner recommendations but also help you develop the fundamental skills to handle similar situations in the future.

Endda

portofacil is there documentation that shows what the default mysql configs are set to? when I pico my.cnf from that folder, it's blank.

I can overwrite the global variables from there. . .but I'm still not sure what the current global variables are set to

portofacil

Endda There are other configuration files, including subdirectories in /etc/mysql. I suggest inspecting everything before making changes.

Endda

my issue seems to have stemmed from the default mysql config file wanting to use 100 connections
dropping this down to around 25-30 has fixed the mariadb crashing issue I was having