Skip to content

JeffXue/analyse-database-size

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

5 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Example

样例图片

Config

file: config.ini

config the mysql connection information,only support mysql

[db]
ip=192.168.1.200
port=3306
user=root
password=123456
database=test

set you target table and sql you can change the user_id to adapter you key and add some where condition into the sql, but you should only get the count num in first column

[tables]
tables=yourtablename,secondtable # splide with ","
sql=SELECT COUNT(user_id) FROM %s.%s GROUP BY user_id

Run

python start.py 

check the result dir

About

mysql数据库表量级分析工具

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published