MYSQL KOMUTLARI

1) TABLE DISK SIZE

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 TABLE_NAME AS "Table Name",
table_rows AS "Quant of Rows", ROUND( (
data_length + index_length
) /1024, 2 ) AS "Total Size Kb"
FROM information_schema.TABLES
WHERE information_schema.TABLES.table_schema = 'YOUR SCHEMA NAME/DATABASE NAME HERE'
LIMIT 0 , 30;

SELECT table_schema "DB Name",
Round(Sum(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB"
FROM   information_schema.tables
GROUP  BY table_schema;

2)MYSQL  AYAR
SELECT  @@innodb_buffer_pool_size
Değeri listeler

SET GLOBAL interactive_timeout=60;
SET GLOBAL connect_timeout=60;

SET GLOBAL innodb_buffer_pool_size=402653184;
3)Query Timeout in MySQL Workbench | Error Code: 2013. Lost connection to MySQL server during query