mysql / mysql-workbench

Intro

File size measurements show the distribution of size of files.
Files are classified in four categories based on their size (lines of code): 1-100 (very small files), 101-200 (small files), 201-500 (medium size files), 501-1000 (long files), 1001+(very long files).
It is a good practice to keep files small. Long files may become "bloaters", code that have increased to such gargantuan proportions that they are hard to work with.

Learn more...

File Size Overall

There are 3,388 files with 806,841 lines of code.

131 very long files (354,634 lines of code)
193 long files (136,953 lines of code)
525 medium size files (166,578 lines of codeclsfd_ftr_w_mp_ins)
552 small files (81,246 lines of code)
1,987 very small files (67,430 lines of code)

Legend:

1001+

501-1000

201-500

101-200

1-100

explore: grouped by folders | grouped by size | sunburst | 3D view

File Size per Extension

1001+

501-1000

201-500

101-200

1-100

File Size per Logical Decomposition

primary

1001+

501-1000

201-500

101-200

1-100

Longest Files (Top 50)

File	# lines	# units
15a_res.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	8721	-
15_res.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	8721	-
ctype-euc_kr.cpp in library/sql.parser/source	8687	4
ctype-uca.cpp in library/sql.parser/source	8537	25
15.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	8376	-
15a.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	8376	-
ctype-extra.cpp in library/sql.parser/source	8351	-
ctype-eucjpms.cpp in library/sql.parser/source	8109	4
ctype-ujis.cpp in library/sql.parser/source	8000	4
Editor.cxx in ext/scintilla/src	6829	254
ctype-big5.cpp in library/sql.parser/source	6281	13
ctype-gb2312.cpp in library/sql.parser/source	5738	4
wb_admin_variable_list.py in plugins/wb.admin/backend/config/gen-opt	5714	-
wb_admin_variable_list.py in plugins/wb.admin/backend	5714	-
703_res.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	5710	-
700_res.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	5710	-
703a_res.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	5494	-
700a_res.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	5494	-
703.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	5431	-
700.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	5431	-
ctype-cp932.cpp in library/sql.parser/source	5412	11
world.sql in testing/test-suite/data/db/world	5353	-
703a.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	5217	-
700a.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	5216	-
raw_vars.py in plugins/wb.admin/backend/config/gen-opt	4652	-
ctype-sjis.cpp in library/sql.parser/source	4596	11
sakila-schema.xml in testing/test-suite/data/diff/sakila-db	4503	-
MySQLParser.g4 in library/parsers/grammars	4351	-
CharacterCategory.cxx in ext/scintilla/lexlib	3934	11
ctype-utf8.cpp in library/sql.parser/source	3730	22
cotire.cmake in build/cmake/Modules	3647	-
mysql_rdbms_info.xml in modules/db.mysql/res	3315	-
ScintillaWin.cxx in ext/scintilla/win32	2814	145
PlatWin.cxx in ext/scintilla/win32	2795	187
Document.cxx in ext/scintilla/src	2771	162
DbMysqlTableEditor.Designer.cs in plugins/db.mysql.editors/windows/cs	2716	2
ScintillaGTK.cxx in ext/scintilla/gtk	2632	156
main_menu.xml in res/wbdata	2548	-
mysql_workbench_fragment.xml in build/msi/source	2417	-
wb_sql_editor_form.cpp in backend/wbprivate/sqlide	2415	107
wb_context.cpp in backend/wbprivate/workbench	2333	107
editor_table.cpp in backend/wbpublic/grtdb	2332	108
nasty_tables.sql in testing/test-suite/data/db	2302	-
5_res.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	2299	-
5a_res.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	2299	-
mysql_rdbms_info.xml in testing/test-suite/data/res	2294	-
glade gui_test_application.glade in tools/test-gui/linux	2282	-
LexHTML.cxx in ext/scintilla/lexers	2262	41
module_db_mysql.cpp in modules/db.mysql/src	2233	141
glade editor_mysql_table.glade in plugins/db.mysql.editors/linux/res	2227	-

