MySQL常用命令
-- MySQL查询DB占用空间:
select concat(truncate(sum(data_length)/1024/1024,2),'MB') as data_size,
concat(truncate(sum(max_data_length)/1024/1024,2),'MB') as max_data_size,
concat(truncate(sum(data_free)/1024/1024,2),'MB') as data_free,
concat(truncate(sum(index_length)/1024/1024,2),'MB') as index_size
from information_schema.tables where TABLE_SCHEMA = 'schema_name';
-- MySQL查询表占用空间:
select concat(truncate(sum(data_length)/1024/1024,2),'MB') as data_size,
concat(truncate(sum(max_data_length)/1024/1024,2),'MB') as max_data_size,
concat(truncate(sum(data_free)/1024/1024,2),'MB') as data_free,
concat(truncate(sum(index_length)/1024/1024,2),'MB') as index_size
from information_schema.tables where TABLE_NAME = 'table_name';
Redis
Redis集群架构
参考文档:https://blog.csdn.net/yejingtao703/article/details/78484151
Redis持久化
参考文档:http://ifeve.com/redis-persistence/
HBASE
HBASE架构设计
HBASE rowkey设计
Rowkey唯一原则:HBASE是根据key-value格式储存数据的,同样的rowkey数据会相互覆盖
Rowkey长度原则:rowkey尽量越短越好,持久化文件HFile中是按照KeyValue存储的,rowkey过长会影响检索效率
Rowkey散列原则:设计的Rowkey应均匀的分布在各个HBase节点上,可在rowkey高位加上几位随机数,避免所有数据都几种在某几台服务器上,导致资源分配不均