General Mysql and Mariadb Questions

Hello together, sorry for the placement of this thread in this MySQL generalls topic. Was not sure where to post :/ I try to understand how to maintenance a database in the MariaDB World. But to be honest i have never seen before a bad technical documentation like from MariaDB. I located tasks like using ANALYZE TABLES or OPTIMIZE TABLE. Are there any other maintenance task that a DBA should operate? Some keywords explicit to MariaDB would be enough, please no general answers like reindexing or …

How can I search the following string in a text field: ‘%newline,tabluator,b)%’?

Hello all, on some Linux systems I get the following warning during my MySQL database start-up:

[Warning] Buffered warning: Could not increase number of max_open_files to more than 1024 (request: 8192)
[Warning] Buffered warning: Changed limits: max_connections: 214 (requested 505)
[Warning] Buffered warning: Changed limits: table_cache: 400 (requested 512)

What does it mean and is that something I should care about?

Hello all,

I am getting some MySQL warnings in the error log during the start-up:

[Warning] 'user' entry 'root@master' ignored in --skip-name-resolve mode.
[Warning] 'proxies_priv' entry '@ root@laptop4' ignored in --skip-name-resolve mode.

Please suggest how can I prevent such warnings in the MySQL error log?