Anzhihe | 安志合

Original link: https://chegva.com/5794.html In the past few days, the computer has been unable to assign an IP address when connected to the wifi. This happened occasionally before. Just restart the computer and it will be fine. Restarting the computer today still doesn’t work. I checked online and deleted the wifi cache. After restarting the computer, …

Mac m1 system cannot be assigned an IP address when connected to wifi Read More »

Original link: https://chegva.com/5791.html 1. View display type Linux: lspci | grep “VGA” Windows: On Windows, you can use Device Manager to check your graphics card version. Open Device Manager by following these steps: Use the shortcut keys Win + X and select “Device Manager”. Alternatively, search for “Device Manager” in the Start menu and open …

CentOS, Ubuntu, Windows NVIDIA graphics card driver installation Read More »

Original link: https://chegva.com/5781.html Image Source I just finished relocating the computer room recently, and I am busy continuing to relocate the big data Hadoop cluster. This cluster has been running online for more than five years, and two or three waves of people have been changed in the middle. There is no way to do …

Big data cluster service CDH startup and shutdown sequence Read More »

Original link: https://chegva.com/5780.html Recently, the Github warehouse push upload times LFS excess is limited: batch response: This repository is over its data quota. Account responsible for LFS bandwidth should purchase more data packs to restore access. There is a fee for this thing exceeding 1G free capacity, and it is understandable that otherwise the github …

Remove LFS from github repository Read More »

Original link: https://chegva.com/5776.html Synopsis for A Bronx Tale······ 　　In the 1960s, the Bronx district of New York where Italians gathered. Gang boss Xinny (Chazz Palminteri Chazz Palminteri ornaments) is a well-known local gang figure. At the scene of a murder, the nine-year-old boy Anu (Francis Capra) witnessed all this. For the sake of the neighborhood’s …

A Bronx Tale (1993) Read More »

Original link: https://chegva.com/5777.html A completely free checkpoint-style SQL self-study tutorial website, combined with the author’s own SQL learning practice experience, has written more than 30 checkpoints. Users can submit SQL codes online to complete the checkpoints. The goal is to help everyone master common SQL syntax from 0 to 1 . In addition, the website …

Mother of SQL – Free self-study network of SQL Read More »

Original link: https://chegva.com/5767.html Recently, when the computer room was moved, the Mysql cluster changed to a new environment, and the master-slave inconsistency occurred. Specifically, the 1236 error was reported. The cluster architecture adopts dual-master + keepalived high availability. Several recovery methods have been tested and recorded. Last_IO_Error: Got fatal error 1236 from master when reading …

Mysql master-slave, dual master and master-slave synchronization 1236 error Read More »

Original link: https://chegva.com/5761.html Recently, I helped to install the dual system Win10 + Ubuntu to meet the needs of linux learning and daily use. When installing win, the image was restored to more than 70%, and then the blue screen appeared. After two or three times, it must appear, that is, there is a problem …

Win10 + Ubuntu20.04 dual system installation Read More »

Original link: https://chegva.com/5750.html 1. What is a monitor? watcher is a plug-in for elasticsearch that can provide alerts and notifications based on changes in data, by using Watcher to monitor changes or exceptions in data and perform necessary response operations. Since version 5.0, watcher has become a part of x-pack, which means that after x-pack …

ES monitor Watcher use Read More »

Original link: https://chegva.com/5744.html Since the DBA brother ran away, the work of database middleware and big data has fallen on my head. The reason for the leadership is that I have worked in operation and maintenance development for a period of time before, and I am familiar with SQL! I can’t refute this reason, after …

Mysql update statement uses subquery Read More »

Original link: https://chegva.com/5741.html Screen common commands: screen Hold a session open on a remote server. Manage multiple windows with a single SSH connection. See also `tmux` and `zellij`. More information: <https://manned.org/screen>. – Start a new screen session: screen – Start a new named screen session: screen -S session_name – Start a new daemon and log …

Linux terminal command artifact Screen use Read More »

Original link: https://chegva.com/5739.html The Android emulator used on the computer before was Netease MuMu, and the experience was good, but it did not support the Mac M1 chip, which made it unusable after changing the computer. I found an Android emulator android-emulator-m1-preview that can be used on the M 1 chip on the Internet. Except …

MacBook M1 using Android emulator Read More »

Original link: https://chegva.com/5736.html xtrabackup backup flowchart innobackupex – Percona-XtraBackup-2.4.9-Translation Xtrabackup backup MySQL common backup tool process analysis MySQL innobackupex full backup recovery – nmap – 博客园 mysql innobackupex xtrabackup innobackupex backup recovery + incremental backup and recovery MySQL’s XtraBackup full incremental hot backup practice Fault Analysis | Blood Lesson – The backup wait caused by …

Mysql innobackupex physical backup and mysqldump logical backup use Read More »