macbre/index-digest
Analyses your database queries and schema and suggests indices and schema improvements
PythonMIT
Issues
- 0
Use yamlloader
#234 opened by macbre - 0
Label the Docker image with git repository
#220 opened by macbre - 0
- 0
Introduce json reports formatter
#211 opened by macbre - 0
Report unique indices that cover nullable columns
#162 opened by macbre - 0
Detect UUID used as a primary key
#181 opened by macbre - 0
- 0
queries_not_using_index - ignore reports with "No matching min/max row" / "Select tables optimized away"
#210 opened by macbre - 0
Emit JSON-formatted logs when running from Docker
#153 opened by macbre - 0
- 2
PSQL Support ?
#159 opened by bheemreddy181-zz - 1
Dockerize index-digest and push it to Docker Hub
#150 opened by macbre - 1
queries_not_using_index | handle "No tables used"
#148 opened by macbre - 0
Detect empty databases
#146 opened by macbre - 2
non_utf_columns | handle blobs types
#143 opened by macbre - 0
- 0
- 1
- 1
Ignore views
#130 opened by macbre - 0
Handle tables names with dashes
#132 opened by macbre - 0
Treat forum_creation_temp as temporary table
#131 opened by macbre - 0
Rows count query can lock the MySQL slave
#127 opened by macbre - 0
Avoid high offsets in queries
#118 opened by macbre - 0
- 1
data_too_old / data_not_updated_recently - report timestamp column name and table size
#120 opened by macbre - 0
Report primary keys with a generic "id" name
#94 opened by macbre - 0
Allow to lint a local SQL schema dump file
#117 opened by macbre - 0
- 1
- 0
- 0
Report queries with HAVING clause
#93 opened by macbre - 1
Report select queries with *
#92 opened by macbre - 1
- 0
- 0
Consider adding checks from sqlcheck
#73 opened by macbre - 0
Consider adding checks from SchemaCrawler
#84 opened by macbre - 0
Report empty tables
#89 opened by macbre - 0
Cache table schema
#86 opened by macbre - 0
Report tables with just a single column
#74 opened by macbre - 0
Report INSERT IGNORE queries
#70 opened by macbre - 0
Report tables with "test" word in a name
#75 opened by macbre - 0
Add syslog results reporter
#72 opened by macbre - 0
Add YAML results formatter
#68 opened by macbre - 0
Publish to PyPI
#69 opened by macbre - 0
Cache database meta-data
#57 opened by macbre - 0
Support MySQL 8.0
#61 opened by macbre - 0
Suppress MySQL warnings when EXPLAIN is run
#63 opened by macbre - 0
Run Travis tests using MySQL 5.5, 5.6, 5.7 and 8.0
#60 opened by macbre - 1
Add support for MariaDB
#66 opened by macbre - 0
Handle anemometer data as an input
#56 opened by macbre