MysqlAdmin

MySQL Full Processlist - Watch live every 0.5 seconds (from Command-Line)

Submitted by Gast (nicht überprüft) on Di, 02/02/2021 - 19:21

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 

 

Save full-processlist to log


while : ; do mysql -u MY_USERNAME --password='MY_PASSWORD' -e "show full processlist"; sleep 0.5; done >> mysql-proc.log

 

Table 'logs' is marked as crashed and last (automatic?) repair failed

Submitted by Gast (nicht überprüft) on Mo, 02/04/2019 - 11:05

Versuch 1 - Optimieren:

Table 'logs' is marked as crashed and last (automatic?) repair failed

Versuch 2 - Reparieren:

Can't create new tempfile: './mydb1/logs.TMD' |
| mydb1.logs| repair | status   | Operation failed

Wenn beide versuche nicht funktionieren, ist es Zeit für <strong>myisamchk</strong>.

Lösung mit MySQL MyIsamCheck

Zu MySQL-Data-Ordner wechseln:

cd /var/lib/mysql/mydb1/

Lösung 1: