標籤: mysql - Laugh Now

Structures and Architectures for Optimizing Database (EN)

Structures and Architectures for Optimizing Database (EN)

Recently, I read the XtraDB part of Percona Server document roughly, in this process, I realized my huge lack of basic database knowledge, so it’s inevitable to spend a lot of time on clarifying many concepts which have been mentioned several times in the doc.

In the meanwhile, I found out that there’s so much incorrect and ambiguous information on the internet, for the greater good, it could be great if I organize these all materials and post them on this blog. This article contain a few MySQL only usage, but it’s won’t cut down the readability for the reader who is not familiar with MySQL (perhaps…).

Why use English? Due to most of the info I collect are written in English and I don’t have enough time to translate them. But don’t worry, I’ll post a Chinese version someday.

繼續閱讀
限制 SQL 的資料查詢筆數

限制 SQL 的資料查詢筆數

常常在SELECT資料庫時,因為資料量龐大或是某些特殊原因,只想查詢特定筆數的資料,但因為各家資料庫的語法不盡相同,避免每次都要重新查詢一次,所以就整理起來。

繼續閱讀