MySQL command for finding all MyISAM databases

Today most popular storage engine in latests MySQL databases is InnoDB. But if you have older databases, before the times when InnoDB becomes the king, you must somehow convert your data. You can easy find which tables are using an older storage engine using: SELECT TABLE_SCHEMA as DbName ,TABLE_NAME as TableName ,ENGINE as Engine FROM […]

ZFS ARC memory size

On large zpools ZFS ARC memory occupies whole free ram on the machine and it starts swapping. It looks like that something is wrong and it needs some tuning.  Good results are archived after founding ZFS sysctl tunable vfs.zfs.arc_free_target to define how much memory should be left free from ZFS ARC for other processes. It counts in 4096 […]

Testing the Gutenberg Editor

The goal of this new editor is to make adding rich content to WordPress simple and enjoyable. This whole post is composed of pieces of content—somewhat similar to LEGO bricks—that you can move around and interact with. Move your cursor around and you’ll notice the different blocks light up with outlines and arrows. Press the […]

Invalid argument ‘-std=c99’ on FreeBSD 11.[1-2] machines with latest clang

In case someone else encounters the same issue, it turns out that net-snmp-config –cflags is responsible for the -std=c99 flag. Disabling SNMP support with –without-net-snmp can be used as a workaround for now.

How to serve multiple search domains from Cisco IOS DHCP server?

Source – https://www.perkin.org.uk/ The expected [code language=“plain“]ip dhcp pool host.net.example.com option 119 ascii net.example.com,example.com[/code] doesn’t work. So you need to encode search domains in hex using following example script written in Python: [code language=“python“]#!/usr/bin/env python import syshexlist = []for domain in sys.argv[1:]: for part in domain.split(„.“): hexlist.append(„%02x“ % len(part)) for c in part: hexlist.append(c.encode(„hex“)) hexlist.append(„00“)print […]

Be careful with isc-bind 9.13.1

Removed Features named can no longer use the EDNS CLIENT-SUBNET option for view selection. In its existing form, the authoritative ECS feature was not fully RFC-compliant, and could not realistically have been deployed in production for an authoritative server; its only practical use was for testing and experimentation. In the interest of code simplification, this […]

How to grow zfs on FreeBSD running inside VMWare

Live ZFS resizing inside VMWare should be possible, but there are several steps: – First you should resize your virtual disk in VMWare configuration. Recomendation is all virtual disks to be similar size for best performance in VMWare.– Ideally VMWare should notify guest OS that resize happened. You should be able to see that with […]

Problem with transmission and IPv6

The problem with net-p2p/transmission-daemon and IPv6 is that transmission developers are … not willing to implement such functionality as visible from: https://trac.transmissionbt.com/ticket/4197 So the user who need to use IPv6 but NOT use IPv6 with transmission are left alone. So you can use this quick patch: cd /usr/ports/net-p2p/transmission-daemon ; make extract ; cd work/transmission-2.93/libtransmission/ ; […]