Computing

[MySQL] Generate ERD in MySQL workbench

2021-11-30 C.H. Ling 0

To present the solution design, Entity-Relationship Diagram (ERD) is still one of the common diagram to present data and its relationship. But it is the nightmary if draw it as it is complicated and human […]

Database

[Database] MySQL Tunning

2021-04-12 C.H. Ling 0

For tuning MySQL, normally it will check index scan, cache and any hardware allocation align with database or not. To measure it, there are several tools to support your judgement.