Get Instant Solutions for Kubernetes, Databases, Docker and more
df -h
grep '1204' /var/log/mysql/error.log
SHOW TABLE STATUS LIKE 'your
table
name';
SHOW VARIABLES LIKE 'innodb
data
file_path';
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;
SELECT variable
name, variable
value FROM information
schema.global
status WHERE variable
name IN ('Innodb
data
written', 'Innodb
data_read');
SET GLOBAL innodb
data
file_path = 'ibdata1:12M:autoextend';
Note: Adjust the size (`12M`) according to your requirements.
(Perfect for DevOps & SREs)
(Perfect for DevOps & SREs)
Get Instant Solutions for Kubernetes, Databases, Docker and more
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.
Block quote
Ordered list
Unordered list
Bold text
Emphasis
Superscript
Subscript
(Perfect for DevOps & SREs)
(Perfect for DevOps & SREs)