Author: Zhang Zhengjun Working at Central European Fund, a fan of Zhishutang, a database enthusiast, familiar with various databases such as RDBMS, NoSQL, NewSQL, etc. After finishing O’Reilly’s “High Performance MySQL” and Teacher Jiang’s “MySQL Technical Insider”, along with 2-3 years of practical experience, one can essentially become a DBA capable of handling problems independently.However, … Read more
In the daily use of Linux systems, file searching is one of the high-frequency operations.<span><span>locate</span></span> command has become an “efficiency accelerator” for many developers and administrators due to its extremely fast search speed. Its core advantage lies in bypassing the cumbersome process of real-time traversing the file system, instead achieving “sub-second response” through a pre-built … Read more
1. China Patent Publication Announcement Website: http://epub.sipo.gov.cn/ Introduction: The website includes all Chinese patent information published since September 10, 1985. Its search function allows queries based on four types of published announcement data: invention publication, invention authorization, utility model, and design. The data mainly includes Chinese patent publication announcement information, as well as substantive examination … Read more
1. Check If MySQL Is Case-Sensitive show variables like '%case_table%'; lower_case_table_names=1 (indicates it is case-insensitive) lower_case_table_names=0 (as shown in the image, 0 indicates case-sensitive) 2. Change lower_case_table_names Value to 1 (1) Since I am using the Baota panel, I can directly modify the configuration information Add lower_case_table_names=1 under [mysqld] (as shown below) (2) Modify /etc/my.cnf … Read more
Following Chapter 2 Oracle Database In-Memory Architecture (IM-2.2) This article is the second part of the IM architecture CPU Architecture: SIMD Vector Processing For data that needs to be scanned in the IM column store, the database uses SIMD (Single Instruction, Multiple Data) vector processing. The IM column store maximizes the number of column entries … Read more
Patent Review-SIMD Series–Vectorization Engine 1. Patent Content Alibaba‘s patent:Method and Device for Vectorized Data Processing, the main idea is: for query scenarios involving row-oriented tables or a mix of row and column storage, it is necessary to manually convert row-oriented tables into column-oriented tables before performing vectorized processing, which is costly. Alibaba provides a method … Read more
1. Background PolarDB Distributed Edition (PolarDB for Xscale, abbreviated as: PolarDB-X) is a cloud-native distributed database with important features such as online transaction and analytical processing (HTAP), separation of computing and storage, and global secondary indexing. In terms of HTAP, PolarDB Distributed Edition has explored and practiced many aspects of vectorization for the AP engine, … Read more
This article is based on the paper “Interleaved Multi-Vectorizing,” which has been accepted by VLDB 2020. The content below is personally interpreted by the first author Zhuhe Fang(Zhihu ID: 方竹河). For more details, please refer to the paper and video links at the end. VLDB (Very Large Database) conference started in 1975 and is one … Read more
Partition-based SIMD processing and its application in columnar database systems The Single Instruction Multiple Data (SIMD) paradigm is considered the core principle for optimizing query processing in columnar database systems. So far, only LOAD/STORE instructions are deemed efficient enough to achieve the expected acceleration, and it is believed that GATHER/SCATTER operations should be avoided as … Read more
Introduction In the field of industrial automation, the touch screen host computer plays a crucial role as an important interface for human-machine interaction. While traditional PLC-mounted touch screens are powerful, they have certain limitations in flexibility and scalability. To meet the demand for efficient and flexible control in modern industrial automation, this article will introduce … Read more