?hello everyone:
i have a question puzzle me ,what does "purge log dump" command do ?
does it clear checkpoint table?
when i do it ,nothing happened to my table:
?
>show
checkpoints
+----+----------------------------------------------------------------+
|
id | name??????????????????????????????????????????????????????????
|
+----+----------------------------------------------------------------+
|
0? | Initial_empty_recovery_log???????????????????????????????????? |
| 0? |
backup DUMP-192.168.3.66:25322-20081120151740153+0800????????? |
| 0? |
backup DUMP-192.168.3.66:25322-20081120153540921+0800????????? |
| 0? |
backup DUMP-192.168.3.66:25322-20081120155118310+0800????????? |
| 0? |
backup DUMP-192.168.3.66:25322-20081120160942028+0800????????? |
| 0? |
backup DUMP1-192.168.3.66:25322-20081120163940501+0800???????? |
| 0? |
disable all backends-192.168.3.66:25322-20081120160529035+0800 |
| 0? |
disable all backends-192.168.3.66:25322-20081120162527537+0800 |
| 0? |
disable all backends-192.168.3.66:25322-20081120172810152+0800 |
| 0? |
disable mysql18-192.168.3.66:25322-20081120164730056+0800????? |
| 0? |
disable mysql18-192.168.3.66:25322-20081121100947223+0800????? |
| 0? |
shutdown-192.168.3.66:25322-20081120160529352+0800???????????? |
| 0? |
shutdown-192.168.3.66:25322-20081120162528037+0800???????????? |
| 0? |
shutdown-192.168.3.66:25322-20081120172810636+0800????????????
|
+----+-------------------------------------------------------------
?
> purge log DUMP
?
> show checkpoints
+----+----------------------------------------------------------------+
|
id | name??????????????????????????????????????????????????????????
|
+----+----------------------------------------------------------------+
|
0? | Initial_empty_recovery_log???????????????????????????????????? |
| 0? |
backup DUMP-192.168.3.66:25322-20081120151740153+0800????????? |
| 0? |
backup DUMP-192.168.3.66:25322-20081120153540921+0800????????? |
| 0? |
backup DUMP-192.168.3.66:25322-20081120155118310+0800????????? |
| 0? |
backup DUMP-192.168.3.66:25322-20081120160942028+0800????????? |
| 0? |
backup DUMP1-192.168.3.66:25322-20081120163940501+0800???????? |
| 0? |
disable all backends-192.168.3.66:25322-20081120160529035+0800 |
| 0? |
disable all backends-192.168.3.66:25322-20081120162527537+0800 |
| 0? |
disable all backends-192.168.3.66:25322-20081120172810152+0800 |
| 0? |
disable mysql18-192.168.3.66:25322-20081120164730056+0800????? |
| 0? |
disable mysql18-192.168.3.66:25322-20081121100947223+0800????? |
| 0? |
shutdown-192.168.3.66:25322-20081120160529352+0800???????????? |
| 0? |
shutdown-192.168.3.66:25322-20081120162528037+0800???????????? |
| 0? |
shutdown-192.168.3.66:25322-20081120172810636+0800????????????
|
+----+-------------------------------------------------------------
thx for re,
thanks!
?
2008-11-21
yangxu4000
-------------------------------------------------------------------
新浪空间——与朋友开心分享网络新生活！(http://space.sina.com.cn/ )
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
