SELECT table_schema, sum( data_length + index_length ) / 1024 / 1024 "DB Size in MB" FROM information_schema.TABLES where table_schema = "DB Name" GROUP BY table_schema ;SELECT table_schema, SUM(data_length+index_length)/1024/1024 AS total_mb,...【阅读全文】
1.添加分区------------------range -----------------------------create table tb_add_part_test ( id int, fname varchar(25), lname varchar(25), dob date)partition by range(year(dob)) (partition p0 values less ...【阅读全文】
初始表CREATE TABLE IF NOT EXISTS `time` ( `a` int(11) NOT NULL AUTO_INCREMENT, `b` int(11) NOT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB; 更改表为partitionALTER TABLE timePARTITION BY RANGE(id)(PARTITION p0 VALUES LESS THAN (3),PARTITION p1 VALUES LESS THAN (4));&nb...【阅读全文】
点击(此处)折叠或打开CREATE TEMPORARY TABLE view_table1 SELECT yh_id,SUM(jine) AS jine FROM liushuizhang WHERE lb IN(3,4) GROUP BY yh_id;CREATE TEMPORARY TABLE view_table2 SELECT yh_id,SUM(jine) AS jine FROM liushuizhang WHERE lb IN(1,2) GROUP BY yh_id;...【阅读全文】
在my.conf里有一个参数,expire-logs-days = 15这个参数用来设置MySQL日志的保存期限。现在我们要把它设置为5 天。使用sed完成这项工作,1, 用sed注释掉原来的内容。2, 在注释的内容后添加修改的部分。例如。登陆MySQL的SHELL,执行 set global expire_logs_days=5;...【阅读全文】