Modifying the datadir of MySQL on macOS can indeed fail due to issues related to permissions, configuration file locations, and more. Below is a detailed set of steps and considerations that take into account the characteristics of macOS, which I hope will help you succeed. This case primarily targets MySQL installed via Homebrew (a very … Read more
SQL: create table School # Create table( `SchoolId` char(5) NOT NULL comment 'Primary key, school number', # Manually input, can also be designed to auto-increment, 5 characters, numeric, or a combination of numeric and characters, with code restrictions when saving data in text. `SchoolName` nvarchar(500) NOT NULL DEFAULT '' comment 'School name', `SchoolTelNo` varchar(8) NULL … Read more
1. Introduction In application development, data management, such as data storage and retrieval, is a fundamental requirement. Regardless of the type or scale of the application, data storage management is essential. In most business applications, the two most commonly used types of databases are NoSQL databases, such as Redis, and relational databases, such as MySQL. … Read more
Dr. An is here! We are pleased to introduce “Dr. An”, who is backed by a top-notch technical expert team from Ampere Computing, dedicated to sharing cutting-edge technical analyses, application insights, and trend observations in the cloud-native field with you. Let’s welcome “Dr. An” to shine on stage and bring the first exciting sharing! 【Follow】 … Read more
Steps This is the tool I use to view data in the EMQ server, MQTTX, which is quite handy. First, we need these libraries. It’s quite simple to download them, just search for installation on Baidu, and after installation, import them. Taking the topic “weight_pub” as an example, we first retrieve MQTT data. The function … Read more
Whether for databases or applications, when issues arise, knowing the exception stack information can greatly assist in identifying the root cause and fundamentally resolving the problem. The stack information from MySQL can similarly aid in problem-solving. This article from the technical community, 《MySQL Fault Reporting Core Dump Collection Process》 introduces the process of collecting core … Read more
▼Click the image below to search for the secret code【001】, and immediately receive154 pages of Linux study notes. What Is the Difference Between CPU Utilization and CPU Load? When mentioning CPU utilization, one must understand the time slice. What is a CPU time slice? The operating systems we currently use, such as Windows, Linux, and … Read more
With little knowledge of hardware, let’s learn from Master Yang’s article “Do You Understand ARM CPU Architecture?!”. Introduction Recently, there was a requirement to install MySQL 8.0 on an ARM architecture; I’ve heard of ARM CPUs, but have never deployed them in practice; and what exactly is this ARM CPU architecture? I only have a … Read more
This article is reprinted from the Jishu Community. Jishu Column: Arm Server Author:BoltLiu This is a test report on enabling MySQL PGO. Correctly enabling MySQL PGO leads to significant performance improvements, with write performance increasing by about 13% and read performance increasing by about 20%. Environment Setup The testing environment is set up on an … Read more
Training Background In recent years, the Linux operating system has become the main alternative to the Windows platform, and its rapid development has attracted widespread attention. Major IT companies around the world, such as IBM, ORACLE, and CA, have launched products based on the Linux environment, hoping to break Microsoft’s monopoly and gain more development … Read more