Faq Mysql

Last updated: Apr 3, 2026

Table of Contents

Dirty read, Lost of modify, Unrepeatable read, Phantom read
MySQL index
MySQL explain (execution plan)
use DateTime or TimeStamp ?

FAQ - MySQL

Dirty read, Lost of modify, Unrepeatable read, Phantom read

https://javaguide.cn/database/mysql/mysql-questions-01.html#并发事务带来了哪些问题

MySQL index

B+ tree as underline structure
https://javaguide.cn/database/mysql/mysql-index.html#索引介绍

MySQL `explain` (execution plan)

https://javaguide.cn/database/mysql/mysql-query-execution-plan.html#id

use `DateTime` or `TimeStamp` ?

https://javaguide.cn/database/mysql/some-thoughts-on-database-storage-time.html#时区信息