Files With Most Units (Top 50)

File	# lines	# units
Editor.cxx in ext/scintilla/src	6829	254
wb_server_management.py in plugins/wb.admin/backend	1613	194
grt.h in library/grt/src	1895	188
PlatWin.cxx in ext/scintilla/win32	2795	187
Document.cxx in ext/scintilla/src	2771	162
ScintillaGTK.cxx in ext/scintilla/gtk	2632	156
grtpp_value.cpp in library/grt/src	1163	152
lf_treeview.cpp in library/forms/gtk/src	1668	150
ScintillaWin.cxx in ext/scintilla/win32	2814	145
module_db_mysql.cpp in modules/db.mysql/src	2233	141
wb_admin_export.py in plugins/wb.admin/frontend	1965	141
explain_renderer.py in plugins/wb.query.analysis	1324	130
accessible.cpp in tools/mga/src/aal/macos	1700	127
accessible.cpp in tools/mga/src/aal/linux	1580	123
wb_admin_security.py in plugins/wb.admin/frontend	1712	118
ScintillaCocoa.mm in ext/scintilla/cocoa	1611	114
PlatCocoa.mm in ext/scintilla/cocoa	1498	112
PlatGTK.cxx in ext/scintilla/gtk	1718	110
editor_table.cpp in backend/wbpublic/grtdb	2332	108
wb_module.cpp in backend/wbprivate/workbench	1502	108
wb_context.cpp in backend/wbprivate/workbench	2333	107
wb_sql_editor_form.cpp in backend/wbprivate/sqlide	2415	107
accessible.cpp in tools/mga/src/aal/windows	443	106
accessible.wr.cpp in tools/mga/src/aal/windows/accessible.wr	1082	102
CellBuffer.cxx in ext/scintilla/src	989	98
PlatQt.cpp in ext/scintilla/qt/ScintillaEditBase	1017	97
ObjectListeners.cpp in modules/db.mysql.parser/src	1331	93
wb_server_control.py in plugins/wb.admin/backend	656	92
db_mysql_catalog_report.cpp in modules/db.mysql/src	555	91
canvas.py in library/python/workbench/graphics	487	91
code_editor.cpp in library/forms	1310	91
MainForm.cs in frontend/windows/MySQLWorkbench	1518	90
grt_shell_window.cpp in frontend/common	1646	87
recordset_be.cpp in backend/wbpublic/sqlide	1486	87
cairo_utils.py in library/python/workbench/graphics	505	86
TreeViewAdv.cs in ext/Aga.Controls/Tree	1027	86
wb_model_diagram_form.cpp in backend/wbprivate/model	1199	86
home_screen_connections.cpp in library/forms	1378	84
main_form.cpp in frontend/linux/workbench	1360	84
wf_treeview.cpp in library/forms/winforms/src	985	83
wf_view.cpp in library/forms/winforms/src	927	82
ModelOverviewForm.cs in frontend/windows/MySQLWorkbench	1491	82
wb_live_schema_tree.cpp in backend/wbprivate/sqlide	1817	79
mdc_canvas_view.cpp in library/mysql.canvas/src	974	77
wb_admin_perfschema_instrumentation.py in plugins/wb.admin/frontend	1080	77
jsexport.cpp in tools/mga/src/library	1413	75
mdc_canvas_item.cpp in library/mysql.canvas/src	877	73
jsonview.cpp in library/forms	1386	72
mysql_table_editor.cpp in plugins/db.mysql.editors/backend	1648	71
FlatTabControl.cs in frontend/windows/WBControls	1659	70

Files With Long Lines (Top 50)

There are 914 files with lines longer than 120 characters. In total, there are 26487 long lines.

