pt-kill --kill-busy-commands=Query --run-time 1m --interval 1 --each-busy-time 30s --print --match-info "(select|SELECT)" --group-by=fingerprint
mysql kill select longer than
Leave a reply
Category Archives: linux
System clock synchronized: no
timedatectl | grep sync
System clock synchronized: no
sed -i 's/NTP\=/NTP=ntp.ubuntu.com/g' /etc/systemd/timesyncd.conf ; systemctl daemon-reload ; timedatectl set-ntp off ; timedatectl set-ntp on ; timedatectl | grep sync
System clock synchronized: yes
Unbound
Unbound is a free, open-source, recursive, and validating DNS caching server. It uses DNS-over-TLS and DNS-over-HTTPS to encrypt connections between clients. Compared to Bind9, Unbound is lightweight and extremely fast.
ubuntu install keydb
echo "deb https://download.keydb.dev/open-source-dist $(lsb_release -sc) main" | sudo tee /etc/apt/sources.list.d/keydb.list
wget -O /etc/apt/trusted.gpg.d/keydb.gpg https://download.keydb.dev/open-source-dist/keyring.gpg
apt update
apt install keydb
wireguard remove key
wg set wg0 peer public_key remove
wg-quick save wg0; wg-quick down wg0; wg-quick up wg0;
linux test if other user can read file
su nobody -s /bin/sh -c ‘cat /tmp/some_test’
cat: /tmp/some_test: Permission denied
curl list index elasticsearch
curl 'localhost:9200/_cat/indices?v'
elasticsearch delete index older than
bash script rotate-elasticsearch-index.sh
should to change regDate=”$yearReg\\-$monthReg\\-$dayReg” to match your index date format
curl -X PUT “localhost:9200/test_2022-08-02-test?pretty”
{
“acknowledged” : true,
“shards_acknowledged” : true,
“index” : “test_2022-08-02-test”
}
./rotate-elasticsearch-index.sh test localhost:9200 1
=== Fri Aug 12 16:35:37 EEST 2022 ===
——————————————-
INFO: Index: test_2022-08-11-110602
INFO: Found date: 2022-08-11
INFO: test_2022-08-11-110602 is less than 1 days old, doing nothing.
——————————————-
INFO: Index: test_2022-08-12-110602
INFO: Found date: 2022-08-12
INFO: testas_2022-08-12-110602 is less than 1 days old, doing nothing.
——————————————-
INFO: Index: test_2022-08-02-test
INFO: Found date: 2022-08-02
DELETE: test_2022-08-02-test is about to be deleted.
sed add text to end of line after match
sed -i '/^search_string\=/ s/$/,text_to_add/' file
sed add new line after match
sed -i 's/search_string/&\n/g' file
Dockerfile icecoder
FROM php:7.4.10-apache MAINTAINER ICEcoder <[email protected]> ENV DEBIAN_FRONTEND noninteractive RUN a2enmod rewrite RUN a2enmod ssl RUN service apache2 restart RUN apt-get update && \ apt-get install unzip -y && \ apt-get clean all && \ curl -o /icecoder.zip 'https://downloads.icecoder.net/ICEcoder-8.1.zip' && \ unzip -q /icecoder.zip -d /tmp/ && \ cp -r /tmp/ICE* /var/www/html/icecoder && \ echo "<!DOCTYPE html>\n<html>\n<head>\n<title>Welcome to your new site</title>\n</head>\n<body style=\"text-align: center; font-family: monospace\">\n<h1>Welcome!</h1>\n<p>Head to ICEcoder at <a href=\"/icecoder\">localhost:8080/icecoder</a> to create a password and start coding!</p>\n</body>\n</html>" > /var/www/html/index.php && \ chown -R www-data.www-data /var/www/html && \ chmod 755 /var/www/html && \ rm -rf /icecoder.zip /tmp/ICE*
mysql find pid file location
/usr/sbin/mysqld --print-defaults | tr " " "\n" | grep pid | tail -n 1
bash smtp auth
echo "PUT YOUR MAIL BODY HERE" | mailx -s "SUBJECT" -S smtp=smtp://yoursmtpserver.com -S smtp-auth=login -S smtp-auth-user=YOUR_USERNAME -S smtp-auth-password=YOUR_PASSWORD -S from="Sender Name
Error: Failed to download metadata for repo
cd /etc/yum.repos.d/
sed -i 's/mirrorlist/#mirrorlist/g' /etc/yum.repos.d/CentOS-*
sed -i 's|#baseurl=http://mirror.centos.org|baseurl=http://vault.centos.org|g' /etc/yum.repos.d/CentOS-*
wg-dashboard reset password
find /opt/wg-dashboard/ -iname server_config.json
Remove current user from json array:
{
“id”: 1,
“username”: “xxx”,
“password”: “xxx
}
systemctl restart wg-dashboard.service
Access http://vpn_server_ip/createuser to create new user