Pogledajte određenu poruku
Staro 30. 07. 2009.   #1
Zizi
Zizi
 
Datum učlanjenja: 05.06.2007
Poruke: 9
Hvala: 2
0 "Hvala" u 0 poruka
Zizi is on a distinguished road
Default MySQL Problem - proces koji koristi mnogo CPU

Pozdrav, imam dedicated server Core 2 Duo, 3 Ghz, PHP 5.2.10, MySQL 5, Apache 2.2 ... poslednjih 15 dana mi se pojavilo u Process Manager MySQL proces koji koristi mnogo CPU-u ...

Komanda koju taj proces koristi je:

/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/server.mojserver.biz.pid --skip-external-locking

Kada klikne na Trace Procces, tacnije da vidim vise izlista mi sledece ... Fajl je oko 1 MB mislim da je i veci cak i sve se ponavlja isto ...

Neznam u cemu je problem, da li smijem da "ubijem proces" ili sta vec, na netu sam nasao da je taj problem vezan uz Core 2 duo procesore ...

Hvala na pomoci

Process 23472 attached - interrupt to quit
select(13, [10 12], NULL, NULL, NULL) = 1 (in [12])
fcntl(12, F_SETFL, O_RDWR|O_NONBLOCK) = 0
accept(12, {sa_family=AF_FILE, path="\313\21\177"}, [2]) = 135
fcntl(12, F_SETFL, O_RDWR) = 0
getsockname(135, {sa_family=AF_FILE, path="/var/lib/mysql\1"}, [28]) = 0
fcntl(135, F_SETFL, O_RDONLY) = 0
fcntl(135, F_GETFL) = 0x2 (flags O_RDWR)
fcntl(135, F_SETFL, O_RDWR|O_NONBLOCK) = 0
setsockopt(135, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported)
futex(0xd14b24, FUTEX_WAKE_OP_PRIVATE, 1, 1, 0xd14b20, {FUTEX_OP_SET, 0, FUTEX_OP_CMP_GT, 1}) = 1
futex(0xd14180, FUTEX_WAKE_PRIVATE, 1) = 1
select(13, [10 12], NULL, NULL, NULL) = 1 (in [12])
fcntl(12, F_SETFL, O_RDWR|O_NONBLOCK) = 0
accept(12, {sa_family=AF_FILE, path="\313\21\177"}, [2]) = 166
fcntl(12, F_SETFL, O_RDWR) = 0
getsockname(166, {sa_family=AF_FILE, path="/var/lib/mysql\1"}, [28]) = 0
fcntl(166, F_SETFL, O_RDONLY) = 0
fcntl(166, F_GETFL) = 0x2 (flags O_RDWR)
fcntl(166, F_SETFL, O_RDWR|O_NONBLOCK) = 0
setsockopt(166, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported)
futex(0xd14b24, FUTEX_WAKE_OP_PRIVATE, 1, 1, 0xd14b20, {FUTEX_OP_SET, 0, FUTEX_OP_CMP_GT, 1}) = 1
futex(0xd14180, FUTEX_WAKE_PRIVATE, 1) = 1
select(13, [10 12], NULL, NULL, NULL) = 1 (in [12])
fcntl(12, F_SETFL, O_RDWR|O_NONBLOCK) = 0
accept(12, {sa_family=AF_FILE, path="\313\21\177"}, [2]) = 135
fcntl(12, F_SETFL, O_RDWR) = 0
getsockname(135, {sa_family=AF_FILE, path="/var/lib/mysql\1"}, [28]) = 0
fcntl(135, F_SETFL, O_RDONLY) = 0
fcntl(135, F_GETFL) = 0x2 (flags O_RDWR)
fcntl(135, F_SETFL, O_RDWR|O_NONBLOCK) = 0
setsockopt(135, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported)
futex(0xd14b24, FUTEX_WAKE_OP_PRIVATE, 1, 1, 0xd14b20, {FUTEX_OP_SET, 0, FUTEX_OP_CMP_GT, 1}) = 1
futex(0xd14180, FUTEX_WAKE_PRIVATE, 1) = 1
select(13, [10 12], NULL, NULL, NULL) = 1 (in [12])
fcntl(12, F_SETFL, O_RDWR|O_NONBLOCK) = 0
accept(12, {sa_family=AF_FILE, path="\313\21\177"}, [2]) = 135
fcntl(12, F_SETFL, O_RDWR) = 0
getsockname(135, {sa_family=AF_FILE, path="/var/lib/mysql\1"}, [28]) = 0
fcntl(135, F_SETFL, O_RDONLY) = 0
fcntl(135, F_GETFL) = 0x2 (flags O_RDWR)
fcntl(135, F_SETFL, O_RDWR|O_NONBLOCK) = 0
setsockopt(135, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported)
futex(0xd14b24, FUTEX_WAKE_OP_PRIVATE, 1, 1, 0xd14b20, {FUTEX_OP_SET, 0, FUTEX_OP_CMP_GT, 1}) = 1
__________________
http://www.vezice.com

Poslednja izmena od Zizi : 30. 07. 2009. u 14:20.
Zizi je offline   Odgovorite uz citat