Skip to content

Instantly share code, notes, and snippets.

View goyuninfo's full-sized avatar

goyun.info goyuninfo

View GitHub Profile
@goyuninfo
goyuninfo / gist:a02ccdc225d4c6ab09c4ccd2cfed1647
Last active January 30, 2021 23:45
IT Swiss Tools Awesome List
git
vim
jenkins
Blogger
Wordpress
@goyuninfo
goyuninfo / Install-cron.md
Created January 30, 2021 21:41
Distribution Install Systemd Start on Boot Alt Start on Boot
CentOS 8+ dnf install cronie systemctl enable crond chkconfig crond on
Fedora 22+ dnf install cronie cronie-anacron systemctl enable crond chkconfig crond on
Debian sudo apt install cron systemctl enable crond update-rc.d cron defaults
@goyuninfo
goyuninfo / locate MySQL dead lock.sql
Last active January 8, 2021 19:18
How to get Active Transactions and Locks from MySQL https://jobs.goyun.info/2020/07/how-to-get-active-transactions-and.html
SELECT
r.trx_wait_started AS wait_started,
TIMEDIFF(NOW(), r.trx_wait_started) AS wait_age,
rl.lock_table AS locked_table,
rl.lock_index AS locked_index,
rl.lock_type AS locked_type,
r.trx_id AS waiting_trx_id,
r.trx_mysql_thread_id AS waiting_pid,
r.trx_query AS waiting_query,
rl.lock_id AS waiting_lock_id,
@goyuninfo
goyuninfo / Python example code of heap data structure.py
Created January 2, 2021 00:34
# Python example code of heap data structure
# importing "heapq" to implement heap queue
import heapq
# initializing list
li = [5, 6, 9, 2, 8]
# using heapify to convert list into heap
heapq.heapify(li)
@goyuninfo
goyuninfo / Check If File Is Empty OR Not by Bash Script.sh
Last active December 23, 2020 19:00
https://jobs.goyun.info/2020/12/check-if-file-is-empty-or-not-by-bash.html
#!/bin/bash
_file="$1"
[ $# -eq 0 ] && { echo "Usage: $0 filename"; exit 1; }
[ ! -f "$_file" ] && { echo "Error: $0 file not found."; exit 2; }
if [ -s "$_file" ]
then
echo "$_file has some data."
# do something as file has data
else
@goyuninfo
goyuninfo / How to extract filename and extension in bash shell script.sh
Last active December 23, 2020 01:50
https://tech.goyun.info/2020/12/how-to-extract-filename-and-extension.html
#!/bin/bash
# get file name only without path
file_name=$(basename $BASH_SOURCE)
# get extension
file_extension="${file_name##*.}"
# get file name without extension
file="${file_name%.*}"
# print them to verify
echo "Full input file : $BASH_SOURCE"
echo "Filename only : $file_name"
@goyuninfo
goyuninfo / MySQL audit: Only Log Successfully Executed Statements for a specific table.json
Created December 19, 2020 22:29
https://tech.goyun.info/2020/12/mysql-audit-only-log-successfully.html
{
"filter": {
"id": "main",
"class": [
{
"name": "table_access_data",
"event": {
"name": [
"insert",
"update",
@goyuninfo
goyuninfo / gist:1ac441f40e0cea3fdc02a6774223ef62
Created December 15, 2020 19:23
MySQL Audit Filtering Example: Only Log Successfully Executed INSERT Statements For some Specific Database/Tables Combinations
{
"filter":
{
"id": "main",
"class":
{
"name": "table_access",
"event":
{
"name": [ "insert" ],
@goyuninfo
goyuninfo / mysql-group-by-hour-example.sql
Created December 8, 2020 16:16
SELECT t.date, count(*)
FROM table1 t
GROUP BY hour( t.date ) , day( t.date )
@goyuninfo
goyuninfo / Install and Update Python to 3.9 in Ubuntu.sh
Last active November 24, 2020 14:19
https://jobs.goyun.info/2020/11/install-and-update-python-to-39-in.html
apt update
apt install software-properties-common
add-apt-repository ppa:deadsnakes/ppa
apt update
apt install python3.9 python3.9-venv python3.9-dev