RSS Parrot

MySQL: information_schema.tables performance regression

https://blog.koehntopp.info/2024/10/28/mysql-information-schema-table-performance-regression.html

Published: October 28, 2024 05:06

In IRC libera:#mysql somebody asked about the performance of SHOW TABLES LIKE 'name' in MySQL 8.0, which was slow for them, but fast in 5.7. They pointed to a forum article from 2022 that had a similar problem with a select-statement on I_S.TABLES. Both…

Abnormal

https://blog.koehntopp.info/2024/10/21/abnormal.html

Published: October 21, 2024 04:05

Deloitte Media Consumer Survey 2024 Mediennutzung 2021 vs. 2024: Auch 2021 hat Deloitte im Rahmen der Media Consumer Survey 2.000 Konsument:innen zur TV- und Videonutzung befragt. Was hat sich seitdem verändert? 2021 Immer mehr Zuschauer wenden…

Immich

https://blog.koehntopp.info/2024/10/14/immich.html

Published: October 14, 2024 04:05

Immich is a web application for self-hosting that emulates the Google Photos interface on the web, and that has Android and iOS Cellphone applications for automatic upload and photo management. It also features metadata storage, machine learning for face…

Cloud Cost vs. On-Premises Cost

https://blog.koehntopp.info/2024/09/30/cloud-cost-vs-on-premises-cost.html

Published: September 30, 2024 04:05

Ich wurde gefragt: Hast Du eine Idee, wie ich seriös die Kosten für Cloud, reguläres und selbst Hosting vergleichen kann? Seriös nicht, weil das ein Problem mit mehreren Schichten ist und keine dieser Schichten irgendwie schön ist. …

zigbee2mqtt in rootless podman

https://blog.koehntopp.info/2024/09/03/zigbee2mqtt-in-rootless-podman.html

Published: September 3, 2024 04:05

I have a Zigbee Controller from Dresden Electronics, a Conbee II. On a previous machine, I had been running this in a docker container using zigbee2mqtt. In parallel, docker-compose also maintained a mosquitto, an influx 1.8 and a grafana plus Home…

MySQL: Upgrading old MySQL instances

https://blog.koehntopp.info/2024/07/23/mysql-upgrading-old-mysql-instances.html

Published: July 23, 2024 05:06

Dear Kris, We have a number of old MySQL instances, version 5.5 and 5.6. We want to upgrade them to a current version of MySQL. The databases are between 0.5 TB to 8 TB in size. Unfortunately, using rsync on a stopped MySQL instance is not an option…

Crowdstroke

https://blog.koehntopp.info/2024/07/22/crowdstroke.html

Published: July 22, 2024 04:05

This is the Monday after the Friday when Crowdstrike took out a good 1% of all Windows machines worldwide with a botched update. Some Takes Crowdstrike The company did release a statement with “Technical Details ”. This is a big…

Energy

https://blog.koehntopp.info/2024/07/16/energy.html

Published: July 16, 2024 04:05

Let’s talk about energy and energy use. Energy is measured in Watt, W. 1000 Watt make a Kilowatt, kW. Work is energy expended for an amount of time. 1000 Watt (a Kilowatt) used for one hour is a Kilowatt-hour, kWh. How much is a Watt? In our graphics, a…

Sonos S2 Analysis

https://blog.koehntopp.info/2024/07/12/sonos-s2-analysis.html

Published: July 12, 2024 05:06

Auf LinkedIn gibt es einen Artikel von Andrew Pennell zum Thema " What happened to the Sonos app? A technical analysis." Die neue App Am 7. Mai dieses Jahres hat Sonos die S2 App grundlegend umgestellt. Dazu gehörte jedoch nicht nur eine…

MySQL: Plugin 'mysql_native_password' is not loaded

https://blog.koehntopp.info/2024/07/04/mysql-plugin-mysql-native-password-is-not-loaded.html

Published: July 4, 2024 05:06

In libera:#mysql a user has been running MySQL in a docker container with mysql:latest. This container got automatically upgraded to MySQL 9.0.0, an innovation release. Part of the 9.0 release is the removal of the mysql_native_password plugin, which has…