MySQL
An open-source relational database management system that can be integrated with Dify to support data reading and writing in AI applications.
Core Facts
Debezium is one of the most well-known CDC platforms, supporting real-time streaming of database changes to message queues such as Kafka
Dify deployed via Docker can communicate with MySQL 8 on a Windows host machine and also with databases in a VMware virtual machine.
MySQL's InnoDB storage engine uses the B+ tree as the default index data structure.
Timeline (last 90 days)
Change Data Capture (CDC) is a technique for reading data changes from database transaction logs (such as MySQL binlog, PostgreSQL WAL).
The project uses Laravel 12 as the backend framework, MySQL as the database, and Tailwind CSS for frontend styling.
A developer used Google's AI coding tool to build a multi-merchant POS system from scratch, with a tech stack of Laravel 12, Livewire 3, MySQL and Tailwind CSS.
Execution plan analysis is one of the most reliable ways to diagnose SQL performance problems; in PostgreSQL use EXPLAIN (ANALYZE, BUFFERS), and MySQL provides EXPLAIN ANALYZE in versions that support it.
The phantom read problem under MySQL's repeatable read level needs to be solved with gap locks.
MySQL's default isolation level is repeatable read, which implements snapshot reads through MVCC to avoid non-repeatable reads.
The project's technology stack includes Ollama (local deployment tool), DeepSeek inference model, Spring Boot 3 + Spring AI, and MySQL (for persistent storage of conversational data).
Oracle's acquisition of Sun caused disruption to the MySQL community.
Port 22 corresponds to SSH (remote login service), and port 3306 corresponds to MySQL database
MySQL is a client-server architecture database that requires separate installation and service startup, and is suitable for production environments with high concurrency and large data volumes
40 more timeline events
All Facts (20)
Debezium is one of the most well-known CDC platforms, supporting real-time streaming of database changes to message queues such as Kafka
75%VerifiedDify deployed via Docker can communicate with MySQL 8 on a Windows host machine and also with databases in a VMware virtual machine.
65%VerifiedMySQL's InnoDB storage engine uses the B+ tree as the default index data structure.
65%VerifiedMySQL listens on port 3306 by default.
65%VerifiedDjango's ORM supports multiple database backends, including PostgreSQL, MySQL, and SQLite.
65%UnverifiedRAGFlow基于Docker容器化部署，启动后运行五个容器：Redis、MinIO、MySQL、Elasticsearch和RAGFlow Server
95%UnverifiedWordPress基于PHP语言开发，以MySQL作为数据存储后端
95%UnverifiedMySQL由瑞典公司MySQL AB开发，2008年被Sun收购，后随Sun并入Oracle旗下
95%UnverifiedMySQL的innodb_buffer_pool_size参数直接决定了有多少数据可以驻留内存
95%UnverifiedCloudBase提供两种数据库类型：文档型数据库和MySQL数据库
90%UnverifiedOne API 采用 SQLite 或 MySQL 数据库存储所有租户数据，通过令牌 ID 进行逻辑隔离
90%UnverifiedPostgreSQL使用libpq协议，MySQL使用MySQL Protocol，SQL Server使用TDS（Tabular Data Stream）协议
90%UnverifiedAI在执行数据库初始化时遇到了MySQL驱动找不到的问题，这是Java项目中典型的依赖管理问题
90%Unverified从SQLite迁移到MySQL的本质是将本地数据操作替换为远程API调用
90%UnverifiedRAGFlow依赖Elasticsearch（全文检索）、Redis（缓存）、MySQL（元数据存储）等多个服务
85%Unverified菜单表中的中文数据出现了乱码问题，通常是数据库字符集配置（如未设置为utf8mb4）导致的
85%Unverified游标分页在百万级以上数据量的表中效果尤为显著，查询时间可从数秒降至毫秒级
80%UnverifiedCursor能够正确处理二级分类的数据结构，并将SQLite的本地查询逻辑替换为MySQL的远程API调用
80%UnverifiedMySQL uses AUTO_INCREMENT to implement auto-increment primary keys, PostgreSQL uses SERIAL or IDENTITY, and SQLite automatically implements auto-increment via INTEGER PRIMARY KEY.
70%UnverifiedMySQL's LIMIT offset, N pagination method has a deep pagination performance problem: even if only N records need to be returned, it must first scan and discard the preceding offset records.
60%