Skip to content

Instantly share code, notes, and snippets.

View gquittet's full-sized avatar
👋
Welcome

Guillaume Quittet gquittet

👋
Welcome
36 followers · 30 following
View GitHub Profile
@gquittet
gquittet / mysql_clear_undo_table_space.md
Created March 13, 2026 10:05
Clear MySQL undo table space

Clear MySQL undo table space

Queries

Show undo table space with disk space usage.

SELECT * FROM INFORMATION_SCHEMA.FILES WHERE FILE_TYPE LIKE 'UNDO LOG';
@gquittet
gquittet / git_extract_commit_changes.md
Created January 9, 2026 13:15
Git extract commit changes to apply them to another project.

To extract the changes that are in a specific commit and apply them in another project, run

git format-patch -1 commit_sha

That will generate a .patch file for the specific commit.

Then to apply it, just run:

@gquittet
gquittet / teams_gitlab_deployment_webhook.json
Created October 23, 2025 12:12
Teams GitLab webhook
{
"summary": "{{environment}} deployment {{status}} on {{project.name}}",
"themeColor": "412888",
"title": "The {{environment}} deployment is {{status}} on {{project.name}}",
"sections": [
{
"activityTitle": "{{user.name}}",
"activitySubtitle": "{{deployment.finished_at}}",
"activityImage": "{{user.avatar_url}}",
"text": "The {{environment}} deployment is {{status}}."
@gquittet
gquittet / tuf_ax3000_qos.md
Last active June 25, 2025 22:43

Cake QOS fix on TUF AX3000 v2

Create a script in /jffs/scripts called qos-start

with this content

#!/bin/sh
sed -i 's/tc filter add dev .*/tc filter add dev $DLIF parent ffff: protocol all prio 10 u32 match u32 0 0 flowid 1:1 action mirred egress redirect dev $MIF/g' /tmp/qos
@gquittet
gquittet / mysql_bin_log_analysis.md
Last active October 21, 2025 14:02

Sum size of binlog for a specific day

ls -lha binlog* | grep "Oct 20" | awk '{print $5}' | numfmt --from=iec | awk '{ sum += $1; } END { print sum; }' | numfmt --to=iec

Convert it to readable text file

mysqlbinlog -vv --base64-output=decode-rows binlog.190611 > binlog.190611.txt
@gquittet
gquittet / IntelliJ insert current date live template.md
Created June 6, 2025 09:58
IntelliJ insert current date live template

IntelliJ insert current date live template

  1. Go to Settings -> Editor -> Live Tempalates
  2. Click on "+" icon
  3. Name the abbreviation date
  4. Add description: Insert current date using RFC 8601
  5. Write following template text: $date$ image
  6. Edit variable and write date and the following expression: date("yyyy-MM-dd'T'HH:mm:ss.SSSZ") image
@gquittet
gquittet / vps_setup.md
Last active June 11, 2025 22:35

VPS

Locale

Edit /etc/locale.conf to change LANG to en_US.UTF-8

LANG=en_US.UTF-8
@gquittet
gquittet / clean_private_registry_images.sh
Last active May 21, 2025 15:28
Docker private registry cleaning script
#!/usr/bin/env sh
install_missing_dep() {
if ! command -v "$1" > /dev/null 2>&1; then
echo "Installing $1..."
apk add "$1"
fi
}
DEPS="curl jq"
@gquittet
gquittet / NGinx Proxy Manager.md
Created February 9, 2025 18:07

NGinx Proxy Manager

  • Forward request IP: proxy_set_header X-Forwarded-For $remote_addr;
@gquittet
gquittet / docker_full_network_usage.sh
Created November 14, 2024 12:26
Small one-liner to see full network usage of running/all containers
printf "
\e[1mDocker Network Usage\e[0m
\e[3mRunning containers (I/O):\e[0m $(docker stats --format "table {{.NetIO}}" --no-stream | tail -n +2 | sed "s/kB/KB/g" | sed "s/B//g" | cut -d '/' -f1 | numfmt --from=iec | awk '{ sum += $1; } END { print sum; }' | numfmt --to=iec) / $(docker stats --format "table {{.NetIO}}" --no-stream | tail -n +2 | sed "s/kB/KB/g" | sed "s/B//g" | cut -d '/' -f2 | numfmt --from=iec | awk '{ sum += $1; } END { print sum; }' | numfmt --to=iec)
\e[3mAll containers (I/O):\e[0m $(docker stats --all --format "table {{.NetIO}}" --no-stream | tail -n +2 | sed "s/kB/KB/g" | sed "s/B//g" | cut -d '/' -f1 | numfmt --from=iec | awk '{ sum += $1; } END { print sum; }' | numfmt --to=iec) / $(docker stats --all --format "table {{.NetIO}}" --no-stream | tail -n +2 | sed "s/kB/KB/g" | sed "s/B//g" | cut -d '/' -f2 | numfmt --from=iec | awk '{ sum += $1; } END { print sum; }' | numfmt --to=iec)
"