nixtips.net
Incremental VALUE with MYSQL - *.nixtips.net
https://www.nixtips.net/incremental-value-with-mysql
My favorite *nix useful tips. Incremental VALUE with MYSQL. LPAD(@pos:=@pos 1,4,'0'). Fai clic qui per condividere su Twitter (Si apre in una nuova finestra). Fai clic per condividere su Facebook (Si apre in una nuova finestra). Fai clic qui per condividere su Google (Si apre in una nuova finestra). How long is too long for MySQL Connections to sleep? Mass updating Bind zone file serial numbers with sed. Incremental VALUE with MYSQL. How long is too long for MySQL Connections to sleep? Cerca con i Tags!
nixtips.net
plesk Archivi - *.nixtips.net
https://www.nixtips.net/tag/plesk
My favorite *nix useful tips. Add SPF records to all domains in Plesk. To add SPF records to every domain in Plesk, you can use this huge one-liner:. Then you’ll need to make Plesk write these changes to the zone files:. Mysql -Ns -uadmin -p`cat /etc/psa/.psa.shadow` -D psa -e 'select name from domains' awk '{print "/usr/local/psa/admin/sbin/dnsmng update " $1 }' sh. You can check your work by viewing the new entries you made:. How split a string in bash? Incremental VALUE with MYSQL. Cerca con i Tags!
nixtips.net
fabio, Autore a *.nixtips.net
https://www.nixtips.net/author/fabio
My favorite *nix useful tips. Mass updating Bind zone file serial numbers with sed. Commenti disabilitati su Mass updating Bind zone file serial numbers with sed. If you’re even reading this article, it’s expected that you at least know that a serial number is in the form YYYYMMDDNN where NN is the update number for that day. So the serial number from my post today would be 2013082100. Sed -i ‘s/20[0-9][0-9] {7 }/2013082100/g’ *.db. Incremental VALUE with MYSQL. LPAD(@pos:=@pos 1,4,'0'). You must set the...
nixtips.net
How long is “too long” for MySQL Connections to sleep? - *.nixtips.net
https://www.nixtips.net/how-long-is-too-long-for-mysql-connections-to-sleep
My favorite *nix useful tips. How long is too long for MySQL Connections to sleep? Mysqld will timeout DB Connections based on two(2) server options:. Both are 28800 seconds (8 hours) by default. You can set these options in /etc/my.cnf. If your connections are persistent (opened via mysql pconnect) you could lower these numbers to something reasonable like 600 (10 min) or even 60 (1 min). Or, if your app works just fine, you can leave the default. This is up to you. SET GLOBAL interactive timeout = 180;.
nixtips.net
*.nixtips.net - Pagina 2 di 9 - My favorite *nix useful tips
https://www.nixtips.net/page/2
My favorite *nix useful tips. Another Quick way to disable IPv6 Debian Squeeze (6) without reboot. Echo "# Disable IPv6" /etc/sysctl.conf. Echo "net.ipv6.conf.all.disable ipv6 = 1" /etc/sysctl.conf. Echo "#" /etc/sysctl.conf. Useful postfix one liners. Postfix is a very good MTA (mail transport agent), here are some quick commands that help with queue management:. Sudo mailq wc -l – give an approximation of the number of emails in the mailq in the number at the beginning of the line. Is a simple packet s...
nixtips.net
interactive_timeout Archivi - *.nixtips.net
https://www.nixtips.net/tag/interactive_timeout
My favorite *nix useful tips. Archivi Tag: interactive timeout. How long is too long for MySQL Connections to sleep? Mysqld will timeout DB Connections based on two(2) server options:. Both are 28800 seconds (8 hours) by default. You can set these options in /etc/my.cnf. You must set these as follows in my.cnf (takes effect after mysql restart):. If you do not want to restart mysql, then run these two commands:. SET GLOBAL interactive timeout = 180;. SET GLOBAL wait timeout = 180;. Cerca con i Tags!
nixtips.net
alias command linux Archivi - *.nixtips.net
https://www.nixtips.net/tag/alias-command-linux
My favorite *nix useful tips. Archivi Tag: alias command linux. Add and Remove ip alias into OpenBSD System. Set an IP Alias. To put a second IP address to the same interface, just enter on the commandline as root:. Ifconfig re0 inet alias 192.168.10.199 netmask 255.255.255.0. This sets an IP address 192.168.10.199. Check again with ifconfig:. Netmask 0xffffff00 broadcast 192.168.1.255 inet6 fe80: 240:45ff:fe28:8937%vr0 prefixlen 64 scopeid 0x2 inet 192.168.10.199. Now we see two IP addresses on. How to ...
nixtips.net
alias linux bash Archivi - *.nixtips.net
https://www.nixtips.net/tag/alias-linux-bash
My favorite *nix useful tips. Archivi Tag: alias linux bash. Add and Remove ip alias into OpenBSD System. Set an IP Alias. To put a second IP address to the same interface, just enter on the commandline as root:. Ifconfig re0 inet alias 192.168.10.199 netmask 255.255.255.0. This sets an IP address 192.168.10.199. Check again with ifconfig:. Netmask 0xffffff00 broadcast 192.168.1.255 inet6 fe80: 240:45ff:fe28:8937%vr0 prefixlen 64 scopeid 0x2 inet 192.168.10.199. Now we see two IP addresses on. How to che...
nixtips.net
wait_timeout Archivi - *.nixtips.net
https://www.nixtips.net/tag/wait_timeout
My favorite *nix useful tips. Archivi Tag: wait timeout. How long is too long for MySQL Connections to sleep? Mysqld will timeout DB Connections based on two(2) server options:. Both are 28800 seconds (8 hours) by default. You can set these options in /etc/my.cnf. If your connections are persistent (opened via mysql pconnect) you could lower these numbers to something reasonable like 600 (10 min) or even 60 (1 min). Or, if your app works just fine, you can leave the default. This is up to you.
nixtips.net
Mass updating Bind zone file serial numbers with sed - *.nixtips.net
https://www.nixtips.net/mass-updating-bind-zone-file-serial-numbers-with-sed
My favorite *nix useful tips. Mass updating Bind zone file serial numbers with sed. If you’re even reading this article, it’s expected that you at least know that a serial number is in the form YYYYMMDDNN where NN is the update number for that day. So the serial number from my post today would be 2013082100. Now here’s how you tell sed what you want done (note, this formula assumes that your previous serial numbers were post-2000):. Sed -i ‘s/20[0-9][0-9] {7 }/2013082100/g’ *.db. Cerca con i Tags!
