|
SQL baze podataka - Sponzor: Baze-Podataka.net MySQL, MSSQL, Oracle, Access, ODBC. Ako imate problem brže i preciznije ćete dobiti odgovor ako priložite strukturu tabela ili skript koji kreira tabele i puni ih test podacima umesto što to problem opisujete samo rečima. Sponzor: Baze-Podataka.net - Blog o bazama podataka |
|
Alati teme | Način prikaza |
30. 07. 2009. | #1 |
Zizi
Datum učlanjenja: 05.06.2007
Poruke: 9
Hvala: 2
0 "Hvala" u 0 poruka
|
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. |
|
|
Slične teme | ||||
Tema | Početna poruka teme | Forum | Odgovori | Poslednja poruka |
Kako saznati koji firefox tab koristi puno resursa i blokira citav FF? | misk0 | Web aplikacije, web servisi i software | 4 | 03. 08. 2009. 01:30 |
Kako nagovoriti mysql da koristi odredjeni index? | ivanhoe | SQL baze podataka - Sponzor: Baze-Podataka.net | 5 | 26. 05. 2009. 12:53 |
Problem sa centralnom kolonom i rezolucijom kada se koristi position:absolute | Deki80 | (X)HTML, JavaScript, DHTML, XML, CSS | 1 | 17. 09. 2007. 20:45 |
Koji program za Database Diagram (MySql)? | tesla | SQL baze podataka - Sponzor: Baze-Podataka.net | 21 | 25. 12. 2006. 17:29 |
Ima neko možda Google Analytics nalog koji ne koristi? | mungos | Web aplikacije, web servisi i software | 26 | 16. 08. 2006. 21:54 |