MariaDB server is a community developed fork of MySQL server. Started by core members of the original MySQL team, MariaDB actively works with outside developers to deliver the most featureful, stable, and sanely licensed open SQL server in the industry.
Find a file
Marko Mäkelä 2772d93caf MDEV-29445: Reimplement SET GLOBAL innodb_buffer_pool_size
We deprecate and ignore the parameter innodb_buffer_pool_chunk_size
and let the buffer pool size to be changed in arbitrary 1-megabyte
increments, all the way up to innodb_buffer_pool_size_max,
which must be specified at startup.

If innodb_buffer_pool_size_max is not specified, it will default to
twice the specified innodb_buffer_pool_size.

The buffer pool will be mapped in a contiguous memory area that
will be aligned and partitioned into extents of 8 MiB on 64-bit systems
and 2 MiB on 32-bit systems.

Within an extent, the first few innodb_page_size blocks contain
buf_block_t objects that will cover the page frames in the rest
of the extent. In this way, there is a trivial mapping between
page frames and block descriptors and we do not need any
lookup tables like buf_pool.zip_hash or buf_pool_t::chunk_t::map.

We will always allocate the same number of block descriptors for
an extent, even if we do not need all the buf_block_t in the last
extent in case the innodb_buffer_pool_size is not an integer multiple
of the of extents size.

The minimum innodb_buffer_pool_size is 256*5/4 pages. At the default
innodb_page_size=16k this corresponds to 5 MiB. However, now that the
innodb_buffer_pool_size includes the memory allocated for the block
descriptors, the minimum would be innodb_buffer_pool_size=6m.

When the buffer pool is shrunk, InnoDB will try to inform the operating
system that the underlying memory for part of the virtual address range
is no longer needed and may be zeroed out. On many POSIX-like systems this
is done by madvise(MADV_FREE) where available (Linux, FreeBSD, NetBSD,
OpenBSD, Apple macOS). On Microsoft Windows, VirtualFree(MEM_DECOMMIT)
is invoked.

Innodb_buffer_pool_resize_status: Remove. We will execute
buf_pool_t::resize() synchronously in the thread that is executing
SET GLOBAL innodb_buffer_pool_size. That operation will run until
it completes, or until a KILL statement is executed, the client
is disconnected, the buf_flush_page_cleaner() thread notices that
we are running out of memory, or the server is shut down.

opt_super_large_pages: Declare only on Solaris. Actually, this is
specific to the SPARC implementation of Solaris, but due to us not
having a Solaris development environment, we will not revise this
for other MMU and ISA.

my_large_virtual_alloc(): A new function, similar to my_large_malloc().
On Microsoft Windows, buffer pool resizing is disabled if large pages
are being used.

buf_pool_t::chunk_t::create(): Remove.

buf_pool_t::create(): Initialize all n_blocks of the buf_pool.free list.

buf_pool_t::allocate(): Renamed from buf_LRU_get_free_only().

buf_pool_t::LRU_warned: Changed to Atomic_relaxed<bool>,
only to be modified by the buf_flush_page_cleaner() thread.

buf_pool_t::LRU_shrink(): Check if buffer pool shrinking needs
to process a buffer page.

buf_pool_t::resize(): Always zero out b->page.zip.data.
Failure to do so would cause crashes or corruption in
the test innodb.innodb_buffer_pool_resize due to
duplicated allocation in the buddy system.
Before tarting to shrink the buffer pool, run one batch of
buf_flush_page_cleaner() in order to prevent LRU_warn().
Abort shrinking if the buf_flush_page_cleaner() has LRU_warned.

buf_pool_t::first_to_withdraw: The first block descriptor that is
out of the bounds of the shrunk buffer pool.

buf_pool_t::withdrawn: The list of withdrawn blocks.
If buf_pool_t::resize() is aborted, we must be able to resurrect
the withdrawn blocks in the free list.

buf_pool_t::contains_zip(): Added a parameter for the
number of least significant pointer bits to disregard,
so that we can find any pointers to within a block
that is supposed to be free.

buf_pool_t::is_shrinking(): Return the total number or blocks that
were withdrawn or are to be withdrawn.

buf_pool_t::to_withdraw(): Return the number of blocks that will need to
be withdrawn.

buf_pool_t::usable_size(): Number of usable pages, considering possible
in-progress attempt at shrinking the buffer pool.

buf_page_get_low(): Suppress a MemorySanitizer warning about
an uninitialized (typically all-zero) block->page.id().

