-
How to monitor MySQL / MariaDB query progressThe progress indicator of MySQL or MariaDB long-running commands and queries is extremely extremely and frustratingly coarse. In an index update I’m running now it was stuck in the same state for more than three hours. Thankfully, the pmonitor tool allows us to precisely monitor the progress of many commands. Here’s an example of its application on MariaDB.
Source: blog dds: 2019.11.03 - How to monitor MySQL / MariaDB query progress -
It is already history, and you can read my review there.
But if you like to try it yourself, you can order the C/64 Replica below. PS: if you wait some time, I predict it will ha a sale price of 40% of more, in a couple of months…versus the current 104€ retail price.
Read More -
Alexa EaSy :-)
Alexa Easy free you from your daunting social tasks. Let Alexa Easy take a pause (break up) with your partner or organize a funding event with guys you did not call in the last ten years, and regain credibility.
Personal life mixed up with job responsabilities? Let Alexa Easy fire your best friends, with a nice hug.
Read More -
Suppose you are developing a boring Jenkins pipline (like Jenkinsfile-s) with no time at all.
You are forced to commit and then run the jenkins pipeline. Jenkins download the code from your LOCAL repository.
To avoid commit& push roundtrip you are using the simple git daemon command to expose your local repository to jenkins. So jenkins see every commit you has just done.
And you end up doing a lot of commits, full of trial and errors: you would like to “squash” them before pushing your work to your remote repository, to avoid co-worker laugh your wasted time(!)
Git can do that, but I have an hard time to find the easier way of doing it, even reading git books!
So let me explain to you:
Read More -
Some co-workers started using Apache Kafka con a bunch of our Customers.
Apache Kafka is a community distributed event streaming platform capable of handling trillions of events a day. Initially conceived as a messaging queue, Kafka is based on an abstraction of a distributed commit log[*].
To get this goal, Apache Kafka needs a complex servers setup, even more complex if you want the certification for the producing company (Confluent). Now, if you are planning to use Kafka like a simple JavaMessaeSystem (JMS) implementation, think twice before going on this route.PostgreSQL 12 offers a fair (and open source) partition implementation, whereas if money are not a problem, Oracle 12c can happy scale on billions of record before running into troubles (and ExaData can scale even more).
PostgreSQL and Oracle offer optimizations for partitioned data, called “Partition Pruning” in PostreSQL teminology:
With partition pruning enabled, the planner will examine the definition of each partition and prove that the partition need not be scanned because it could not contain any rows meeting the query's WHERE clause. When the planner can prove this, it excludes (prunes) the partition from the query plan.
This feature is quite brand new (popped in PostreSQL 11) but it is essential to a successful partition strategy. Before these feature, partitioning was a black magic art. Now it is simpler to manage.
Read More -
In the last weekend I needed to restore my RasperryPi service box. It is a raspberrypi 2 which mostly make backups of my blogs.
Its microSD card gets corrupted, forcing me a full reinstall. I decided to try to make everything via Ansible.
I have already a strong experience with Saltstack, another software used to remotely manage and control huge pool of hosts. Saltstack is an agent-based solution which needs some “setup” steps, which would be an overkill for configuring a single small pc. It has a lot of concept on its own.
Read More -
My company gave me access to a bunch of Skillport course. Courses was on Kafka and Docker and was rather old (2015). But the very bad thing was the absolute shabby approach of the course. For instance to explain the use of Docker Label metadata (1 concept+ 1 command line example) Skillport proposed a 23 minute-video splitted in 5 section. We are talking about a two-line concept. It is impossible to study fast in such way.
Read More -
I think constants are evil (just joking but….I will explain why).
I am tired of seeing a lot of Java classes filled with the same constants repeated over and over again, instead of collecting them in a common file, which in C Language was called include files (ooooah!).
Read More -
Use docker in docker to drive docker from a container Working under windows, sometimes docker slow down. Sometimes you need to access to the MobyVM. With this line:
docker run --rm -ti -v "/var/run/docker.sock:/var/run/docker.sock" -v /:/host docker sh
you run a container which will removed upon exit. This container can access to docker daemon (via the docker in docker image) and has also access to MobyVM under the /host mount point. Keep in mind this container has total access to your windows C: disk too, so be careful! Find the total memory % used by your containers:
Read More -
I have done a quick peek of the Rust Programming language: it is very popular on Internet, it rivals with Go on the popularity score.
Anyway, I find it too much “Haskell-like”, with heavy rules and concept.
-
Some time ago I mentioned the Pyc64 project, a “differently emulated” C/64.
There’s a much more ambitious project that’s going under pressure, it’s called Commander X 16.
Commander X 16 has been started by David Murray and three other guys.David’s desire was to create an 8-bit computer similar to the C/64 but a little more comfortable to use: for example with 80 columns, but not with too much computing power, so as not to distort its “retro” nature.
Read More -
From: ESP32/ESP8266 Wi-Fi Attacks | Hacker News
This repository demonstrates 3 Wi-Fi attacks against the popular ESP32/8266 IoT devices:
- Zero PMK Installation (CVE-2019-12587) - Hijacking ESP32/ESP8266 clients connected to enterprise networks;
- ESP32/ESP8266 EAP client crash (CVE-2019-12586) - Crashing ESP devices connected to enterprise networks;
- ESP8266 Beacon Frame Crash (CVE-2019-12588) - Crashing ESP8266 Wi-Fi devices.
-
8 Bit computers: from 1977 to 1985
Jun 27, 2019 · 1 min read · -
We have a surprise for you today: Raspberry Pi 4 is now on sale, starting at $35!
Source: Raspberry Pi 4 on sale now from $35 - Raspberry PiHere are the highlights:
- A 1.5GHz quad-core 64-bit ARM Cortex-A72 CPU (~3× performance)
- 1GB, 2GB, or 4GB of LPDDR4 SDRAM
- Full-throughput Gigabit Ethernet
- Dual-band 802.11ac wireless networking
- Bluetooth 5.0
- Two USB 3.0 and two USB 2.0 ports
- Dual monitor support, at resolutions up to 4K
- VideoCore VI graphics, supporting OpenGL ES 3.x
- 4Kp60 hardware decode of HEVC video
- Complete compatibility with earlier Raspberry Pi products
Read More
