mysql

Published by onesixx on

 

datafile 위치

show variables like 'datadir';

# Variable_name, Value
‘datadir’, ‘/var/lib/mysql/’

 

https://www.lesstif.com/pages/viewpage.action?pageId=17105786

MySQL 테이블 및 데이타베이스 크기 알아내기

SELECT TABLE_NAME AS 'Tables',
       round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB'
FROM information_schema.TABLES
WHERE table_schema = "wordpress"
ORDER BY (data_length + index_length) DESC;

 

 

 

 

Categories: Ubuntu

onesixx

Blog Owner

Leave a Reply

Your email address will not be published.