# For 4 GB RAM innodb_buffer_pool_size = 2048M # For 8 GB RAM innodb_buffer_pool_size = 5120M # For 12 GB RAM innodb_buffer_pool_size = 8192M # For 16 GB RAM innodb_buffer_pool_size = 12288M ... # From 16 GB simply take 3/4 of the RAM
Translations Ignore
Code Block
language
bash
title
systemctl restart mysql
Translations Ignore
Code Block
language
bash
mysql -u root -p<password> -v -e"CREATE USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '<password>'" mysql -u root -p<password> -v -e"GRANT ALL ON *.* TO 'root'@'%' WITH GRANT OPTION" mysql -u root -p<password> -v -e"FLUSH PRIVILEGES"
mysql -u root -p<password> -v -e"DROP FUNCTION IF EXISTS udpsend" mysql -u root -p<password> -v -e"CREATE FUNCTION udpsend RETURNS STRING SONAME 'jtel_udf_udpsend.so'"