#1  
Old 21st February 2008, 08:56
yak983 yak983 is offline
Junior Member
 
Join Date: Feb 2008
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default myslq eat all ram

mysql use all ram .. and after he take all crash and restart with normal usage

this is the top then eat all memory

top - 08:47:49 up 5 days, 22:32, 1 user, load average: 1.80, 5.43, 4.66
Tasks: 132 total, 2 running, 130 sleeping, 0 stopped, 0 zombie
Cpu(s): 42.2%us, 8.0%sy, 0.0%ni, 17.2%id, 32.3%wa, 0.2%hi, 0.2%si, 0.0%st
Mem: 2857008k total, 2776912k used, 80096k free, 3688k buffers
Swap: 2650684k total, 3412k used, 2647272k free, 1463688k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
27116 mysql 25 0 2325m 2.2g 2708 R 85 82.3 0:28.59 mysqld
166 root 10 -5 0 0 0 S 7 0.0 3:56.87 kswapd0
26924 apache 15 0 63856 25m 12m S 3 0.9 0:02.96 httpd
27115 mysql 16 0 2325m 2.2g 2708 D 2 82.3 0:03.61 mysqld
27114 mysql 15 0 2325m 2.2g 2708 S 2 82.3 0:11.25 mysqld
26945 apache 15 0 63868 27m 14m S 1 1.0 0:05.55 httpd
27002 apache 15 0 67008 29m 14m S 1 1.1 0:02.32 httpd
24779 root 15 0 0 0 0 S 0 0.0 0:03.53 pdflush
27112 mysql 16 0 2325m 2.2g 2708 S 0 82.3 0:05.98 mysqld
28315 root 15 0 2228 1172 856 R 0 0.0 0:00.03 top
1 root 15 0 1852 572 488 S 0 0.0 0:15.05 init
2 root RT 0 0 0 0 S 0 0.0 0:00.04 migration/0
3 root 34 19 0 0 0 S 0 0.0 0:00.05 ksoftirqd/0
4 root RT 0 0 0 0 S 0 0.0 0:00.02 migration/1
5 root 34 19 0 0 0 S 0 0.0 0:00.09 ksoftirqd/1
6 root 10 -5 0 0 0 S 0 0.0 0:00.00 events/0
7 root 10 -5 0 0 0 S 0 0.0 0:00.00 events/1
8 root 10 -5 0 0 0 S 0 0.0 0:00.00 khelper
9 root 10 -5 0 0 0 S 0 0.0 0:00.00 kthread
13 root 10 -5 0 0 0 S 0 0.0 0:00.35 kblockd/0
14 root 10 -5 0 0 0 S 0 0.0 0:00.34 kblockd/1
15 root 15 -5 0 0 0 S 0 0.0 0:00.00 kacpid
120 root 15 -5 0 0 0 S 0 0.0 0:00.00 kseriod
167 root 15 -5 0 0 0 S 0 0.0 0:00.00 aio/0
168 root 14 -5 0 0 0 S 0 0.0 0:00.00 aio/1
313 root 15 0 0 0 0 S 0 0.0 0:00.15 kirqd
634 root 17 -5 0 0 0 S 0 0.0 0:00.00 ata/0
635 root 17 -5 0 0 0 S 0 0.0 0:00.00 ata/1
636 root 17 -5 0 0 0 S 0 0.0 0:00.00 ata_aux


srv02:~# mysql -V
mysql Ver 14.12 Distrib 5.0.51a, for pc-linux-gnu (i686) using readline 5.0


srv02:~# httpd -V
Server version: Apache/2.2.6 (Unix)
Server built: Oct 10 2007 02:10:59
Server's Module Magic Number: 20051115:5
Server loaded: APR 1.2.11, APR-Util 1.2.10
Compiled using: APR 1.2.11, APR-Util 1.2.10
Architecture: 32-bit
Server MPM: Prefork
threaded: no
forked: yes (variable process count)
Server compiled with....
-D APACHE_MPM_DIR="server/mpm/prefork"
-D APR_HAS_SENDFILE
-D APR_HAS_MMAP
-D APR_HAVE_IPV6 (IPv4-mapped addresses enabled)
-D APR_USE_SYSVSEM_SERIALIZE
-D APR_USE_PTHREAD_SERIALIZE
-D SINGLE_LISTEN_UNSERIALIZED_ACCEPT
-D APR_HAS_OTHER_CHILD
-D AP_HAVE_RELIABLE_PIPED_LOGS
-D DYNAMIC_MODULE_LIMIT=128
-D HTTPD_ROOT="/etc/httpd"
-D SUEXEC_BIN="/usr/sbin/suexec"
-D DEFAULT_PIDLOG="/var/logs/httpd.pid"
-D DEFAULT_SCOREBOARD="logs/apache_runtime_status"
-D DEFAULT_LOCKFILE="/var/logs/accept.lock"
-D DEFAULT_ERRORLOG="logs/error_log"
-D AP_TYPES_CONFIG_FILE="conf/mime.types"
-D SERVER_CONFIG_FILE="conf/httpd.conf"


my.cnf
[mysqld]
skip-locking
skip-innodb
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
max_connections=500
interactive_timeout=100
wait_timeout=100
connect_timeout=10
thread_cache_size=128
key_buffer=16M
join_buffer=1M
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=2M
read_buffer_size=2M
max_connect_errors=10
# Prova numero di CPU's*2 per thread_concurrency
thread_concurrency=2
myisam_sort_buffer_size=64M
server-id=1

[safe_mysqld]
err-log=/var/log/mysqld.log
open_files_limit=8192

[mysqldump]
quick
max_allowed_packet=16M

[mysql]
no-auto-rehash
#safe-updates

[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[mysqlhotcopy]
interactive-timeout


i have try to make all mod possible to my.cnf but without any result..
can help me ?
Reply With Quote
Sponsored Links
  #2  
Old 22nd February 2008, 17:33
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,722 Times in 2,563 Posts
Default

Please try this in the [mysqld] section of your my.cnf:

Code:
key_buffer              = 512M
max_allowed_packet      = 2M
thread_stack            = 128K
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
thread_concurrency = 4
wait_timeout = 180
#
# * Query Cache Configuration
#
query_cache_limit       = 1048576
query_cache_size        = 128M
query_cache_type
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 22nd February 2008, 19:46
yak983 yak983 is offline
Junior Member
 
Join Date: Feb 2008
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

ok i try... i write you if this problem go out !
Reply With Quote
  #4  
Old 23rd February 2008, 02:44
yak983 yak983 is offline
Junior Member
 
Join Date: Feb 2008
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

some problem... mysql use all ram .. and after minutes crash and restart normaly for about few hours
Reply With Quote
  #5  
Old 23rd February 2008, 17:19
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,722 Times in 2,563 Posts
 
Default

Are there any errors in your log files?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem RAM memory brunoje Technical 1 10th January 2008 16:01
How to keep in RAM a number of text files? calande Server Operation 2 7th January 2008 17:17
6.06 server on Pentium II 48 MB RAM? RavUn HOWTO-Related Questions 6 7th August 2007 07:48
Minimum ram? njean Installation/Configuration 2 8th June 2006 12:21
Free RAM up and down and up and ...? edge Installation/Configuration 7 7th April 2006 12:12


All times are GMT +2. The time now is 13:01.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.