摘要:
select partition_name part,partition_expression expr,partition_description descr,table_rows from INFORMATION_SCHEMA.PARTITIONS where TABLE_SCHEMA=SCHE 阅读全文
摘要:
有一张表,共3个字段,id(自增长,主键), reading_record_id, book_id,其中reading_record_id和book_id联合起来建了一个唯一索引,当用RANGE(reading_record_id)去建分区表时会报错,把id和reading_record_id建成联 阅读全文
摘要:
yum -y install perl perl-DBI perl-DBD-MySQL perl-Time-HiRes perl-IO-Socket-SSL perl-Digest-MD5 到 https://www.percona.com/downloads/percona-toolkit/LAT 阅读全文