資料庫開幾天即會停止運作

edited 十月 2013 in 資料庫
各為前輩好
我的資料庫版本是3.23.1
我的資料庫開幾天即會停止運作
重新啟動即會恢復運作。
不知道是被攻擊還是其他因素
想請問
關於mysql的log檔要在那裡看
mysql是否有設定檔,需要調整其記憶體的使用量否?
感謝~

原始討論: http://twpug.net/x/modules/newbb/viewtopic.php?topic_id=3015

評論

  • edited 十一月 2007
    如果是Windows版
    設定檔在c:\windows\my.ini

    跟記憶體比較有關的參數大致如下
    set-variable=key_buffer=128M
    set-variable=record_buffer=16M
    set-variable=join_buffer_size=16M
    set-variable=sort_buffer=64M
    set-variable=thread_concurrency=4
    set-variable=max_connections=1024
    set-variable=wait_timeout=120
    set-variable=table_cache=2048
    set-variable=thread_cache_size=20M
    set-variable=tmp_table_size=256M
    set-variable=max_heap_table_size=256M
    set-variable=myisam_sort_buffer_size=128M
    set-variable=query_buffer_size=256M
    至於詳細說明請善用google吧
  • edited 十一月 2007
    你好~
    謝謝你回答我~
    我是使用Fedora Core3當系統
    現在很煩~Mysql一直停止~沒有固定時間區間
    因為前陣主機被攻擊linux root不能登了
    現在從灌也更新
    但是Mysql一直停止~我還找不出原因
    請問google的搜索方向為何
    雖然找了mysql攻擊..等關鍵字
    還是無法解惑
    我想先判斷是否被攻擊~請問應該如何判斷
    有人有提供付費處理的服務嗎?
  • edited 十一月 2007
    我把我的log檔放上來~
    幫我看一下吧~


    071130 9:41:26 /usr/libexec/mysqld: Normal shutdown

    071130 9:41:27 /usr/libexec/mysqld: Forcing close of thread 12240 user: 'root'

    071130 9:41:27 /usr/libexec/mysqld: Forcing close of thread 12239 user: 'root'

    071130 9:41:27 /usr/libexec/mysqld: Forcing close of thread 12238 user: 'root'

    071130 9:41:27 /usr/libexec/mysqld: Forcing close of thread 12237 user: 'root'

    071130 9:41:27 /usr/libexec/mysqld: Forcing close of thread 12236 user: 'root'

    071130 9:41:27 /usr/libexec/mysqld: Forcing close of thread 12235 user: 'root'

    071130 9:41:27 /usr/libexec/mysqld: Forcing close of thread 12234 user: 'root'

    071130 9:41:27 /usr/libexec/mysqld: Forcing close of thread 12233 user: 'root'

    071130 9:41:27 /usr/libexec/mysqld: Forcing close of thread 12232 user: 'root'

    071130 9:41:27 /usr/libexec/mysqld: Forcing close of thread 12231 user: 'root'

    071130 9:41:27 /usr/libexec/mysqld: Forcing close of thread 12230 user: 'root'

    071130 9:41:27 /usr/libexec/mysqld: Forcing close of thread 12229 user: 'root'

    071130 9:41:27 /usr/libexec/mysqld: Forcing close of thread 12228 user: 'root'

    071130 9:41:27 /usr/libexec/mysqld: Forcing close of thread 12227 user: 'root'

    071130 9:41:27 /usr/libexec/mysqld: Forcing close of thread 12226 user: 'root'

    071130 9:41:27 /usr/libexec/mysqld: Forcing close of thread 12225 user: 'root'

    071130 9:41:27 /usr/libexec/mysqld: Forcing close of thread 12224 user: 'root'

    071130 9:41:27 /usr/libexec/mysqld: Forcing close of thread 12223 user: 'root'

    071130 9:41:27 /usr/libexec/mysqld: Forcing close of thread 12222 user: 'root'

    071130 9:41:27 /usr/libexec/mysqld: Forcing close of thread 12221 user: 'root'

    071130 9:41:27 /usr/libexec/mysqld: Forcing close of thread 12220 user: 'root'

    071130 9:41:27 /usr/libexec/mysqld: Forcing close of thread 12219 user: 'root'

    071130 9:41:27 /usr/libexec/mysqld: Forcing close of thread 12218 user: 'root'

    071130 9:41:27 /usr/libexec/mysqld: Forcing close of thread 12217 user: 'root'

    071130 9:41:27 /usr/libexec/mysqld: Forcing close of thread 12216 user: 'root'

    071130 9:41:27 /usr/libexec/mysqld: Forcing close of thread 12215 user: 'root'

    071130 9:41:27 /usr/libexec/mysqld: Forcing close of thread 12214 user: 'root'

    071130 9:41:27 /usr/libexec/mysqld: Forcing close of thread 12213 user: 'root'

    071130 9:41:27 /usr/libexec/mysqld: Forcing close of thread 12212 user: 'root'

    071130 9:41:27 /usr/libexec/mysqld: Forcing close of thread 12211 user: 'root'

    07071130 09:42:54 mysqld started
    Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
    If you do not want to use transactional InnoDB tables, add a line
    skip-innodb
    to the [mysqld] section of init parameters in your my.cnf
    or my.ini. If you want to use InnoDB tables, add to the [mysqld]
    section, for example,
    innodb_data_file_path = ibdata1:10M:autoextend
    But to get good performance you should adjust for your hardware
    the InnoDB startup options listed in section 2 at
    http://www.innodb.com/ibman.html
    /usr/libexec/mysqld: ready for connections
    071130 15:26:43 /usr/libexec/mysqld: Normal shutdown

    071130 15:26:44 /usr/libexec/mysqld: Forcing close of thread 1301 user: 'root'

    071130 15:26:44 /usr/libexec/mysqld: Forcing close of thread 1300 user: 'root'

    071130 15:26:44 /usr/libexec/mysqld: Forcing close of thread 1299 user: 'root'

    071130 15:26:44 /usr/libexec/mysqld: Forcing close of thread 1298 user: 'root'

    071130 15:26:44 /usr/libexec/mysqld: Forcing close of thread 1297 user: 'root'

    071130 15:26:44 /usr/libexec/mysqld: Forcing close of thread 1296 user: 'root'

    071130 15:26:44 /usr/libexec/mysqld: Forcing close of thread 1295 user: 'root'

    071130 15:26:44 /usr/libexec/mysqld: Forcing close of thread 1294 user: 'root'

    071130 15:26:44 /usr/libexec/mysqld: Forcing close of thread 1293 user: 'root'

    071130 15:26:44 /usr/libexec/mysqld: Forcing close of thread 1292 user: 'root'

    071130 15:26:44 /usr/libexec/mysqld: Forcing close of thread 1291 user: 'root'

    071130 15:26:44 /usr/libexec/mysqld: Forcing close of thread 1290 user: 'root'

    071130 15:26:44 /usr/libexec/mysqld: Forcing close of thread 1289 user: 'root'

    071130 15:26:44 /usr/libexec/mysqld: Forcing close of thread 1288 user: 'root'

    071130 15:26:44 /usr/libexec/mysqld: Forcing close of thread 1287 user: 'root'

    071130 15:26:44 /usr/libexec/mysqld: Forcing close of thread 1286 user: 'root'

    071130 15:26:44 /usr/libexec/mysqld: Forcing close of thread 1285 user: 'root'

    071130 15:26:44 /usr/libexec/mysqld: Forcing close of thread 1284 user: 'root'

    071130 15:26:44 /usr/libexec/mysqld: Forcing close of thread 1283 user: 'root'

    071130 15:26:44 /usr/libexec/mysqld: Forcing close of thread 1282 user: 'root'

    071130 15:26:44 /usr/libexec/mysqld: Forcing close of thread 1281 user: 'root'

    071130 15:26:44 /usr/libexec/mysqld: Forcing close of thread 1280 user: 'root'

    071130 15:26:44 /usr/libexec/mysqld: Forcing close of thread 1279 user: 'root'

    071130 15:26:44 /usr/libexec/mysqld: Forcing close of thread 1278 user: 'root'

    071130 15:26:44 /usr/libexec/mysqld: Forcing close of thread 1277 user: 'root'

    071130 15:26:44 /usr/libexec/mysqld: Forcing close of thread 1276 user: 'root'

    071130 15:26:44 /usr/libexec/mysqld: Forcing close of thread 1275 user: 'root'

    071130 15:26:44 /usr/libexec/mysqld: Forcing close of thread 1274 user: 'root'

    071130 15:26:44 /usr/libexec/mysqld: Forcing close of thread 1273 user: 'root'

    071130 15:26:44 /usr/libexec/mysqld: Forcing close of thread 1272 user: 'root'

    071130 15:26:44 /usr/libexec/mysqld: Forcing close of thread 1271 user: 'root'

    071130 15:26:44 /usr/libexec/mysqld: Forcing close of thread 1270 user: 'root'

    071130 15:26:44 /usr/libexec/mysqld: Forcing close of thread 1269 user: 'root'

    071130 15:26:44 /usr/libexec/mysqld: Forcing close of thread 1268 user: 'root'

    071130 15:26:44 /usr/libexec/mysqld: Forcing close of thread 1267 user: 'root'

    071130 15:26:44 /usr/libexec/mysqld: Forcing close of thread 1266 user: 'root'

    071130 15:26:44 /usr/libexec/mysqld: Forcing close of thread 1265 user: 'root'

    071130 15:26:44 /usr/libexec/mysqld: Forcing close of thread 1264 user: 'root'

    071130 15:26:44 /usr/libexec/mysqld: Forcing close of thread 1263 user: 'root'

    071130 15:26:44 /usr/libexec/mysqld: Forcing close of thread 1262 user: 'root'

    071130 15:26:44 /usr/libexec/mysqld: Forcing close of thread 1261 user: 'root'

    071130 15:26:44 /usr/libexec/mysqld: Forcing close of thread 1260 user: 'root'

    071130 15:26:44 /usr/libexec/mysqld: ForA mysqld process already exists at 五 11月 30 15:26:47 CST 2007
    071130 15:27:14 /usr/libexec/mysqld: Shutdown Complete

    071130 15:27:14 mysqld ended

    071130 15:29:02 mysqld started
    Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
    If you do not want to use transactional InnoDB tables, add a line
    skip-innodb
    to the [mysqld] section of init parameters in your my.cnf
    or my.ini. If you want to use InnoDB tables, add to the [mysqld]
    section, for example,
    innodb_data_file_path = ibdata1:10M:autoextend
    But to get good performance you should adjust for your hardware
    the InnoDB startup options listed in section 2 at
    http://www.innodb.com/ibman.html
    /usr/libexec/mysqld: ready for connections
Sign In or Register to comment.