index-digest
index-digest copied to clipboard
macbre
Analyses your database queries and schema and suggests indices and schema improvements
Bumps [coverage](https://github.com/nedbat/coveragepy) from 6.5.0 to 7.5.1. Changelog Sourced from coverage's changelog. Version 7.5.1 — 2024-05-04 Fix: a pragma comment on the continuation lines of a multi-line statement now excludes the...
![dependabot[bot] avatar](https://avatars.githubusercontent.com/in/29110?v=4 "dependabot[bot] avatar"){kind=avatar}
https://github.com/Phynix/yamlloader `yamlordereddictloader` says: > DEPRECATED: the Phynix/yamlloader project provide an improved version of this library with unit tests, performance improvements (by providing access to the C implementation of PyYAML) and...
To be used by [our GitHub action](https://github.com/macbre/actions-index-digest). See https://github.com/macbre/actions-index-digest/pull/5/commits/86302029a17f1a18a51d08b29ce4ef9062f0d150
https://www.percona.com/blog/2019/11/22/uuids-are-popular-but-bad-for-performance-lets-discuss/
https://dev.mysql.com/doc/refman/8.0/en/create-index.html#create-index-unique > A `UNIQUE` index permits multiple `NULL` values for columns that can contain `NULL`. ## Links * https://medium.com/@aleksandrasays/dealing-with-mysql-nulls-and-unique-constraint-d260f6b40e60 ## Examples ```sql CREATE TABLE `progress` ( `id` int(10) unsigned NOT...
```sql SELECT foo FROM 0019_queries_not_using_indices WHERE 1 = 0; -- mysql@localhost[index_digest]>explain SELECT foo FROM 0019_queries_not_using_indices WHERE 1 = 0; +----+-------------+-------+------------+------+---------------+------+---------+------+------+----------+------------------+ | id | select_type | table | partitions | type...
* https://github.com/madzak/python-json-logger#customizing-fields * https://github.com/logmatic/logmatic-python#usage ### Customization * `SYSLOG_APPNAME` - defaults to `index-digest`
```sql VoteHelper::isVoted 54.47% [ap] db:local | SELECT count(*) as cnt FROM `page_vote` WHERE article_id = X AND user_id = X LIMIT N VoteHelper::getVoteCount 45.40% [ap] db:local | SELECT count(*) as...
* check text columns if they contain IP addresses * suggest `varbinary(16)` for storing IPv4/v6 addresses https://www.designcise.com/web/tutorial/whats-the-best-way-to-store-an-ip-address-in-mysql > To optimize the storage of an IP address (v4 or v6) in...
```sql | 2317800865 | wikia_foo | 1.8.2.0:55020 | wikicities | Query | 0 | statistics | SELECT /* WikiFactoryLoader::execute::domaindb */ city_id,city_public,city_factory_timestamp,city_url,city_dbname,city_cluster FROM `city_list` WHERE city_list.city_id = '252723' LIMIT 1 |...