Le blog de Nrz
fr
Devops
Harbor multi datacenter with replicated artifacts
Homes
Home assistant on NixOS with docker and Bluetooth
Storages
Ceph on Debian
Ansible
Ansible mysqldump
Ansible password encryption
Ansible SSH key management
Enhanced Ansible output
AWS scheduled startup/shutdown
Apache
Source IP tracking
SSL authentication
Reverse proxy
mod evasive
mod authnz_ldap
Maintenance mode
htaccess
Introduction
BSD
Utiliser Ansible à distance sur des jails FreeBSD
Poudriere cross compiling
LetsEncypt with a Nginx jail
Samba 4 with ZFS (fr)
Minetest
Pkgng configuration migration
Pkgng mirrors
Ports management
OpenBSD 5.5
Poudriere
Gitlab 6 on FreeBSD
OpenBSD 5.4
Resize the filesystem
Release 9.2
Home hostap
CARP, Pfsync, GRE, IPSEC
Captive portal
Interface management
ZFS hot replace
Apache FreeBSD DragonFlyBSD cluster
OpenBSD 5.3
FreeBSD installation
Migrate from 7,8 to 9.0
Migrate from 7,8,9 to 9.1
How to install OpenBSD
Migrate from 5.1 to 5.2
OpenBSD 5.2
Ports troubleshoot (tar) (fr)
OpenBSD 5.1
Contribute to ports (fr)
Fail2Ban
How to install DragonFlyBSD
OpenOSPFD patch (fr)
Introduction
Compile a module (fr)
Compile the kernel
Dports management (fr)
Cloud
Scaleway
Feedback sur Scaleway Secret Manager
Elasticsearch
Monitor unique ES aliases
Remove index records with filter
GIT
Editer un ancien commit
Editer le premier commit
Extract a subfolder as a new repository
Remove a submodule
Import a file from another branch
Change the default branch
Create an empty branch
Soft file removal
Gitlab
Supprimer d'anciens logs de jobs Gitlab CI
Gitlab Pages as a Debian repository
Gitlab CI maven pipeline
Gitlab password reinit
Gnome
Design tricks
Java
JConsole SSH tunnel
NIO connector
Create a Debian package from dist
Kubernetes
Accéder à un endpoint sans ressources protégé par RBAC
Retrouver tous les volumes utilisés par des pods Kubernetes
Déclencher un cronjob Kubernetes manuellement
Persistent volumes
Linux
Boot with EFI and SystemD
Shrink an ext4 volume
Recover a deleted filedescriptor
Hot CPU reload
Hot ram reload
Recompile an official package
Reinstall all packages
Create a package
Package mirror
Package mirror
Migrate from Init to SystemD
Debian 6
Misc
Mattermost - supprimer d'anciens posts
Exchange with 2 domains & 1 forest
Network regexp
Monitoring
Alerte Prometheus sur un reboot/redémarrage
Trouver les métriques prometheus avec un libellé manquant
Alertmanager - Ignorer une notification
Monitor Jenkins slaves
FreeBSD vnodes
OpenBGPd (fr)
FreeBSD socket sensor
MySQL
Galera topology changes
Kill long running queries
MySQL view rights problem
MySQL replication
MySQL Master failover cluster with Hast & Heartbeat
Introduction
Network
DHCP relay
PHP script SSH commands
GRE
Obsolète dynamic records removal
IPv4 vs IPv6 on old Cisco (fr)
Netdisco
Common problems resolution
Override dhclient DNS configuration
DHCP & DDNS
Bind9
Stackwise
Convert heavy AP to lightweight
High availability DHCP
Telnet to SSHv2
Port mirroring
802.1X port
Link aggregation
NTOP
Poptop
UCARP
News
PF conference
Nix
Nix Store: Réparer un ou plusieurs fichier(s) corrompu(s)
OpenLDAP
Logs cleanup
BDB version migration
OpenLDAP
Orchestrator
Puppet
Dconf variables
Remove a file
Set user shell
Autosign certificates
Symlink creation
Postfix
Our mail blacklist
Native SPF check
Remove specific mails from queue
Postfix rewrite sender destination
Blacklist domain/address
Introduction
Relay and route mails
PostgreSQL
Generate table & sequence owner queries
Reinit a schema
Duplicate indices
Cleanup scheme
Close connection
Security
Samba4 as ActiveDirectory
PAM auth ActiveDirectory
PAM LDAP
Ubuntu auth LDAP
NPPPD
Shibboleth
Squid blacklists (fr)
Squid migration from 3.1 to 3.2
Squid on OpenBSD (fr)
FreeRADIUS 2
OpenVPN
Squid
IPTables
TabNabbing
OpenSSL
Certificates creation
Relative names from connection
Shell
Network scripts
SSH
SSH public key regeneration
Connection keepalive
Introduction
System
InfluxDB type mismatch
InfluxDB - move data to new retention
Hindsight
InfluxDB graphite tags
Print mails with LPD
Nexus on FreeBSD
OpenDKIM
Postfix replay mail in queue
Mailbox cleanup
IMAP transfer python
PostgreSQL 9.1 benchmark
Dovecot, Postfix, OpenLDAP on FreeBSD
Bacula
GeoIP autoupdate
Syslog-NG
Atempo TINA
InfluxDB tips
Jenkins build Android apps on FreeBSD
Mediawiki PCRE 8.34 fixes
Postfix SMTPS authentication
Spamassasin
Webcal
Terraform
Terraform - revenir d'un état perdu
Tools
Powerline
OptiPNG
Tmux
at
Vim
vi - delete line
VI - shortcuts
ipmitool
SVN Server
Built with
from
Grav
and
Hugo
Sharing UNIX knowledge
>
Tags
> long query
Publié le: 2017-05-29
long query
Section articles
2017-05-29 | Kill long running queries