Changeset f73f726 for server/databases

Timestamp:

07/01/2017 10:28:38 AM (7 years ago)

Author:

Pierre Labastie <pieere@…>

Branches:

10.0, 10.1, 11.0, 11.1, 11.2, 11.3, 12.0, 12.1, 8.1, 8.2, 8.3, 8.4, 9.0, 9.1, basic, bdubbs/svn, elogind, kea, ken/TL2024, ken/inkscape-core-mods, ken/tuningfonts, lazarus, lxqt, perl-modules, plabs/newcss, plabs/python-mods, python3.11, qt5new, rahul/power-profiles-daemon, renodr/vulkan-addition, trunk, upgradedb, xry111/intltool, xry111/llvm18, xry111/soup3, xry111/test-20220226, xry111/xf86-video-removal

Children:

a4a3fc9

Parents:

60233054

Message:

Update "inodb_xxx" variables in MariaDB configuration (report by J Burrell and akh)

git-svn-id: svn://svn.linuxfromscratch.org/BLFS/trunk/BOOK@18904 af4574ff-66df-0310-9fd7-8a98e5e911e0

File:

• server/databases/mariadb.xml (modified) (1 diff)

server/databases/mariadb.xml

@@ -302 +302 @@
 # InnoDB tables are now used by default
 innodb_data_home_dir = /srv/mysql
-innodb_data_file_path = ibdata1:10M:autoextend
 innodb_log_group_home_dir = /srv/mysql
+# All the innodb_xxx values below are the default ones:
+innodb_data_file_path = ibdata1:12M:autoextend
 # You can set .._buffer_pool_size up to 50 - 80 %
 # of RAM but beware of setting memory usage too high
-innodb_buffer_pool_size = 16M
-innodb_additional_mem_pool_size = 2M
-# Set .._log_file_size to 25 % of buffer pool size
-innodb_log_file_size = 5M
-innodb_log_buffer_size = 8M
+innodb_buffer_pool_size = 128M<!--
+This variable has been removed in version 10.2.2:
+innodb_additional_mem_pool_size = 2M-->
+innodb_log_file_size = 48M
+innodb_log_buffer_size = 16M
 innodb_flush_log_at_trx_commit = 1
 innodb_lock_wait_timeout = 50