您好,登錄后才能下訂單哦!
本篇內(nèi)容介紹了“Mysql中maatkit的安裝和簡(jiǎn)介”的有關(guān)知識(shí),在實(shí)際案例的操作過(guò)程中,不少人都會(huì)遇到這樣的困境,接下來(lái)就讓小編帶領(lǐng)大家學(xué)習(xí)一下如何處理這些情況吧!希望大家仔細(xì)閱讀,能夠?qū)W有所成!
maatkit 是baron.schwartz 為主導(dǎo),開(kāi)源的Mysql工具,提供了很多Mysql官方目前并沒(méi)有實(shí)現(xiàn)的功能.大大方便和加強(qiáng)了Mysql的監(jiān)控和管理.下面簡(jiǎn)單介紹下安裝和使用.
官方網(wǎng)站:http://www.maatkit.org/
文檔地址:http://maatkit.sourceforge.net/doc/maatkit.html
google主頁(yè)和下載: http://code.google.com/p/maatkit/
安裝很簡(jiǎn)單,比如我下載的maatkit-2725.zip ,釋放后整個(gè)文件夾傳到服務(wù)器上,對(duì)于軟件環(huán)境要求,一般就是DBD::mysql和DBI,當(dāng)然少不了perl.安裝只要幾個(gè)命令:
# cd maatkit-2725/
# perl Makefile.PL
# make
# make install
就可以使用了,下面是一些有用的功能
1、mk-table-checksum 檢查主從表是否一致及有效的工具
2、mk-table-sync 使表一致的工具,不必重載從表而能夠保證一致
3、mk-visual-explain exlpain解釋工具
4、mk-heartbeat 主從同步的監(jiān)視工具,能夠給出從落后于主多少
5、mk-parallel-dump 多線程的mysqldump工具
6、mk-parallel-restore 多線程的表修復(fù)工具
7、mk-query-profiler 查詢檢測(cè)分析工具
8、mk-deadlock-logger 死鎖的記錄工具
9、mk-duplicate-key-checker key偵測(cè)工具
10、mk-show-grants 權(quán)限管理顯示工具
11、mk-slave-restart slave的檢測(cè)和重啟工具
12、mk-slave-delay slave delay replication 的工具
mk-archiver Archive rows from a MySQL table into another table or a file.
mk-audit Analyze, summarize and report on MySQL config, schema and operation
mk-checksum-filter Filter checksums from mk-table-checksum.
mk-deadlock-logger Extract and log MySQL deadlock information.
mk-duplicate-key-checker Find possible duplicate indexes and foreign keys on MySQL tables.
mk-fifo-split Split files and pipe lines to a fifo without really splitting.
mk-find Find MySQL tables and execute actions, like GNU find.
mk-heartbeat Monitor MySQL replication delay.
mk-log-parser Analyze and review MySQL logs.
mk-log-player Split and play MySQL slow logs.
mk-log-server Serve MySQL binary logs.
mk-parallel-dump Dump sets of MySQL tables in parallel.
mk-parallel-restore Load files into MySQL in parallel.
mk-profile-compact Compact the output from mk-query-profiler.
mk-query-profiler Execute SQL statements and print statistics, or measure activity caused by other processes.
mk-show-grants Canonicalize and print MySQL grants so you can effectively replicate, compare and version-control them.
mk-slave-delay Make a MySQL slave server lag behind its master.
mk-slave-find Find MySQL replication slaves and execute commands on them.
mk-slave-move Move a MySQL slave around in the replication hierarchy.
mk-slave-prefetch Pipeline relay logs on a MySQL slave to pre-warm caches.
mk-slave-restart Watch and restart MySQL replication after errors.
mk-table-checksum Perform an online replication consistency check, or checksum MySQL tables efficiently on one or many servers.
mk-table-sync Synchronize MySQL tables efficiently.
mk-visual-explain Format EXPLAIN output as a tree.
“Mysql中maatkit的安裝和簡(jiǎn)介”的內(nèi)容就介紹到這里了,感謝大家的閱讀。如果想了解更多行業(yè)相關(guān)的知識(shí)可以關(guān)注億速云網(wǎng)站,小編將為大家輸出更多高質(zhì)量的實(shí)用文章!
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。