mysql slaver服务器上收到这个奇怪的1064错误:
mysql master and slaver server日志文件清理方法
Posted on
|
In
mysql
一、要在master要清理日志,需按照以下步骤:
- 在每个从属服务器上,使用show slave status来检查它正在读取哪个日志。
- 使用show master logs获得主服务器上的一系列日志。
- 在所有的从属服务器中判定最早的日志。这个是目标日志。如果所有的从属服务器是更新的,这是清单上的最后一个日志。
- 制作您将要删除的所有日志的备份。(这个步骤是自选的,但是建议采用。)
- 清理所有的日志,但是不包括目标日志。
二、要在slaver上清理日志,需要按以下步骤:
- 在本机上使用show slave status来检查它正在使用哪个relay_log_file日志。
- 保留此目标日志,可以删除之前的中继日志文件。(中继日志也可以将本机mysql server shutdown后,将hostname-relay-bin.index, hostname-relay-bin.*, relay-log.info删除之后重启mysql server,其中master.info文件不能删除)
- 使用show master logs获得本机上的一系列日志。
- 保留最新一个,可以删除之前的bin-log文件。
- 建议删除之前都先备份,删除后重启server看是否正常同步数据,把当前正式使用的中继日志和bin-log日志删除可能会导致同步不可用。
三、如果主机更新了replication slave user的密码,在slave上执行:
http statuses
Posted on
|
In
web
| status code | description |
|---|---|
| 200 | request completed (OK) |
| 201 | object created, reason = new URI |
| 202 | async completion (TBS) |
| 203 | partial completion |
| 204 | no info to return |
| 205 | request completed, but clear form |
| 206 | partial GET furfilled |
| 300 | server couldn't decide what to return |
| 301 | object permanently moved |
| 302 | object temporarily moved |
| 303 | redirection w/ new access method |
| 304 | if-modified-since was not modified |
| 305 | redirection to proxy, location header specifies proxy to use |
| 307 | HTTP/1.1: keep same verb |
| 400 | invalid syntax |
| 401 | access denied |
| 402 | payment required |
| 403 | request forbidden |
| 404 | object not found |
| 405 | method is not allowed |
| 406 | no response acceptable to client found |
| 407 | proxy authentication required |
| 408 | server timed out waiting for request |
| 409 | user should resubmit with more info |
| 410 | the resource is no longer available |
| 411 | the server refused to accept request w/o a length |
| 412 | precondition given in request failed |
| 413 | request entity was too large |
| 414 | request URI too long |
| 415 | unsupported media type |
| 500 | internal server error |
| 501 | required not supported |
| 502 | error response received from gateway |
| 503 | temporarily overloaded |
| 504 | timed out waiting for gateway |
| 505 | HTTP version not supported |
open safari debug menu
Posted on
|
In
javascript
open Terminal Application, and input:
addeventlistener's phase and sequence
Posted on
|
In
javascript