buf_pool_t::get_info(): Replaces buf_stats_get_pool_info().

innodb_init_param(): Refactored. We must first compute
srv_page_size_shift and then determine the valid bounds of
innodb_buffer_pool_size.

buf_buddy_shrink(): Replaces buf_buddy_realloc().
Part of the work is deferred to buf_buddy_condense_free(),
which is being executed when we are not holding any
buf_pool.page_hash latch.

buf_buddy_condense_free(): Do not relocate blocks.

buf_buddy_free_low(): Do not care about buffer pool shrinking.
This will be handled by buf_buddy_shrink() and
buf_buddy_condense_free().

buf_buddy_alloc_zip(): Assert !buf_pool.contains_zip()
when we are allocating from the binary buddy system.
Previously we were asserting this on multiple recursion levels.

buf_buddy_block_free(), buf_buddy_free_low():
Assert !buf_pool.contains_zip().

buf_buddy_alloc_from(): Remove the redundant parameter j.

buf_flush_LRU_list_batch(): Add the parameter shrinking.
If we are shrinking, invoke buf_pool_t::LRU_shrink() to see
if we must keep going.

buf_do_LRU_batch(): Skip buf_free_from_unzip_LRU_list_batch()
if we are shrinking the buffer pool. In that case, we want
to minimize the page relocations and just finish as quickly
as possible.

trx_purge_attach_undo_recs(): Limit purge_sys.n_pages_handled()
in every iteration, in case the buffer pool is being shrunk
in the middle of a purge batch.
2025-02-13 08:40:43 +02:00
.github Merge 10.6 into 10.9 2023-05-19 15:11:06 +03:00
BUILD Merge branch '10.6' into 10.11 2024-04-26 08:02:49 +02:00
client Merge branch '10.6' into 10.11 2025-01-30 11:55:13 +01:00
cmake Merge branch '10.6' into 10.11 2025-01-30 11:55:13 +01:00
dbug Merge 10.6 into 10.8 2023-02-10 13:43:53 +02:00
debian Merge branch '10.6' into 10.11 2025-01-30 11:55:13 +01:00
Docs Merge 10.4 into 10.5 2022-09-26 13:34:38 +03:00
extra MDEV-29445: Reimplement SET GLOBAL innodb_buffer_pool_size 2025-02-13 08:40:43 +02:00
include MDEV-29445: Reimplement SET GLOBAL innodb_buffer_pool_size 2025-02-13 08:40:43 +02:00
libmariadb@2d56f340c4 C/C 3.3.14 2025-01-29 10:44:18 +01:00
libmysqld Merge branch '10.6' into 10.11 2025-01-30 11:55:13 +01:00
libservices Merge 10.6 into 10.11 2024-02-08 15:04:46 +02:00
man Merge branch '10.6' into 10.11 2024-07-22 15:14:50 +02:00
mysql-test MDEV-29445: Reimplement SET GLOBAL innodb_buffer_pool_size 2025-02-13 08:40:43 +02:00
mysys MDEV-29445: Reimplement SET GLOBAL innodb_buffer_pool_size 2025-02-13 08:40:43 +02:00
mysys_ssl MDEV-35838 libressl support differences in CRYPTO_set_mem_functions 2025-01-14 12:13:22 +11:00
plugin Merge branch '10.6' into 10.11 2025-01-30 11:55:13 +01:00
randgen/conf Group commit for maria engine. 2010-02-12 15:12:28 +02:00
scripts Merge 10.6 into 10.11 2025-01-08 12:51:26 +02:00
sql MDEV-29445: Reimplement SET GLOBAL innodb_buffer_pool_size 2025-02-13 08:40:43 +02:00
sql-bench Updated sql-bench to run with PostgreSQL 14.9 2023-09-09 15:14:45 +03:00
sql-common Merge branch '10.6' into 10.11 2025-01-30 11:55:13 +01:00
storage MDEV-29445: Reimplement SET GLOBAL innodb_buffer_pool_size 2025-02-13 08:40:43 +02:00
strings Merge branch '10.6' into 10.11 2025-01-30 11:55:13 +01:00
support-files Merge 10.6 into 10.11 2024-11-29 13:43:17 +02:00
tests Merge 10.6 into 10.11 2025-01-02 12:39:56 +02:00
tpool Merge 10.6 into 10.11 2025-01-08 12:51:26 +02:00
unittest Merge 10.6 into 10.11 2024-12-19 15:38:53 +02:00
vio Merge 10.6 into 10.11 2024-10-03 10:55:08 +03:00
win Merge branch '10.6' into 10.11 2025-01-30 11:55:13 +01:00
wsrep-lib@70cd967f5e galera: wsrep-lib submodule update 2024-12-17 09:53:19 +01:00
zlib Merge branch 'merge-zlib' (1.3.1) into 10.4 2024-04-26 13:50:03 +02:00
.clang-format Remove duplicate key "Language" from .clang-format 2024-04-17 16:52:37 +02:00
.gitattributes Merge branch '10.5' into 10.6 2022-02-03 17:01:31 +01:00
.gitignore Merge 10.6 into 10.11 2024-10-03 10:55:08 +03:00
.gitlab-ci.yml Merge branch '10.6' into 10.11 2024-07-22 15:14:50 +02:00
.gitmodules Merge remote-tracking branch '10.4' into 10.5 2023-03-31 21:32:41 +02:00
appveyor.yml Merge 10.5 into 10.6 2024-06-07 10:03:51 +03:00
BUILD-CMAKE Minor spelling fixes in code comments, docs and output 2018-01-12 16:49:02 +02:00
CMakeLists.txt Merge branch '10.6' into 10.11 2025-01-30 11:55:13 +01:00
config.h.cmake Merge branch '10.6' into 10.11 2024-10-29 15:24:38 +01:00
configure.cmake Merge branch '10.6' into 10.11 2024-10-29 15:24:38 +01:00
CONTRIBUTING.md Remove mention of Freenode 2021-09-22 07:15:08 +02:00
COPYING Update FSF Address 2019-05-11 21:29:06 +03:00
CREDITS Update sponsors 2024-08-12 09:32:30 +01:00
INSTALL-SOURCE Update AskMonty and Atlassian references to MariaDB 2016-03-08 15:24:01 +02:00
INSTALL-WIN-SOURCE Update AskMonty and Atlassian references to MariaDB 2016-03-08 15:24:01 +02:00
KNOWN_BUGS.txt Changed some MySQL names in messages to MariaDB 2018-12-09 20:49:05 +02:00
README.md Update README for branch choice 2024-05-29 13:49:32 +01:00
THIRDPARTY Merge branch '10.6' into 10.11 2024-02-01 18:36:14 +01:00
VERSION bump the VERSION 2025-02-04 11:18:48 -05:00

