Watch MySQL full-processlist every 0.5 seconds :
while : ; do mysql -u MY_USERNAME --password='MY_PASSWORD' -e "show full processlist"; sleep 0.5; done
MysqlAdmin
Versuch 1 - Optimieren:
Table 'logs' is marked as crashed and last (automatic?) repair failedVersuch 2 - Reparieren:
Hier ist der Befehl für Mysqladmin um alle details von aktiven prozesse zu sehen:
/usr/bin/mysqladmin processlist -u root --password=mypassword -v
Neueste Kommentare
List config vaiables
/usr/sbin/mariadbd --help --verbose | grep "query.*size"Restart MariaDB / MySQL
Commandline:
MariaDB Restart (after changes in /etc/mysql/db-performance.cnf)
After my changes in /etc/mysql/db-performance.cnf
Error: configure: error: no acceptable C compiler found in $PATH
Error:
PHP 8.3, APCu via PECL
PHP 8.3 extra packages (+ pecl, apcu)
apt update apt install plesk-php83-dev zlib1g-devhttps : Secure Connection Failed
I get this error, when I visit https://solr.example.com:8983 :
Remove files and show the number of deleted files
Remove all files starting with 2024 in mydir123 and show the number of deleted files:
find mydir123 -name '2024*' -exec rm -vf {} \; | wc -lfind . -name '*' | xargs rm …
find . -name '*' | xargs rm -vMaybe Patch
https://www.drupal.org/project/tablefield/issues/3397688
/etc/my.cnf
Edit "/etc/my.cnf" ( under [mysqld] ):
transaction_isolation="READ-COMMITTED"Restart MariaDB / MySQL: