- How to insert a lot of test data
- Find unused indices in Schema
- Create dates without gaps
- Compare two datasets
- Function based index
- ORDER BY nullable columns
- UNIQUE INDEX with excluded rows
- LEFT JOIN LATERAL - can be used to fetch recent records of multiple users.
- GROUP CONCAT
- SELECT fewer columns
- Monitoring Deadlocks & Locks
- SELECT FOR UPDATE
- SELECT FOR SHARE
- Solving deadlocks order
- Solving deadlocks sms
- Spot missing index
- Database size
- Tables size
- Columns size
- Count primary Keys
- Multiple primary Keys
- Count Keys
- Count References
- Foreign keys
- Isolated tables - can be used to count referenced tables
- Identify slow queries
- Number of tables
- Table info
- Columns info
- Statistics
- CREATE TABLE STATEMENT
- Databases
- Tables
- Columns
- Collations - can be used to identify tables with wrong charsets
- Variables
- Count errors
- Count Warnings
- Errors
- Index
- Table Status
- Warnings
- https://dev.mysql.com/doc/refman/8.0/en/
- https://vertabelo.com/blog/an-overview-of-mysqls-information-schema/
- https://vertabelo.com/blog/querying-mysqls-information-schema-why-how/
- https://www.sqlshack.com/learn-sql-the-information_schema-database/
- https://sqlfordevs.com/
- https://dev.mysql.com/doc/refman/5.7/en/show-collation.html
- http://youdidwhatwithtsql.com/spotting-missing-indexes-mariadb-mysql/2036/
- https://dev.mysql.com/doc/refman/8.0/en/lateral-derived-tables.html
- https://stackoverflow.com/questions/5836623/getting-lock-wait-timeout-exceeded-try-restarting-transaction-even-though-im