Scribd
Upload
7 views6 pages

MySQL Server Status Checklist

MySQL WinGen

Uploaded by

Antonio João
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
7 views6 pages

MySQL Server Status Checklist

MySQL WinGen

Uploaded by

Antonio João
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 6

tee MySQL_check_list.

log

system date /T

system echo
system echo --------------------------------------------------------
system echo Lista de clientes ativos no momento
system echo --------------------------------------------------------

# especifico para o MySQL Prezunic


system mysql -uroot -pprezunic -h 131.10.10.111 -P1106 -e"show processlist" |
find /V "Sleep"

system date /T

system echo
system echo --------------------------------------------------------
system echo Status da replica��o do $SERVICO
system echo --------------------------------------------------------

show slave status\G

system echo
system echo --------------------------------------------------------
system echo Status do master do $SERVICO
system echo --------------------------------------------------------

show master status\G

system echo
system echo --------------------------------------------------------
system echo Status do Engine Innodb
system echo --------------------------------------------------------

show innodb status\G

system date /T

system echo
system echo --------------------------------------------------------
system echo Taxa de utiliza��o dos disco do $SERVICO
system echo --------------------------------------------------------

#system iostat
#system iostat -x

system echo
system echo --------------------------------------------------------
system echo Status gerais do servidor mysql
system echo --------------------------------------------------------

show global status;

system echo
system echo --------------------------------------------------------
system echo Configuracoes deste servidor mysql
system echo --------------------------------------------------------

show global variables;

system echo
system echo
system date /T
system echo

system echo
system echo --------------------------------------------------------
system echo As 10 tabelas que ocupam mais espaco para dados
system echo --------------------------------------------------------

SELECT
TABLE_NAME NOME
,TABLE_SCHEMA ESQUEMA
,ENGINE
,TABLE_ROWS AVG_ROWS
# ,DATA_LENGTH/1024/1024/1024 "TAMANHO DADOS/GB"
# ,INDEX_LENGTH/1024/1024/1024 "TAMANHO INDICES/GB"
,DATA_LENGTH/1024/1024 "TAMANHO DADOS/MB"
,INDEX_LENGTH/1024/1024 "TAMANHO INDICES/MB"
from information_schema.tables
where TABLE_TYPE='BASE TABLE'
ORDER BY
DATA_LENGTH desc
,INDEX_LENGTH desc
,TABLE_SCHEMA
,TABLE_NAME
LIMIT 10;

system echo
system echo --------------------------------------------------------
system echo As 10 tabelas que ocupam mais espaco para indices
system echo --------------------------------------------------------

SELECT
TABLE_NAME NOME
,TABLE_SCHEMA ESQUEMA
,ENGINE
,TABLE_ROWS AVG_ROWS
# ,DATA_LENGTH/1024/1024/1024 "TAMANHO DADOS/GB"
# ,INDEX_LENGTH/1024/1024/1024 "TAMANHO INDICES/GB"
,DATA_LENGTH/1024/1024 "TAMANHO DADOS/MB"
,INDEX_LENGTH/1024/1024 "TAMANHO INDICES/MB"
from information_schema.tables
where TABLE_TYPE='BASE TABLE'
ORDER BY
INDEX_LENGTH desc
,DATA_LENGTH desc
,TABLE_SCHEMA
,TABLE_NAME
LIMIT 10;
system echo
system echo --------------------------------------------------------
system echo Espaco de dados e indices separados por engine
system echo --------------------------------------------------------

SELECT
ENGINE
# ,sum(DATA_LENGTH)/1024/1024/1024 "Tamanho dados/GB"
# ,sum(INDEX_LENGTH)/1024/1024/1024 "Tamanho indices/GB"
# ,(sum(DATA_LENGTH)+sum(INDEX_LENGTH))/1024/1024/1024 "Dados + Indices GB"
,sum(DATA_LENGTH)/1024/1024 "Tamanho dados/MB"
,sum(INDEX_LENGTH)/1024/1024 "Tamanho indices/MB"
,(sum(DATA_LENGTH)+sum(INDEX_LENGTH))/1024/1024 "Dados + Indices MB"
FROM information_schema.tables
WHERE
TABLE_TYPE='BASE TABLE'
GROUP by
ENGINE
;

system echo
system echo --------------------------------------------------------
system echo Verificando as 10 tabelas com mais colunas indexadas
system echo --------------------------------------------------------

