> For the complete documentation index, see [llms.txt](https://mysql.gitbook.teaho.net/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mysql.gitbook.teaho.net/yu-xia-zhang-jie.md).

# 余下章节

在写前已说了只写查询相关，当然全书其实都值得品味。

所以，在这简单推荐下余下内容，

基准测试：

* 基准测试分集成式和单组件式。
* 测试应尽可能完备（无论是，执行时间上，期间的运行信息捕获等等），因为，一个不完整的测试是意义不大的。
* 设定适合自己系统的相应指标。
* 个人通常使用jmeter、jmh、sysbench等工具。

复制、分布式集群：

* 首先，系统不是一蹴而就的，应当是发展的。所以，应应用适合的集群方案。当遇到性能等瓶颈时，首先，要做好测试，究竟是什么限制了系统（CPU？IO？数据库本身？等等），然后再做垂直或水平的开发和拓展，当然，要一定程度上，注意拓展性。
* 复制的方案有好多，各有优劣。要注意一些点，比如，复制时，写操作是复制的瓶颈，当拓宽负载时，并不能做到水平拓展。
* 一般来说，复制、拆分、sharding为常见方案。

备份：

* 首先，要纠正一点，复制不是备份！


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://mysql.gitbook.teaho.net/yu-xia-zhang-jie.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.