mysql-notes.md

MySQL Notes

Useful Queries

Size Specific Table

SELECT
	table_name AS `Table`,
	round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB`
FROM
	information_schema.TABLES
WHERE
	table_schema = 'db_name'
	AND table_name = 'table_name';

Size All Table (DESC)

SELECT
	table_schema AS `Database`,
	table_name AS `Table`,
	round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB`
FROM
	information_schema.TABLES
ORDER BY
	(data_length + index_length)
	DESC;

Readings

• https://www.datadoghq.com/blog/monitoring-mysql-performance-metrics/
• https://docs.datadoghq.com/database_monitoring/setup_mysql/gcsql/?tab=mysql56
• https://www.datadoghq.com/blog/collecting-mysql-statistics-and-metrics/
• https://blog.searce.com/monitoring-gcp-cloudsql-postgresql-with-percona-pmm-923d79a80881