Jul 25

Slow WiFi in Windows 10

Recently I’ve switched my Internet provider. The new one delivers Internet trough optic fiber to the last mile and the speed should be 100MBit/s. Speed tests over a cable confirm the speed is very close to 100 MBit/s. I however noticed some lags and slowness on my laptop when using WiFi which was not expected. Speedtest.netshowed this:

The results are far away from what I would expect! Again, when attached via LAN cable – everything is fine.

Continue reading

Jul 19

Compiling and installing MariaDB on Raspberry PI

For reports on my timeseries data I really needed Windowing functions like LAG(), LEAD(), ROW_NUMBER() etc. The speed and flexibility you gain using Windowing functions is incredible compared to imitating LAG() using “self-join” tricks. But these function are supported as of MySQL 8 and as of MariaDB 10.2.

For numerous of reasons I prefer to use MariaDB which is compatible drop-in replacement for MySQL.

Unfortunately there are no ready to install packages for ARM so you need to compile and install newer versions by hand.

I’ve came across many articles regarding compilation of MariaDB but these did not match my installation and were missing some important steps. So decided to share my solutions.

So let’s start!

Continue reading

Jul 15

Could not locate bootia32.efi while trying to install Windows 10

Recently a Prestigio smartbook had to be reinstalled with latest Windows 10 1803. This laptop came with 32 bit Windows but had 64bit CPU. So I [wrongly] assumed 64-bit Windows would work. That was not the case!

I’d made 64-bit Windows 10 installation USB stick using Rufus (MBR:UEFI). But when booting I’ve received an error:

[FAIL] Could not locate '/efi/boot/bootia32.efi': [14] Not Found

The reason for that seems to be the cheaper hardware – the CPU was 64-bit, but the UEFI implementation was 32-bit…

Unlike in Linux, for Windows OS there’s one very simple solution: just make 32-bit Windows installation USB stick. Works like a charm!

Jul 15

High Performance power plan is missing in newer builds of Windows 10

You may have noticed that High Performance power plan is missing some versions of Windows 10 especially when running on laptops. Only the Balanced plan is shown.

This is somehow connected to the Modern Standby. I couldn’t find any official statement from Microsoft about removing High Performance power plan.

Continue reading