Monitorear Conexiones "Procesos" ejecutandosen en la Instancia de MySQL

Revisión Full de los procesos

SHOW FULL PROCESSLIST;

SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;

SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;

SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE COMMAND != 'Sleep' and command!='Binlog Dump';

SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE COMMAND != 'Sleep' and command!='Binlog Dump';

SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE COMMAND != 'Sleep' AND TIME >= 0;

SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE COMMAND != 'Sleep' AND TIME >= 0;

SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE COMMAND != 'Sleep' AND TIME >= 5;

SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE COMMAND != 'Sleep' AND TIME >= 5;

SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE COMMAND != 'Sleep' AND INFO LIKE '%UPDATE %';

SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE COMMAND != 'Sleep' AND INFO LIKE '%UPDATE %';

SELECT `ID`, `USER`, `HOST`, `DB`, `COMMAND`, `TIME`, `STATE`, LEFT(`INFO`, 51200) AS `Info` FROM `information_schema`.`PROCESSLIST`
where command <> 'sleep' order by time desc;

SELECT `ID`, `USER`, `HOST`, `DB`, `COMMAND`, `TIME`, `STATE`, LEFT(`INFO`, 51200) AS `Info` FROM `information_schema`.`PROCESSLIST` where command <> 'sleep' order by time desc;

SELECT `ID`, `USER`, `HOST`, `DB`, `COMMAND`, `TIME`, `STATE`, LEFT(`INFO`, 51200) AS `Info` FROM `information_schema`.`PROCESSLIST`
where command !='Sleep'
order by 6 desc;

SELECT `ID`, `USER`, `HOST`, `DB`, `COMMAND`, `TIME`, `STATE`, LEFT(`INFO`, 51200) AS `Info` FROM `information_schema`.`PROCESSLIST` where command !='Sleep' order by 6 desc;

Backup de 1 o mas Tablas de una Base de Datos en MySQL

Hacer Backup de 1 o mas Tablas de una Base de Datos en MySQL

mysqldump -p -uroot BasedeDatos  tabla1 tabla2 > /Backup/backup_tablas_consolidado_2018.bkp

Backup Full de una Base de Datos MySQL y Comprimirlo

Hacer un Backup Full de una Base de Datos MySQL y Comprimirlo


A disco Local:

mysqldump --add-drop-database --add-drop-table -B --create-options --log-error=/backup/errores_backup_full_BasedeDatos_29042019.log --routines --triggers -S/tmp/mysql1.sock -uroot -p BasedeDatos |gzip >/backup/BasedeDatos_29042019.gz

Ignoring query to other database - Error MySQL

Ignoring query to other database - Error

Nos puede pasar en algunas ocasiones que al querer conectarnos a la base de datos MySQL por Linux nos de el siguiente error: "Ignoring query to other database"

El problema:  "mysql -root -p -S/data1/mysql.sock_1"
Normalmente nos pasa a los que tenemos apuro y nos olvidamos de escribir bien la sintaxis.

La solución; "mysql -u  root -p -S/data1/mysql.sock_1"
Aquí podemos verificar que la diferencia de la primera con la segunda es la falta de la "u" antes del usuario de la base.

Tomado del enlace: http://codejd.blogspot.com/2015/04/ignoring-query-to-other-database-error.html