MySQL/MariaDB常用SQL

查看表空间使用

SELECT 
     table_schema as `db`, 
     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 char_length(description)/1024/1024 FROM `table_name`

Enable general log

set global general_log_file='/var/log/mariadb/maria_general.log';

set global general_log=on;

set global general_log=off;

show global variables like '%general%';

从CSV Load data

LOAD DATA LOCAL INFILE '/Users/ben/Desktop/check.csv' 
INTO TABLE test
COLUMNS TERMINATED BY ','
IGNORE 1 LINES
(@col1)
SET id=@col1

Check all current process

show [full] processlist;

Show privileges

SHOW GRANTS FOR 'root'@'localhost';