Skip to content

blog.Gudynas.lt

About everything

Menu
  • Home
  • AS215899
  • OpenWebRX SDR
  • ADS-B Tracker
  • About sdr.Gudynas.lt
  • Contacts
Menu

Directadmin increasing mysql limits script

Posted on 2021-12-052021-12-11 by Justas

#!/bin/sh

#Limits (setting these options to 0 removes the limit)
MAX_QUERIES_PER_HOUR=30000
MAX_UPDATES_PER_HOUR=20000
MAX_CONNECTIONS_PER_HOUR=5000
MAX_USER_CONNECTIONS=100

#We get DirectAdmin MySQL root user and password here
DA_MYSQL=/usr/local/directadmin/conf/mysql.conf
MYSQLUSER=`grep "^user=" ${DA_MYSQL} | cut -d= -f2`
MYSQLPASSWORD=`grep "^passwd=" ${DA_MYSQL} | cut -d= -f2`

mysql -e "use mysql; UPDATE mysql.user SET max_questions=${MAX_QUERIES_PER_HOUR}, max_updates=${MAX_UPDATES_PER_HOUR}, max_connections=${MAX_CONNECTIONS_PER_HOUR}, max_user_connections=${MAX_USER_CONNECTIONS} WHERE user!='da_admin' AND user!='root' AND user!='da_roundcube' AND user!='da_atmail'; FLUSH PRIVILEGES;" --user=${MYSQLUSER} --password=${MYSQLPASSWORD}

echo "Limits have been set."
exit 0;

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *


This site uses Akismet to reduce spam. Learn how your comment data is processed.

Categories

  • sdr.Gudynas.lt Project (6)
  • Linux (42)
  • Windows (1)
  • Uncategorized (2)

Archives

  • August 2025 (1)
  • March 2025 (1)
  • November 2024 (2)
  • January 2024 (2)
  • December 2023 (1)
  • October 2023 (1)
  • September 2023 (2)
  • May 2023 (1)
  • April 2023 (1)
  • March 2023 (1)
  • August 2022 (1)
  • July 2022 (1)
  • March 2022 (1)
  • December 2021 (5)
  • November 2021 (5)
  • September 2021 (4)
  • August 2021 (1)
  • July 2021 (1)
  • May 2021 (1)
  • April 2021 (1)
  • January 2021 (1)
  • October 2020 (2)
  • August 2020 (1)
  • May 2020 (1)
  • November 2019 (2)
  • September 2018 (10)

Recent Posts

  • SDR.Gudynas.lt upgrades, ADS-B receiver installed
  • Ready for Winter, Network upgrades, and What was done in 2024 for sdr.gudynas.lt project
  • 2023-10-15 Some SSTV decoding on 10/11m SDR
  • Enabling auto-adjust waterfall colors by default OpenWebRX
  • Enabled Background decoding and HF propagation

Recent Comments

  • Bruce MAYO on About sdr.Gudynas.lt OpenWebRX project
  • BT on About sdr.Gudynas.lt OpenWebRX project
  • Bernd on About sdr.Gudynas.lt OpenWebRX project
December 2021
M T W T F S S
 12345
6789101112
13141516171819
20212223242526
2728293031  
« Nov   Mar »
© 2025 blog.Gudynas.lt | Powered by Minimalist Blog WordPress Theme