Changeset f73f726

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

Files:

• general.ent (modified) (1 diff)
• introduction/welcome/changelog.xml (modified) (1 diff)
• server/databases/mariadb.xml (modified) (1 diff)

general.ent

@@ -2 +2 @@
 
 <!ENTITY day          "01">                   <!-- Always 2 digits -->
-<!ENTITY month        "06">                   <!-- Always 2 digits -->
+<!ENTITY month        "07">                   <!-- Always 2 digits -->
 <!ENTITY year         "2017">
 <!ENTITY copyrightdate "2001-&year;">

introduction/welcome/changelog.xml

@@ -46 +46 @@
      <para>July 1st, 2017</para>
      <itemizedlist>
+        <listitem>
+          <para>[pierre] - Update <quote>innodb_xxx</quote> variables to
+          their current default values in MariaDB configuration file,
+          and remove an obsolete variable. Report by J. Burrell and
+          akh.</para>
+        </listitem>
         <listitem>
           <para>[dj] - Install Flash Player control appliation along with

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