一

{"type":"编程笔记"}


  • Home

  • Archives
  • Search

mysql 同步1064错误及补救方法

Posted on 2008-02-01   |   In mysql

mysql slaver服务器上收到这个奇怪的1064错误:

Read more »

mysql master and slaver server日志文件清理方法

Posted on 2008-01-31   |   In mysql

一、要在master要清理日志,需按照以下步骤:

  1. 在每个从属服务器上,使用show slave status来检查它正在读取哪个日志。
  2. 使用show master logs获得主服务器上的一系列日志。
  3. 在所有的从属服务器中判定最早的日志。这个是目标日志。如果所有的从属服务器是更新的,这是清单上的最后一个日志。
  4. 制作您将要删除的所有日志的备份。(这个步骤是自选的,但是建议采用。)
  5. 清理所有的日志,但是不包括目标日志。

二、要在slaver上清理日志,需要按以下步骤:

  1. 在本机上使用show slave status来检查它正在使用哪个relay_log_file日志。
  2. 保留此目标日志,可以删除之前的中继日志文件。(中继日志也可以将本机mysql server shutdown后,将hostname-relay-bin.index, hostname-relay-bin.*, relay-log.info删除之后重启mysql server,其中master.info文件不能删除)
  3. 使用show master logs获得本机上的一系列日志。
  4. 保留最新一个,可以删除之前的bin-log文件。
  5. 建议删除之前都先备份,删除后重启server看是否正常同步数据,把当前正式使用的中继日志和bin-log日志删除可能会导致同步不可用。

三、如果主机更新了replication slave user的密码,在slave上执行:

Read more »

http statuses

Posted on 2008-01-31   |   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 2008-01-27   |   In javascript

open Terminal Application, and input:

Read more »

addeventlistener's phase and sequence

Posted on 2008-01-26   |   In javascript

html

Read more »
1…838485…99
yuweijun

yuweijun

492 posts
12 categories
RSS
GitHub Twitter
© 2021 yuweijun
Powered by Hexo
Theme - NexT.Mist.KISS