Code status:

  • Appveyor CI status ci.appveyor.com

MariaDB: The innovative open source database

MariaDB was designed as a drop-in replacement of MySQL(R) with more features, new storage engines, fewer bugs, and better performance.

MariaDB is brought to you by the MariaDB Foundation and the MariaDB Corporation. Please read the CREDITS file for details about the MariaDB Foundation, and who is developing MariaDB.

MariaDB is developed by many of the original developers of MySQL who now work for the MariaDB Corporation, the MariaDB Foundation and by many people in the community.

MySQL, which is the base of MariaDB, is a product and trademark of Oracle Corporation, Inc. For a list of developers and other contributors, see the Credits appendix. You can also run 'SHOW authors' to get a list of active contributors.

A description of the MariaDB project and a manual can be found at:

https://mariadb.org

https://mariadb.com/kb/en/

https://mariadb.com/kb/en/mariadb-vs-mysql-features/

https://mariadb.com/kb/en/mariadb-versus-mysql-compatibility/

https://mariadb.com/kb/en/new-and-old-releases/

Getting the code, building it and testing it

Refer to the following guide: https://mariadb.org/get-involved/getting-started-for-developers/get-code-build-test/ which outlines how to build the source code correctly and run the MariaDB testing framework, as well as which branch to target for your contributions.

Help

More help is available from the Maria Discuss mailing list https://lists.mariadb.org/postorius/lists/discuss.lists.mariadb.org/ and MariaDB's Zulip instance, https://mariadb.zulipchat.com/

Licensing


MariaDB is specifically available only under version 2 of the GNU General Public License (GPLv2). (I.e. Without the "any later version" clause.) This is inherited from MySQL. Please see the README file in the MySQL distribution for more information.

License information can be found in the COPYING file. Third party license information can be found in the THIRDPARTY file.


Bug Reports

Bug and/or error reports regarding MariaDB should be submitted at: https://jira.mariadb.org

For reporting security vulnerabilities see: https://mariadb.org/about/security-policy/

The code for MariaDB, including all revision history, can be found at: https://github.com/MariaDB/server