SELECT
IX.table_schema
,IX.table_name
,IX.num_ix "COLUNAS INDEXADAS"
,count(COL.COLUMN_NAME) "TOTAL DE COLUNAS"
from INFORMATION_SCHEMA.COLUMNS COL
,(SELECT
table_schema
,table_name
,count(COLUMN_NAME) num_ix
from INFORMATION_SCHEMA.STATISTICS
group by
table_schema
,table_name
order by
num_ix DESC
LIMIT 10) IX
WHERE
IX.table_schema=COL.table_schema
and IX.table_name=COL.table_name
group by
IX.table_schema
,IX.table_name
,IX.num_ix
order by
IX.num_ix DESC
LIMIT 10;

system echo
system date

system echo
system echo -----------------------------------------------------------------
system echo Espaco de dados e indices de cada esquema separado por engine
system echo -----------------------------------------------------------------

SELECT
TABLE_SCHEMA "Esquema"
,ENGINE Engine
,count(1) "Soma Tabelas"
# ,sum(DATA_LENGTH)/1024/1024/1024 "Tamanho dados/GB"
# ,sum(INDEX_LENGTH)/1024/1024/1024 "Tamanho indices/GB"
# ,(sum(DATA_LENGTH)+sum(INDEX_LENGTH))/1024/1024/1024 "Dados + Indices GB"
,sum(DATA_LENGTH)/1024/1024 "Tamanho dados/MB"
,sum(INDEX_LENGTH)/1024/1024 "Tamanho indices/MB"
,(sum(DATA_LENGTH)+sum(INDEX_LENGTH))/1024/1024 "Dados + Indices MB"
from information_schema.tables
WHERE
TABLE_TYPE='BASE TABLE'
group by
TABLE_SCHEMA
# ,ENGINE
;

system echo
system echo -----------------------------------------------------------------
system echo Espaco livre na tablespace do InnoDB
system echo -----------------------------------------------------------------

# select TABLE_COMMENT from information_schema.tables where table_name='xml' or


table_name='tb_juros_parc_padrao';

system echo
system echo -----------------------------------------------------------------
system echo Versao do banco
system echo -----------------------------------------------------------------

show global variables like'version%';

system echo
system echo -----------------------------------------------------------------
system echo Versao do banco
system echo -----------------------------------------------------------------

select @@version Version


union select @@version_comment
union select @@version_compile_machine
union select @@version_compile_os
;

system echo
system echo -----------------------------------------------------------------
system echo Log de erros do MySQL
system echo -----------------------------------------------------------------

#system tail /$SERVICO/mysql/$(hostname -f).err


system echo
system echo -----------------------------------------------------------------
system echo Log do dump realizado hoje
system echo -----------------------------------------------------------------

#system cat /$SERVICO/orion/backup/log_dump_$(date +%a)

system echo
system echo -----------------------------------------------------------------
system echo Log do backup offline realizado hoje
system echo -----------------------------------------------------------------

#system cat /$SERVICO/orion/backup/log_backup_*_$(date +%a)

system echo
system echo
system date /T

system echo
system echo -----------------------------------------------------------------
system echo Processo MySQL em execucao
system echo -----------------------------------------------------------------

#system top -n 1 | grep -A 15 load

system echo
system echo -----------------------------------------------------------------
system echo Espaco ocupado das particoes no sistema
system echo -----------------------------------------------------------------

#system df -h

system echo
system echo -----------------------------------------------------------------
system echo Espaco ocupado das databases
system echo -----------------------------------------------------------------

#system du -ch /$SERVICO/mysql/

system echo
system echo -----------------------------------------------------------------
system echo Espaco ocupado dos log binarios e logs do InnoDB
system echo -----------------------------------------------------------------

#system du -ch /$SERVICO/log/

system echo
system echo -----------------------------------------------------------------
system echo Espaco ocupado com pela tablespace compartilhada do innodb
system echo -----------------------------------------------------------------

#system ls -l /$SERVICO/mysql/ib*

system echo
system echo -----------------------------------------------------------------
system echo Versao do systema operacional
system echo -----------------------------------------------------------------

#system uname -a

#system cat /etc/redhat-release

system echo
system echo -----------------------------------------------------------------
system echo Correspondencias internas no servidor
system echo -----------------------------------------------------------------

#system mail

system echo
system echo -----------------------------------------------------------------
system echo Fim do checklist no servidor $(hostname -f)
system echo -----------------------------------------------------------------

system echo
system date /T

You might also like