mariadb max_allowed_packet problem

vacancy

• August 04, 2021 05:25

Hello there I set the max_allowed_packet value to 4GB for mariadb, but when mariadb is restarted, this value automatically becomes 1GB. Tweak settings > Allow cPanel & WHM to determine the best value for your MySQL max_allowed_packet configuration? setting is set to off. In my.cnf content, max_allowed_packet value still shows 4G, but on mariadb cli this setting returns 1G.

• 

  HostNoc

  • August 04, 2021 12:37

  Hello, Kindly change in the my.ini or ~/.my.cnf file by including the single line under [mysqld] or [client] section in your file: max_allowed_packet=4G then restart the MySQL service and you are done. Let us know if this works for you.

  0
• 

  vacancy

  • August 04, 2021 12:53

  It didn't work. Any value above 1G is not accepted, it automatically changes to 1G = 1073741824 MariaDB [(none)]> SHOW VARIABLES LIKE 'max_allowed_packet'; +--------------------+------------+ | Variable_name | Value | +--------------------+------------+ | max_allowed_packet | 1073741824 | +--------------------+------------+ 1 row in set (0.001 sec)
  

  0
• 

  cPRex Jurassic Moderator

  • August 04, 2021 14:50

  Is it possible you have a secondary my.cnf in /usr that is interfering with this?

  0
• 

  vacancy

  • August 04, 2021 19:43

  Hello I couldn't find a second my.cnf file. [root@78-135-*-* ~]# find . / -name my.cnf /etc/my.cnf
  

  0
• 

  cPRex Jurassic Moderator

  • August 04, 2021 20:19

  I did some more research on this and found that the max value is 1G for MariaDB

  0
• 

  vacancy

  • August 04, 2021 20:21

  Thank you cprex, this information was helpful.

  0
• 

  cPRex Jurassic Moderator

  • August 04, 2021 20:23

  I did a bunch of testing and no matter what I put the value kept capping out at 1G, so I figured I should go to the source. I feel like this value used to be larger, but docs for MySQL 5.6 also show 1G max: MySQL :: MySQL 5.6 Reference Manual :: 5.1.7 Server System Variables

  0
• 

  vacancy

  • August 04, 2021 20:29

  I did a bunch of testing and no matter what I put the value kept capping out at 1G, so I figured I should go to the source. I feel like this value used to be larger, but docs for MySQL 5.6 also show 1G max:

  0

Please sign in to leave a comment.