mysql can't start dues to the disk space is full
use ./mysqld_safe --user=mysql &
start mysql.
The mysql can not start. There are much mysql restart info show on the screen always. And can not find the /var/lib/mysql/mysql.sock file.
The reason:
Then find the space is full. So the mysql can not start naturally. Delete some log info, then the mysql start correctly.
The big log files are two:
1. Our application log
2. The /var/log/audit.d
在/var/log/audit.d目錄下的檔案是由Linux審計子系統(Linux Audit Subsystem,簡稱LAuS)產生的。
為了安全目的,LAuS在啟動以後,預設配置是會記錄一些特定的系統活動。如果不需要進行安全審計,可
以透過以下命令關機LAuS服務:
service audit stop
chkconfig audit off
停止LAuS服務以後,在/var/log/audit.d目錄下面的任何save.*檔案都可以刪除。我們推薦您原封不動的
保留bin.*檔案,以備將來使用。LAuS功能在紅帽企業版Linux3以上版本預設沒有開啟。
因為LAuS被用來作安全審計,所以它的日誌檔案是不會自動刪除,會一直保留。如果您的系統負載比較重
,並且在執行LAuS監控系統,LAuS的日誌檔案會增長的很快,有可能會佔滿/var的空間導致系統崩潰。有
幾種方式可以用來阻止以上事件發上。最簡單的方法是定時監控/var/log/audit.d目錄的大小,刪除過時
的save.*檔案。另一種技術是不要把歸檔的審計日誌儲存為save.*檔案。修改/etc/audit/audit.conf裡
面的notify行,用/bin/true代替原先的/usr/sbin/audbin:
/etc/audit/audit.conf
output {
mode = bin;
num-files = 4;
file-size = 20M;
file-name = "/var/log/audit.d/bin";
notify = "/bin/true";
第三種方式是寫一個指令碼定時刪除save.*檔案。
[@more@]來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/545828/viewspace-923785/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- MySQL不能啟動 Can't start server : Bind on unix sockeMySqlServer
- Oracle dbconsole can't startOracle
- MySQL 5.5 原始碼安裝報錯"[ERROR] Can't start server"MySql原始碼ErrorServer
- Troubleshooting when srvctl can't start RAC instance, but sqlplus can start it [ID 844272.1]SQL
- Automatic Archiving does not Restart if Disk Space is Full(轉自Metalink)REST
- [ERROR] Can't open the mysql.plugin tableErrorMySqlPlugin
- mysql遇到Variable can’t be set to the value of ‘NULL’MySqlNull
- Oracle ASM Disk Used Space DirectoryOracleASM
- mysql [ERROR] Can't create IP socket: Permission deniedMySqlError
- Can't debug c++ project because unable to static library start program *.libC++Project
- MySQL連線提示Can't connect to local MySQL server through socketMySqlServer
- Can't connect to local MySQL server through socket '/tmp/mysql.sock'MySqlServer
- 【MySQL】Can't get stat of './mysql/slow_log.CSV' (Errcode: 2)MySql
- mysql中You can’t specify target table for update in FROM clMySql
- Mysql報錯Fatal error:Can't open and lock privilege tablesMySqlError
- mysql can't connect error about privilege----not root userMySqlError
- rman: can't open target
- 異常:Can't connect to MySQL server (10060)MySqlServer
- 連線MySQL錯誤:Can't connect to MySQL server (10060)MySqlServer
- MySQL 2003 - Can’t connect to MySQL server on (10060)MySqlServer
- Extract or Replicat Fail to Start (Don't Start) With No Error MessagesAIError
- Mysql:Variable 'XXXt' can't be set to the value of 'NULL'解決MySqlNull
- MySQL 建立外來鍵報錯Can't write; duplicate key in tableMySql
- mysql:Variable 'character_set_client' can't be set to the value of 'NULL'解決MySqlclientNull
- mail can't send title on SolarisAI
- 解決Can 't connect to local MySQL server through socket '/tmp/mysql.sock '(2) "MySqlServer
- [轉] The program can't start because api-ms-win-crt-runtime-l1-1-0.dll is missingAPI
- Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock錯誤MySqlServer
- Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist解決辦法ErrorMySql
- MySQL報錯Table 'plugin' is read only [ERROR] Can't open the mysql.plugin table.MySqlPluginError
- MYSQL報1022錯誤:Can't write;duplicate key in table '.....'MySql
- MySQL錯誤1042-Can't get hostname for your addressMySql
- datastage7.5 can't view data?ASTView
- 磁碟分析管理軟體:Disk Space Analyzer Pro mac版Mac
- MySQL 5.5 關閉資料庫報錯"Can't connect to local MySQL server through socket"MySql資料庫Server
- mysql 啟動報錯Can't connect to local MySQL server through socket '/data/mysql/mysql/mysql.sock'(111)MySqlServer
- MySQL案例-不同尋常的[ERROR]Can't create a new thread (errno 11)MySqlErrorthread
- [mysql] 批量匯入提示: Variable ‘character_set_client’ can’t be set to the value of ‘NULLMySqlclientNull