[前][次][番号順一覧][スレッド一覧]

mysql:14193

From: 山本 孝一 <山本 孝一 <yamamoto@xxxxxxxxxx>>
Date: Tue, 11 Sep 2007 21:55:59 +0900
Subject: [mysql 14193] mysqldでout of memoryが多発

長文です。お許しください。
【問題点】
 月に2度くらいの頻度でmysqldでout of memoryが短時間に多発してサーバが反応しなくなる。
【環境】
 Turbo Linux Sever 8
 Mysql 3.23.58-log
 Memory 512MB
【状況】
 Movable Typeを利用するためにMySQLを利用しています。利用当初は問題なかったの
ですが、今年の3月頃から月に2度くらいの頻度でmysqldでout of memoryが発生して
サーバを操作できなくなります。原因かもしれないと思われるのは、2月初旬にMTを
MT3.32-ja→MT3.34にバージョンアップしたことかもしれません。現在はMT3.35ですが、
状況は同じです。当初はメモリー不足かと思って256MB→512MBをしましたが、頻度が
少し減った程度です。
 どうしたらout of memoryを出させなくできるでしょうか?ご存じの方、教えていた
だけたら幸いです。

【資料】
[root@ns etc]# mysqladmin -u XXXXXX -p version
Enter password:
mysqladmin Ver 8.23 Distrib 3.23.58, for pc-linux on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version 3.23.58-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 4 hours 52 min 30 sec

Threads: 1 Questions: 10354 Slow queries: 0 Opens: 25 Flush tables: 1 Open tables: 19 Queries per second avg: 0.590

[root@ns etc]# cat my.cnf
# Example mysql config file for medium systems.
#
# This is for a system with little memory (32M - 64M) where MySQL plays
# a important part and systems up to 128M very MySQL is used together with
# other programs (like a web server)
#
# You can copy this file to
# /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is /var/lib/mysql) or
# ~/.my.cnf to set user-specific options.
#
# One can in this file use all long options that the program supports.
# If you want to know which options a program support, run the program
# with --help option.

# The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 3306
socket = /var/lib/mysql/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
datadir = /var/lib/mysql
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
skip-innodb
set-variable = key_buffer=16M
set-variable = max_allowed_packet=1M
set-variable = table_cache=64
set-variable = sort_buffer=512K
set-variable = net_buffer_length=8K
set-variable = myisam_sort_buffer_size=8M
log-bin
server-id = 1

# language
#language=/usr/share/mysql/japanese
#language=/usr/share/mysql/korean
#language=/usr/share/mysql/czech
#default-character-set=euc

# Point the following paths to different dedicated disks
#tmpdir = /tmp/
#log-update = /path-to-dedicated-directory/hostname

# Uncomment the following if you are using BDB tables
#set-variable = bdb_cache_size=4M
#set-variable = bdb_max_lock=10000

# Uncomment the following if you are using Innobase tables
#innodb_data_file_path = ibdata1:400M
#innodb_data_home_dir = /var/lib/mysql/
#innodb_log_group_home_dir = /var/lib/mysql/
#innodb_log_arch_dir = /var/lib/mysql/
#set-variable = innodb_mirrored_log_groups=1
#set-variable = innodb_log_files_in_group=3
#set-variable = innodb_log_file_size=5M
#set-variable = innodb_log_buffer_size=8M
#innodb_flush_log_at_trx_commit=1
#innodb_log_archive=0
#set-variable = innodb_buffer_pool_size=16M
#set-variable = innodb_additional_mem_pool_size=2M
#set-variable = innodb_file_io_threads=4
#set-variable = innodb_lock_wait_timeout=50

[mysqldump]
quick
set-variable = max_allowed_packet=16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
set-variable = key_buffer=20M
set-variable = sort_buffer=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M

[myisamchk]
set-variable = key_buffer=20M
set-variable = sort_buffer=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M

[mysqlhotcopy]
interactive-timeout

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

// 山本孝一             //
// yamamoto@xxxxxxxxxx //


[前][次][番号順一覧][スレッド一覧]

->   14193 2007-09-11 21:55 [山本 孝一 <yamamoto@] mysqldでout of memoryが多発             
     14194 2007-09-11 22:46 ┣["F.Y" <fumi_sby@xxxx]                                       
     14202 2007-09-14 10:41 ┗[Katsutoshi Nakatomi ]                                       
     14203 2007-09-14 13:03  ┗[山本 孝一 <yamamoto@]                                     
     14204 2007-09-14 14:31   ┗[Katsutoshi Nakatomi ]                                   
     14205 2007-09-14 15:21    ┗[山本 孝一 <yamamoto@]