Everyone wants performance. Speeding up the insert into empty InnoDB tables and partitions is a common enough use case to optimize. Thirunarayanan Balathandayuthapani from the MariaDB Corporation wrote this improvement to the bulk inserting into InnoDB tables that is available as a preview for testing.
To achieve this, if the table is empty then InnoDB will pre-sort the records for each index, and build the indexes one page at a time. If the transaction does bulk insert operation then InnoDB should create buffer of size innodb_sort_buffer_size for each index.
If the buffer ran out of memory then InnoDB will create a temporary file for storing the data.
Universally unique identifiers (UUIDs) have a common place in computing already. A 128-bit value with a text representational value and the prescription of a number of version types to ensure a uniqueness makes it an ideal data type.
After many years of the UUID datatype existing only as a feature request in MDEV-4958, slowly accumulating votes and watchers, we are pleased to announce a preview of the UUID data type. Like the INET6 data type, this uses the datatype plugin API from MariaDB 10.5.
What does the UUID data type look like?
The Docker Library official MariaDB image is now maintained by the MariaDB Foundation, and has been for the last six months. If you didn’t notice, we’ll take that as a compliment, as the previous maintainers of Docker Library from Infosiftr were doing a good job already. Infosiftr still provide valuable quality assurance on the releases before they get to you.
What we have done, with assistance from you, our community, is:
- Continued the parting contribution by Infosiftr MARIADB_* environment names and added MARIADB_INITDB_SKIP_TZINFO for consistency.
- Allowed the timezone to be changed.
The Call for Papers for MariaDB Server Fest 2021 is open until the end of Sunday 22 August 2021. We’d like you to put in a submission.
MariaDB Server 10.6 hit Stable recently and the Server Engineering Team is quite proud of some of the innovation there. During the MariaDB Server Fest and we’ll be listening to some those.
The innovation that we’d like to hear from is yours. Users of MariaDB everywhere are applying innovation in the way they use MariaDB all the time. Your innovation may include new technologies integrated with MariaDB, new topographies, or new architectures, and presenting on how you have used these to solve the real problems would be ideal for our Server Fest.
OSU Open Source Labs have supported MariaDB for many years in hosting the mirror from which we distribute our releases for which we are most grateful. We were asked if we could reduce the size as our mirror usage had grown to 1TB, rather high compared to other projects.
To accommodate this request we removed all of the end of life releases, 5.5, 10.0 and 10.1 from the mirrors halving the used space.
It turns out there were some continuous integration systems still using these repositories.
MariaDB Foundation needs help from a Debian/Ubuntu packaging expert to continue to provide high value MariaDB Server packaging.
MariaDB Server is packaged in Debian and Ubuntu distributions, and by MariaDB Foundation as a upstream repository. A significant effort occurred to make this possible and stable. MariaDB Foundation wants to continue to innovate in the packaging to provide the best out-of-the-box experience for our users. To ensure this innovation remains stable and considered for the wide range of Debian/Ubuntu users we require a person/company/collective, with a very high quality of packaging and communication skills, to work within the MariaDB community ecosystem to deliver this outcome.
FOSDEM 2021 was amazing. MariaDB had a developer room and Foundation members contributed talks to a number of other developer rooms. We were listening for ways in which MariaDB server could be improved during all these talks, regardless of which room our MariaDB Foundation staff were in.
MariaDB server developers present provided information related to recently fixed/improved items and things that are planned to be fixed.
Our interactions with the community of users present, many of which we know, gave us an opportunity to have a dialog about some of the parts of MariaDB that they would like improved.
In the name of the MariaDB Foundation, I would like to thank Tencent for their significant contributions to the MariaDB Server in 2020. The permission to, and encouragement of, Tencent staff to contribute towards MariaDB shows a superior and practical understanding of the value proposition of open source in delivering value to everyone at the same time as reducing software maintenance costs.
Tencent has a cloud native database kernel R&D team, focusing on database kernel optimisation and architecture evolution. The team is experienced (over ten years of database R&D experience) and serves hundreds of thousands of enterprise users.