File:

/etc/mysql/mariadb.conf.d/90-mycustom.cnf

Add:

[mariadb]
log_output=FILE
slow_query_log
slow_query_log_file=/var/log/mysql/mariadb-slow.log
long_query_time=0.1

Restart MariaDB:

 # systemctl restart mariadb

Problem:

* * * * * echo -n $(date +"%Y-%m-%d %H:%M:%S " ) " - " && awk '{print $1, $2, $3}' /proc/loadavg >> server-load.log

Alternative:

echo -n $(date) && uptime >> server-load.log

If this both commands show different files, the reason is the content of directories, listed by ls:

# find . -mtime -1
# find . -mtime -1 -exec ls -lah {} \;

Solution is -d :

Problem:

Request Timeout
Server timeout waiting for the HTTP request from the client.
Apache Server at default Port 443.

Solution?

Code:

Problem (in Logs):

Problem:

# drush sql:cli < db.sql 
 [warning] It is slow to pass large amounts of data via stdin to the sql:cli command. 
 See the Examples at https://www.drush.org/latest/commands/sql_cli/ 
 for an alternative using sql:connect.

Solution?

Problem:

shell: # ./myexample.php

-bash: myexample.php cannot execute: required file not found

myexample.php:

Commandline:

HISTSIZE=9999;HISTFILESIZE=9999

/root/.bashrc

/path/to/user/.bashrc

HISTSIZE=9999
HISTFILESIZE=9999

Change it globally:

/etc/bash.bashrc.

Problem: