Gleam Lab · Blog Archive
Blog Page 7
Technical exploration and engineering notes, 655 articles in total.
AI Investigation #57: Five Major Categories of Robots - Industrial, Service, Humanoid, Mobile and Specialty Robots
Robots can be divided into five major categories based on function and form: industrial robots, service robots, humanoid robots, mobile robots, and specialty robots.
AI Investigation #56: Robotics Technology Iteration - From Hydraulic Drive to AI Collaboration
Robotics has undergone profound evolution from early hydraulic drive and analog control to modern electric drive, digital control and perception systems.
AI Investigation #55: Robotics - A Century of Evolution from Unimate to Humanoid Agents
Since the term 'Robot' was first introduced in 1921, robotics has undergone a century of evolution from science fiction to reality.
AI Investigation #54: Big Data Industry Applications and Technology Selection Trends
Big data has achieved deep integration in finance, e-commerce, internet, communications, manufacturing, healthcare, education and other industries, becoming the core engi...
AI Investigation #53: Big Data Talent Landscape - Experience Distribution, Growth Paths and Industry Trends
The talent structure in the big data industry shows characteristics of youth and rapid growth. The 25-30 age group is the main force, while 30-35 year-olds are gradually...
AI Investigation #52: Big Data Technology Landscape - Lakehouse, Data Mesh and Serverless
Big data technology is undergoing a new wave of transformation. Lakehouse architecture combines the advantages of data lakes and data warehouses.
MySQL Transaction Control: Lost Update, Locking and MVCC
Concurrent transaction problems: lost update, dirty read, non-repeatable read, phantom read, lock mechanism: shared lock, exclusive lock, MVCC.
AI Investigation #51: Big Data Technology Evolution - Obsolete Frameworks, Architectures and the Reasons Behind Them
Big data technology evolution: MapReduce replaced by Spark, Storm replaced by Flink, Pig/Hive gradually phased out.
MySQL Transaction and Lock Mechanism: ACID Properties
ACID properties: atomicity, consistency, isolation, durability, WAL mechanism.
AI Investigation #50: Big Data Evolution - Two Decades of Architectural Change from Hadoop to Flink
Two decades of big data evolution: from 2006 MapReduce batch processing to 2013 Spark in-memory computing, to 2019 Flink real-time computing.
MySQL Slow Query Analysis and Optimization Guide
Slow query log, mysqldumpslow, EXPLAIN analysis, common optimization solutions.
AI Research 49 - Big Data Survey Report: Development History from 1997 to 2025
Big data development began in 1997 when NASA proposed the concept, 2003-2006 Google published GFS, MapReduce, Bigtable three major papers leading distributed computing re...
MySQL Index and Sorting: Filesort and Index Sort
filesort sorting, index sorting, two-pass sorting, single-pass sorting, clustered index and secondary index sorting.
MySQL Index Optimization: Table Lookup, Covering Index, Leftmost Prefix and LIKE
Table lookup queries, covering index, leftmost prefix principle, LIKE queries, NULL value handling.
MySQL EXPLAIN: Index Analysis and Query Optimization
EXPLAIN command: selecttype, type, possiblekeys, key, rows, key_len, Extra.
MySQL Clustered vs Secondary Index: Structure, Principle and Performance Deep Dive
Clustered index (secondary index, primary key index), secondary index, table lookup query, covering index.
MySQL Index Principles: B+Tree, Hash, Binary Search
Index principles: B+Tree, Hash index, binary search, InnoDB adaptive hash index.
MySQL Index Types: BTree, Hash, FULLTEXT, RTree Explained
Index types: BTree, Hash, FULLTEXT, RTree, regular index, unique index, primary key index, composite index, clustered index.
MySQL Binlog: Recording Modes, Replication, Data Recovery
Binlog three recording modes: STATEMENT, ROW, MIXED, file format, write mechanism, master-slave replication.
MySQL Undo/Redo Log: Transaction Rollback and Persistence
Undo Log for rollback, Redo Log for redo, transaction atomicity, durability, MVCC.