All Stories

An interesting question about max function of MySQL

An interesting question about max function of MySQL

Why can't we use the 'max(point), id' to get the additional columns?

Shuo Shuo
26 Oct 2024
Why think and why not think

Why think and why not think

Do you like to think or do you have time to think?

Shuo Shuo
01 Aug 2024
An extra Americano

An extra Americano

Fresh up?

Shuo Shuo
25 Jul 2024
Why cook eggs with meat

Why cook eggs with meat

Curious why curious?

Shuo Shuo
14 Jul 2024
New Job and new life

New Job and new life

2024, my new job and life.

Shuo Shuo
07 Jul 2024
MySQL Group Replication初探

MySQL Group Replication初探

Group Replication为原生MySQL高可用集群架构，shared-nothing结构。

Shuo Shuo
05 Mar 2023
ProxySQL简介

ProxySQL简介

ProxySQL简介,ProxySQL被用作数据库代理，完成读写分离、routing等操作

Shuo Shuo
26 Feb 2023
MySQL Clone Plugin

MySQL Clone Plugin

介绍MySQL clone plugin的用法及使用场景

Shuo Shuo
06 Feb 2023

Linux磁盘监控-diskio_io_time

查看Linux系统的磁盘监控，常常需要关注磁盘的情况，例如：diskio_io_time，能够间接反应磁盘的繁忙情况

Shuo Shuo
03 Feb 2023
MySQL源码-Seconds_Behind_Master的计算

MySQL源码-Seconds_Behind_Master的计算

What the Seconds_Behind_Master means? And how to calculate it? MySQL源码-Seconds_Behind_Master的计算

Shuo Shuo
18 Jan 2023

linux-transparent_hugepage

What is transparent_hugepage in Linux and why we should disable it in database instance?

Shuo Shuo
20 Dec 2022
Linux swap 内存溢出

Linux swap 内存溢出

由于磁盘IO较弱的原因，不再在数据库的实例上进行swap的内存溢出，需要进行关闭

Shuo Shuo
19 Dec 2022