Contribution Statistics September 2022

Last month we provided contributor statistics for the last few years. We have had some fantastic feedback from this so today we are presenting you with another drop of contributor statistics for the last month. Normally we would be doing these quarterly but there are so many extra things to report that we decided to do a bonus one now.

Some key things have happened in the last month which affect the data, the first is that MariaDB 10.11 has had a preview release. Which means there has been a flurry of activity around this. Also a feature request from Otto Kekäläinen was to add hacker counts, the CSV outputs have been modified to add this and this will be visible in this report.

The final change to the data this month is the inclusion of the MariaDB ColumnStore Engine and libmarias3 trees so that they get their own contributor statistic outputs. These are git submodules which are pulled in to build parts of MariaDB Server.

The raw CSV data for most of this report can be found in the GitHub release snapshot. With the exception of the data for the 10.11 branch which was generated using a custom set of commands on the data.

For the initial illustration this time there is a quick report on the code changes for just the 10.11 branch since the branch was forked on the 25th July 2022.

CategoryEntityHackersCommitsLines added / removed
MDBCMariaDB Corporation22260 / 83.87%139,123 / 118,486
MDBFMariaDB Foundation630 / 9.68%4,480 / 3,194
ProviderAmazon67 / 2.26%1,302 / 3,808
Codership23 / 0.97%740 / 166
OtherOthers710 / 3.23%460 / 159
TOTAL43310146,105 / 125,813
Table 1. Commits since 2022-07-25 in the 10.11 branch

That is an awful lot of code in a very short amount of time, we thank everyone who contributed to it. Of course it does not tell the whole picture of contributions, there have been many commits to other branches which have not yet made it into the 10.11 release.

MariaDB ColumnStore

MariaDB ColumnStore is bundled with MariaDB Server but it is made up of many separate processes as it is designed to run as a clustered system. The basic plugin code to talk to this system is in MariaDB Server but the execution code is in a separate tree called MariaDB ColumnStore Engine which is pulled as a git submodule to MariaDB Server. As such this has separate contribution statistics. The following shows the commit contributions since 2019.

CategoryEntity2019202020212022Totals
MDBCMariaDB Corporation820 / 99.39%1,266 / 96.79%670 / 98.24%637 / 97.55%3,393 / 97.84%
MDBFMariaDB Foundation01 / 0.08%7 / 1.03%08 / 0.23%
GSoCGSoC00010 / 1.53%10 / 0.29%
OtherOthers5 / 0.6%41 / 3.13%5 / 0.73%6 / 0.92%57 / 1.64%
TOTAL8251,3086826533,468
Table 2. MariaDB ColumnStore Engine commit statistics

Likewise the following is a table of the statistics for lines of code changes.

CategoryEntity2019202020212022Totals
MDBCMariaDB Corporation64,186 / 99,971143,189 / 92,0182,762,399 / 765,74612,329,675 / 1,798,07815,299,449 / 2,755,813
MDBFMariaDB Foundation00 / 1261 / 60061 / 72
GSoCGSoC0004,764 / 1,1964,764 / 1,196
OtherOthers62 / 562,207 / 1,999150 / 1199,349 / 29011,768 / 2,464
TOTAL64,248 / 100,027145,396 / 94,0292,762,610 / 765,92512,343,788 / 1,799,56415,316,042 / 2,759,545
Table 3. MariaDB ColumnStore Engine lines added/removed

An interesting thing to observe here is over the years the number of commits appear to have reduced, but the average size of the commits are much larger.

MariaDB Server

The next table represents the MariaDB Server commits for 2022 updated to include the last month.

CategoryEntityHackersCommitsDiff from last month
MDBCMariaDB Corporation362,978 / 79.56%400 / 68.85%
MDBFMariaDB Foundation8534 / 14.26%177 / 30.46%
ProviderCodership554 / 1.44%1 / 0.17%
Amazon1353 / 1.42%3 / 0.52%
CONNECT11 / 0.03%0
Oracle Corporation11 / 0.03%0
Huawei12 / 0.05%0
SponsorIBM11 / 0.03%0
GSoCGSoC127 / 0.72%0
DistroAll Distros411 / 0.29%0
OtherOthers3581 / 2.16%0
TOTAL1063,743581
Table 4. MariaDB Server commits by organisation

This shows that 15% of this year’s commits have been contributed in just one month! (~11% of the year so far). Also more than half the contributors to MariaDB Server this year have come from outside of the MariaDB Foundation and MariaDB Corporation.

Next up is the lines added and removed from MariaDB Server.

CategoryEntityLines added / removedDiff from last month
MDBCMariaDB Corporation1,446,188 / 576,064
94.27% / 94.23%
128,303 / 76,216
85.04% / 88.78%
MDBFMariaDB Foundation59,776 / 25,062
3.9% / 4.01%
21,996 / 9,474
14.58% / 11.04%
ProviderCodership7,595 / 1,298
0.5% / 0.21%
50 / 12
0.03% / 0.01%
Amazon3,121 / 4,682
0.2% / 0.77%
520 / 149
0.34% / 0.17%
CONNECT7 / 5
0% / 0%
0 / 0
Oracle Corporation144 / 55
0.01% / 0.01%
0 / 0
Huawei30 / 21
0% / 0%
0 / 0
SponsorIBM1 / 0
0% / 0%
0 / 0
GSoCGSoC5,188 / 1,968
0.34% / 0.32%
0 / 0
DistroAll Distros93 / 96
0.01% / 0.02%
0 / 0
OtherOthers11,989 / 2,098
0.78% / 0.34%
0 / 0
TOTAL1,534,132 / 611,349150,869 / 85,851
Table 5. MariaDB Server lines of code added / removed

This shows a similar contribution ratio to that of the commits for this past month which is to be expected.

Finally the pull request counts for the last month. There was a small spike in closed pull requests on the week ending 2022-09-25 as some had been closed after attempts to contact the contributors had failed. But the contributors are welcome to reopen and/or discuss a pull request with the MariaDB Foundation team at their leisure.

Week EndingNew PRsClosed PRsMerged PRsTotal PRsStill Open PRs
2022-09-0411162,243117
2022-09-116352,249115
2022-09-189342,258117
2022-09-2510762,268114
2022-10-022152,270110
Table 6. MariaDB Server pull request counts

Published by Andrew Hutchings

Chief Contributions Officer for the MariaDB Foundation