I use Gephi a good deal to visualize connections between tables and schemas in a messy production MySQL database, mostly with the aim to stop people (read: consultants, junior developers, managers trying their hand writing SQL) from developing ad hoc duplicate tables for their own niche purposes.
Gephi lets me show how this kind of table bloat happens over time and helps explain performance degradation.
This is interesting I have seen Gephi before but never used it. Do you have any links or posts explaining how you use it to visualise connections in MySQL? I would like to do something similar with Oracle.
Gephi lets me show how this kind of table bloat happens over time and helps explain performance degradation.