File	# lines	# units	# long lines
15a_res.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	8721	-	1025
15_res.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	8721	-	1025
15.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	8376	-	1024
15a.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	8376	-	1024
sakila-schema.xml in testing/test-suite/data/diff/sakila-db	4503	-	886
703.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	5431	-	809
700.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	5431	-	808
703a.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	5217	-	802
700a.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	5216	-	800
703_res.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	5710	-	720
700_res.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	5710	-	719
703a_res.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	5494	-	712
700a_res.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	5494	-	711
mysql_common_ui.xml in build/msi/source	811	-	394
5_res.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	2299	-	305
5a_res.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	2299	-	305
5.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	2006	-	303
5a.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	2007	-	303
world.sql in testing/test-suite/data/db/world	5353	-	240
raw_vars.py in plugins/wb.admin/backend/config/gen-opt	4652	-	191
mysql_rdbms_info.xml in modules/db.mysql/res	3315	-	180
7a.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	954	-	165
400a.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	998	-	162
400.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	997	-	162
7.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	922	-	159
7a_res.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	1009	-	154
world-schema.xml in testing/test-suite/data/diff/world	787	-	153
7_res.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	977	-	150
400_res.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	1070	-	145
400a_res.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	1070	-	145
wb_admin_variable_list.py in plugins/wb.admin/backend/config/gen-opt	5714	-	144
wb_admin_variable_list.py in plugins/wb.admin/backend	5714	-	144
main_menu.xml in res/wbdata	2548	-	133
12_res.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	574	-	94
12a_res.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	574	-	94
12.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	549	-	93
12a.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	550	-	93
900.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	581	-	93
900a.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	576	-	93
DbMysqlTableEditor.Designer.cs in plugins/db.mysql.editors/windows/cs	2716	2	93
0a_res.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	551	-	86
0_res.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	551	-	86
0a.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	543	-	85
0.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	526	-	85
mysql_rdbms_info.xml in testing/test-suite/data/res	2294	-	85
cotire.cmake in build/cmake/Modules	3647	-	85
structs.db.xml in res/grt	418	-	83
900a_res.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	606	-	81
900_res.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	612	-	81
8a.xml in testing/test-suite/data/modules_grt/wb_mysql_import/sql	491	-	81

Correlations

File Size vs. Commits (all time): 3214 points

		8721.0	lines of code min: 1.0 average: 246.43 25th percentile: 23.0 median: 66.0 75th percentile: 209.0 max: 8721.0
0	284.0
commits (all time) min: 1.0 \| average: 15.25 \| 25th percentile: 4.0 \| median: 11.0 \| 75th percentile: 19.0 \| max: 284.0

File Size vs. Contributors (all time): 3214 points

		8721.0	lines of code min: 1.0 average: 246.43 25th percentile: 23.0 median: 66.0 75th percentile: 209.0 max: 8721.0
0	14.0
contributors (all time) min: 1.0 \| average: 4.48 \| 25th percentile: 2.0 \| median: 5.0 \| 75th percentile: 6.0 \| max: 14.0

File Size vs. Commits (30 days): 0 points

No data for "commits (30d)" vs. "lines of code".

File Size vs. Contributors (30 days): 0 points

No data for "contributors (30d)" vs. "lines of code".

File Size vs. Commits (90 days): 6 points

		463.0	lines of code min: 7.0 average: 147.33 25th percentile: 13.75 median: 107.0 75th percentile: 253.75 max: 463.0
0	1.0
commits (90d) min: 1.0 \| average: 1.0 \| 25th percentile: 1.0 \| median: 1.0 \| 75th percentile: 1.0 \| max: 1.0

File Size vs. Contributors (90 days): 6 points

		463.0	lines of code min: 7.0 average: 147.33 25th percentile: 13.75 median: 107.0 75th percentile: 253.75 max: 463.0
0	1.0
contributors (90d) min: 1.0 \| average: 1.0 \| 25th percentile: 1.0 \| median: 1.0 \| 75th percentile: 1.0 \| max: 1.0