SELECT * FROM information_schema.processlist WHERE command != ‘Sleep’ ORDER BY id\G Source – https://makandracards.com/makandra/7681-show-mysql-process-list-without-sleeping-c..
Category : Mysql
Quick cheatsheet from here – https://www.rosehosting.com/blog/optimizing-and-repairing-mysql-databases-with-mysqlcheck/ 1. Check one table in the MySQL database mysqlcheck -c database table -u root -p 2. Check ALL tables in the MySQL database mysqlcheck -a database -u root -p 3. Optimize all tables in all MySQL database mysqlcheck -o database -u root -p 4. Repair MySQL database mysqlcheck -r ..
Look, you could just download an rpm and run it, it’s not hard, but meh! Lazy, yum it, mine said mariadb, I though why not. yum install mariadb-serv..