MySQL - Sort by IP Address

If you have a column containing ip addresses, sort the ip addresses numerically with:

ORDER BY INET_ATON(ip_address_column)

Comments

Post a Comment

Popular posts from this blog

Debian - Install on BTRFS with Snapper Backups, GRUB-BTRFS and ZRAM

Start the Install Process  Boot the Debian install media Select Advanced Options Run through the installer until you get to "Partition Disks" Create the Partitions Select "Manual" Select the free space you are going to install Debian on Select "Create a new partition". This is the EFI partition Set the size to "512 MB" Change "Use as:" to "EFI System Partition" "Bootable flag:" should be "on" Select "Done setting up the partition" Create a 1GB, ext4 partition for /boot Set "Mount point:" to "/boot" Create another partition with the remaining free space Set "Use as:" to "btrfs journaling file system" Set "Mount point:" to "/" Select "Finish partitioning and write changes to disk" Do not create a swap partition. We are going to use ZRAM. Select "No" to continue Write the changes to disk Create the BTRFS System and Subvol...
Read more

Docker

Sum the size of dangling docker images docker images --format "{{.Size}}" --filter=dangling=true | awk '{sub(/B$/,""); print $1 }' | numfmt --from=iec | awk 'BEGIN {sum=0} {sum=sum+$1} END {printf "%.0f\n", sum}' | numfmt --to=iec
Read more

Find Which Processes are Using Swap

I was doing s ome testing on my Virtuozzo linux VPS and wanted to find what was using the swap. The short version is that processes that have not been used in a long time will be moved into swap to free up RAM. I found the following page with a one-liner to show the running processes and the amount of swap they are using (including processes with 0 kB of swap).  https://www.cyberciti.biz/faq/linux-which-process-is-using-swap/  I modified the one-liner to only show processes using swap. for file in $(grep -El "VmSwap:\s+[1-9][[:digit:]]* kB" /proc/*/status) ; do awk '/Name:|VmSwap:/{printf $2 " " $3}END{ print "" }' $file; done | sort -k2nr php-fpm 488792 kB php-fpm 485172 kB php-fpm 475640 kB php-fpm 469504 kB php-fpm 469100 kB php-fpm 462044 kB php-fpm 439604 kB php-fpm 430868 kB php-fpm 410124 kB php-fpm 389892 kB php-fpm 381132 kB php-fpm 380136 kB php-fpm 379988 kB php-fpm 379216 kB php-fpm 316296 kB mysqld 225884 kB php-fpm 92096 kB php-fpm 91...
Read more