思科sce調(diào)試手冊(編輯修改稿)
2024-09-04 12:23 本頁面
【文章內(nèi)容簡介】 eck cm status), (check cm receiving rdr rate), (check which SCE has connected to this cm and their rdr rate), 如圖如果有哪步不正常，請檢查~/cm/logs中的日值，并根據(jù)日值提示做修改。2檢查MySQL運行狀態(tài) 網(wǎng)上有許多免費的Windows下的圖形化工具，比如mysqladministrator, ( 免費下載)，你可以用這個工具檢查MySQL運行狀態(tài)。這個工具還可以用來檢查數(shù)據(jù)庫健康情況，修復表格，備份，恢復數(shù)據(jù)庫等。Username / password 是 pqb_admin / pqb_adminSCE 流量數(shù)據(jù)庫是 “apricot”, 見下圖:六、 MySQL 性能和日常維護1．數(shù)據(jù)庫表尺寸MySQL庫中的每個表在創(chuàng)建時缺省為最大40000000行，如果是這么多行的SCE流量數(shù)據(jù)大概占4GB左右的磁盤空間。MySQL運行一段時間后往往就在logs出現(xiàn)RPT_TR表已經(jīng)滿了的錯誤信息。此時，TOP N排名無法工作。我們只要將表的最大行數(shù)增加一下就可解決問題?？梢杂妹钚校部捎脠D形化工具，下面使用MySQL administrator, 將RPT_TR加大一倍，如圖：2．查詢性能CM運行一段時間后，隨著數(shù)據(jù)量的增加，Reporter的查詢速度會降低。這是正?，F(xiàn)象，缺省數(shù)據(jù)庫參數(shù)很難適應我們SCE Reporter的需要。數(shù)據(jù)庫優(yōu)化包括合理使用內(nèi)存、緩存和編制索引等等，很復雜， 我不敢玩斧。只是最簡單的設置：在MySQL server安裝完后，在/usr/share/mysql目錄下有如下文件$ pwd/usr/share/mysql$ ls ltotal 64rwxrxrx 1 root root 773 May 7 06:42 binaryconfiguredrwxrxrx 2 root root 4096 Jun 10 11:34 charsetsdrwxrxrx 2 root root 4096 Jun 10 11:34 englishrwxrxrx 1 root root 4702 May 7 06:42 mi_test_allrwxrxrx 1 root root 1365 May 7 06:42 rwxrxrx 1 root root 4874 May 7 06:42 rwxrxrx 1 root root 4850 May 7 06:42 rwxrxrx 1 root root 4836 May 7 06:42 rwxrxrx 1 root root 2416 May 7 06:42 rwxrxrx 1 root root 657 May 7 06:42 mysqllogrotaterwxrxrx 1 root root 5575 May 7 06:42 $ ，對系統(tǒng)資源的配置情況。例如 。你可根據(jù)自己的情況選用一個，并適當修改其中的參數(shù)。（）修改好這個文件后，將文件存為 /etc/ 。MySQL每次啟動時都會按照這個文件的參數(shù)執(zhí)行。樣本 /etc/:$ more Example MySQL config file for medium systems. This is for a system with little memory (32M 64M) where MySQL plays an important part, or systems up to 128M where MySQL is used together with other programs (such as a web server) You can copy this file to /etc/ to set global options, mysqldatadir/ to set serverspecific options (in this installation this directory is /var/lib/mysql) or ~/. to set userspecific options. In this file, you can use all long options that a program supports. If you want to know which options a program supports, run the program with the help option. The following options will be passed to all MySQL clients[client]password = your_passwordport = 3306socket = /var/lib/mysql/ Here follows entries for some specific programs The MySQL server[mysqld]datadir = /data1/mysqlport = 3306socket = /var/lib/mysql/skiplockingkey_buffer = 64Mmax_allowed_packet = 1Mtable_cache = 128sort_buffer_size = 1M net_buffer_length = 16Kmyisam_sort_buffer_size = 16M以下省略。3．錯誤日
畢業(yè)設計相關(guān)推薦
鄂ICP備17016276號-1