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.
| Category | Entity | Hackers | Commits | Lines added / removed |
|---|---|---|---|---|
| MDBC | MariaDB Corporation | 22 | 260 / 83.87% | 139,123 / 118,486 |
| MDBF | MariaDB Foundation | 6 | 30 / 9.68% | 4,480 / 3,194 |
| Provider | Amazon | 6 | 7 / 2.26% | 1,302 / 3,808 |
| Codership | 2 | 3 / 0.97% | 740 / 166 | |
| Other | Others | 7 | 10 / 3.23% | 460 / 159 |
| TOTAL | 43 | 310 | 146,105 / 125,813 |
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.
| Category | Entity | 2019 | 2020 | 2021 | 2022 | Totals |
|---|---|---|---|---|---|---|
| MDBC | MariaDB Corporation | 820 / 99.39% | 1,266 / 96.79% | 670 / 98.24% | 637 / 97.55% | 3,393 / 97.84% |
| MDBF | MariaDB Foundation | 0 | 1 / 0.08% | 7 / 1.03% | 0 | 8 / 0.23% |
| GSoC | GSoC | 0 | 0 | 0 | 10 / 1.53% | 10 / 0.29% |
| Other | Others | 5 / 0.6% | 41 / 3.13% | 5 / 0.73% | 6 / 0.92% | 57 / 1.64% |
| TOTAL | 825 | 1,308 | 682 | 653 | 3,468 |
Likewise the following is a table of the statistics for lines of code changes.
| Category | Entity | 2019 | 2020 | 2021 | 2022 | Totals |
|---|---|---|---|---|---|---|
| MDBC | MariaDB Corporation | 64,186 / 99,971 | 143,189 / 92,018 | 2,762,399 / 765,746 | 12,329,675 / 1,798,078 | 15,299,449 / 2,755,813 |
| MDBF | MariaDB Foundation | 0 | 0 / 12 | 61 / 60 | 0 | 61 / 72 |
| GSoC | GSoC | 0 | 0 | 0 | 4,764 / 1,196 | 4,764 / 1,196 |
| Other | Others | 62 / 56 | 2,207 / 1,999 | 150 / 119 | 9,349 / 290 | 11,768 / 2,464 |
| TOTAL | 64,248 / 100,027 | 145,396 / 94,029 | 2,762,610 / 765,925 | 12,343,788 / 1,799,564 | 15,316,042 / 2,759,545 |
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.
| Category | Entity | Hackers | Commits | Diff from last month |
|---|---|---|---|---|
| MDBC | MariaDB Corporation | 36 | 2,978 / 79.56% | 400 / 68.85% |
| MDBF | MariaDB Foundation | 8 | 534 / 14.26% | 177 / 30.46% |
| Provider | Codership | 5 | 54 / 1.44% | 1 / 0.17% |
| Amazon | 13 | 53 / 1.42% | 3 / 0.52% | |
| CONNECT | 1 | 1 / 0.03% | 0 | |
| Oracle Corporation | 1 | 1 / 0.03% | 0 | |
| Huawei | 1 | 2 / 0.05% | 0 | |
| Sponsor | IBM | 1 | 1 / 0.03% | 0 |
| GSoC | GSoC | 1 | 27 / 0.72% | 0 |
| Distro | All Distros | 4 | 11 / 0.29% | 0 |
| Other | Others | 35 | 81 / 2.16% | 0 |
| TOTAL | 106 | 3,743 | 581 |
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.
| Category | Entity | Lines added / removed | Diff from last month |
|---|---|---|---|
| MDBC | MariaDB Corporation | 1,446,188 / 576,064 94.27% / 94.23% | 128,303 / 76,216 85.04% / 88.78% |
| MDBF | MariaDB Foundation | 59,776 / 25,062 3.9% / 4.01% | 21,996 / 9,474 14.58% / 11.04% |
| Provider | Codership | 7,595 / 1,298 0.5% / 0.21% | 50 / 12 0.03% / 0.01% |
| Amazon | 3,121 / 4,682 0.2% / 0.77% | 520 / 149 0.34% / 0.17% | |
| CONNECT | 7 / 5 0% / 0% | 0 / 0 | |
| Oracle Corporation | 144 / 55 0.01% / 0.01% | 0 / 0 | |
| Huawei | 30 / 21 0% / 0% | 0 / 0 | |
| Sponsor | IBM | 1 / 0 0% / 0% | 0 / 0 |
| GSoC | GSoC | 5,188 / 1,968 0.34% / 0.32% | 0 / 0 |
| Distro | All Distros | 93 / 96 0.01% / 0.02% | 0 / 0 |
| Other | Others | 11,989 / 2,098 0.78% / 0.34% | 0 / 0 |
| TOTAL | 1,534,132 / 611,349 | 150,869 / 85,851 |
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 Ending | New PRs | Closed PRs | Merged PRs | Total PRs | Still Open PRs |
|---|---|---|---|---|---|
| 2022-09-04 | 11 | 1 | 6 | 2,243 | 117 |
| 2022-09-11 | 6 | 3 | 5 | 2,249 | 115 |
| 2022-09-18 | 9 | 3 | 4 | 2,258 | 117 |
| 2022-09-25 | 10 | 7 | 6 | 2,268 | 114 |
| 2022-10-02 | 2 | 1 | 5 | 2,270 | 110 |