PHP Strace result - mysql sleeping connections -


so, after running strace on sleeping connections, have come across few things have fixed (removed strace) wondering if can notice else strace result.

it's mysql sleep state when analyse ntp netstat can see close_wait after while. hit several sleeping connections grind server half.

process 13948 attached - interrupt quit read(14, "\21v\257\305\302\365\320\326", 8) = 8 close(14)                               = 0 mlock(0x1b50d70, 24)                    = 0 mlock(0xb766da80, 10624)                = 0 gettimeofday({1369138768, 45552}, null) = 0 write(2, "[tue may 21 07:19:28 2013] [erro"..., 187) = 187 gettimeofday({1369138768, 45621}, null) = 0 write(2, "[tue may 21 07:19:28 2013] [erro"..., 195) = 195 getcwd("/home/site-name/site-name/current/www", 4096) = 39 time(null)                              = 1369138768 lstat64("/home/site-name/site-name/current/www/./zend/cache/backend/file.php", 0xbfeb553c) = -1 enoent (no such file or directory) time(null)                              = 1369138768 lstat64("/usr/share/pear/zend/cache/backend/file.php", 0xbfeb553c) = -1 enoent (no such file or directory) time(null)                              = 1369138768 lstat64("/usr/share/php/zend/cache/backend/file.php", 0xbfeb553c) = -1 enoent (no such file or directory) time(null)                              = 1369138768 lstat64("/home/site-name/site-name/current/lib/zend/cache/backend/file.php", {st_mode=s_ifreg|0777, st_size=34079, ...}) = 0 lstat64("/home/site-name/site-name/current/lib/zend/cache/backend", {st_mode=s_ifdir|0777, st_size=4096, ...}) = 0 lstat64("/home/site-name/site-name/current/lib/zend/cache", {st_mode=s_ifdir|0777, st_size=4096, ...}) = 0 lstat64("/home/site-name/site-name/current/lib/zend", {st_mode=s_ifdir|0777, st_size=4096, ...}) = 0 lstat64("/home/site-name/site-name/current/lib", {st_mode=s_ifdir|0777, st_size=4096, ...}) = 0 lstat64("/home/site-name/site-name/current", {st_mode=s_ifdir|0777, st_size=4096, ...}) = 0 lstat64("/home/site-name/site-name", {st_mode=s_ifdir|0755, st_size=4096, ...}) = 0 lstat64("/home/site-name", {st_mode=s_ifdir|0755, st_size=4096, ...}) = 0 lstat64("/home", {st_mode=s_ifdir|0755, st_size=4096, ...}) = 0 stat64("/home/site-name/site-name/current/temp", {st_mode=s_ifdir|0777, st_size=4096, ...}) = 0 access("/home/site-name/site-name/current/temp", w_ok) = 0 time(null)                              = 1369138768 lstat64("/home/site-name/site-name/current/temp", {st_mode=s_ifdir|0777, st_size=4096, ...}) = 0 getcwd("/home/site-name/site-name/current/www", 4096) = 39 time(null)                              = 1369138768 lstat64("/home/site-name/site-name/current/www/./zend/cache/core.php", 0xbfeb553c) = -1 enoent (no such file or directory) time(null)                              = 1369138768 lstat64("/usr/share/pear/zend/cache/core.php", 0xbfeb553c) = -1 enoent (no such file or directory) time(null)                              = 1369138768 lstat64("/usr/share/php/zend/cache/core.php", 0xbfeb553c) = -1 enoent (no such file or directory) time(null)                              = 1369138768 lstat64("/home/site-name/site-name/current/lib/zend/cache/core.php", {st_mode=s_ifreg|0777, st_size=23895, ...}) = 0 stat64("/home/site-name/site-name/current/temp/zend_cache---internal-metadatas---published_letters_s_0_t_4_e_1", {st_mode=s_ifreg|0600, st_size=99, ...}) = 0 time(null)                              = 1369138768 lstat64("/home/site-name/site-name/current/temp/zend_cache---internal-metadatas---published_letters_s_0_t_4_e_1", {st_mode=s_ifreg|0600, st_size=99, ...}) = 0 open("/home/site-name/site-name/current/temp/zend_cache---internal-metadatas---published_letters_s_0_t_4_e_1", o_rdonly) = 14 fstat64(14, {st_mode=s_ifreg|0600, st_size=99, ...}) = 0 lseek(14, 0, seek_cur)                  = 0 flock(14, lock_sh)                      = 0 fstat64(14, {st_mode=s_ifreg|0600, st_size=99, ...}) = 0 read(14, "a:4:{s:4:\"hash\";i:-1389558010;s:"..., 8192) = 99 read(14, "", 8192)                      = 0 read(14, "", 8192)                      = 0 flock(14, lock_un)                      = 0 close(14)                               = 0 time(null)                              = 1369138768 stat64("/home/site-name/site-name/current/temp/zend_cache---published_letters_s_0_t_4_e_1", {st_mode=s_ifreg|0600, st_size=3981, ...}) = 0 time(null)                              = 1369138768 lstat64("/home/site-name/site-name/current/temp/zend_cache---published_letters_s_0_t_4_e_1", {st_mode=s_ifreg|0600, st_size=3981, ...}) = 0 open("/home/site-name/site-name/current/temp/zend_cache---published_letters_s_0_t_4_e_1", o_rdonly) = 14 fstat64(14, {st_mode=s_ifreg|0600, st_size=3981, ...}) = 0 lseek(14, 0, seek_cur)                  = 0 flock(14, lock_sh)                      = 0 fstat64(14, {st_mode=s_ifreg|0600, st_size=3981, ...}) = 0 read(14, "s:3971:\"a:2:{s:7:\"results\";a:4:{"..., 8192) = 3981 read(14, "", 8192)                      = 0 read(14, "", 8192)                      = 0 flock(14, lock_un)                      = 0 close(14)                               = 0 time(null)                              = 1369138768 gettimeofday({1369138768, 47925}, null) = 0 write(2, "[tue may 21 07:19:28 2013] [erro"..., 521) = 521 time(null)                              = 1369138768 time(null)                              = 1369138768 time(null)                              = 1369138768 gettimeofday({1369138768, 48061}, null) = 0 write(2, "[tue may 21 07:19:28 2013] [erro"..., 516) = 516 time(null)                              = 1369138768 gettimeofday({1369138768, 48154}, null) = 0 write(2, "[tue may 21 07:19:28 2013] [erro"..., 516) = 516 time(null)                              = 1369138768 time(null)                              = 1369138768 gettimeofday({1369138768, 48295}, null) = 0 write(2, "[tue may 21 07:19:28 2013] [erro"..., 493) = 493 time(null)                              = 1369138768 gettimeofday({1369138768, 48412}, null) = 0 write(2, "[tue may 21 07:19:28 2013] [erro"..., 499) = 499 time(null)                              = 1369138768 time(null)                              = 1369138768 gettimeofday({1369138768, 48530}, null) = 0 write(2, "[tue may 21 07:19:28 2013] [erro"..., 499) = 499 time(null)                              = 1369138768 time(null)                              = 1369138768 gettimeofday({1369138768, 48642}, null) = 0 write(2, "[tue may 21 07:19:28 2013] [erro"..., 499) = 499 time(null)                              = 1369138768 time(null)                              = 1369138768 gettimeofday({1369138768, 48751}, null) = 0 write(2, "[tue may 21 07:19:28 2013] [erro"..., 499) = 499 time(null)                              = 1369138768 time(null)                              = 1369138768 time(null)                              = 1369138768 time(null)                              = 1369138768 lstat64("/home/site-name/site-name/current/app/models/member.php", {st_mode=s_ifreg|0777, st_size=21802, ...}) = 0 lstat64("/home/site-name/site-name/current/app/models", {st_mode=s_ifdir|0777, st_size=4096, ...}) = 0 lstat64("/home/site-name/site-name/current/app", {st_mode=s_ifdir|0777, st_size=4096, ...}) = 0 poll([{fd=13, events=pollin|pollpri}], 1, 0) = 1 ([{fd=13, revents=pollin}]) read(13, "", 8192)                      = 0 shutdown(13, 2 /* send , receive */)  = 0 close(13)                               = 0 getcwd("/home/site-name/site-name/current/www", 4096) = 39 time(null)                              = 1369138768 lstat64("/home/site-name/site-name/current/www/./zend/db/statement/exception.php", 0xbfeb552c) = -1 enoent (no such file or directory) time(null)                              = 1369138768 lstat64("/usr/share/pear/zend/db/statement/exception.php", 0xbfeb552c) = -1 enoent (no such file or directory) time(null)                              = 1369138768 lstat64("/usr/share/php/zend/db/statement/exception.php", 0xbfeb552c) = -1 enoent (no such file or directory) time(null)                              = 1369138768 lstat64("/home/site-name/site-name/current/lib/zend/db/statement/exception.php", {st_mode=s_ifreg|0777, st_size=1569, ...}) = 0 lstat64("/home/site-name/site-name/current/lib/zend/db/statement", {st_mode=s_ifdir|0777, st_size=4096, ...}) = 0 lstat64("/home/site-name/site-name/current/lib/zend/db", {st_mode=s_ifdir|0777, st_size=4096, ...}) = 0 time(null)                              = 1369138768 open("/home/site-name/site-name/current/lib/zend/db/statement/exception.php", o_rdonly) = 13 fstat64(13, {st_mode=s_ifreg|0777, st_size=1569, ...}) = 0 fstat64(13, {st_mode=s_ifreg|0777, st_size=1569, ...}) = 0 fstat64(13, {st_mode=s_ifreg|0777, st_size=1569, ...}) = 0 mmap2(null, 1569, prot_read, map_shared, 13, 0) = 0xb76fb000 munmap(0xb76fb000, 1569)                = 0 close(13)                               = 0 getcwd("/home/site-name/site-name/current/www", 4096) = 39 time(null)                              = 1369138768 lstat64("/home/site-name/site-name/current/www/./zend/db/exception.php", 0xbfeb552c) = -1 enoent (no such file or directory) time(null)                              = 1369138768 lstat64("/usr/share/pear/zend/db/exception.php", 0xbfeb552c) = -1 enoent (no such file or directory) time(null)                              = 1369138768 lstat64("/usr/share/php/zend/db/exception.php", 0xbfeb552c) = -1 enoent (no such file or directory) time(null)                              = 1369138768 lstat64("/home/site-name/site-name/current/lib/zend/db/exception.php", {st_mode=s_ifreg|0777, st_size=1076, ...}) = 0 time(null)                              = 1369138768 open("/home/site-name/site-name/current/lib/zend/db/exception.php", o_rdonly) = 13 fstat64(13, {st_mode=s_ifreg|0777, st_size=1076, ...}) = 0 fstat64(13, {st_mode=s_ifreg|0777, st_size=1076, ...}) = 0 fstat64(13, {st_mode=s_ifreg|0777, st_size=1076, ...}) = 0 mmap2(null, 1076, prot_read, map_shared, 13, 0) = 0xb76fb000 munmap(0xb76fb000, 1076)                = 0 close(13)                               = 0 getcwd("/home/site-name/site-name/current/www", 4096) = 39 time(null)                              = 1369138768 lstat64("/home/site-name/site-name/current/www/./zend/exception.php", 0xbfeb552c) = -1 enoent (no such file or directory) time(null)                              = 1369138768 lstat64("/usr/share/pear/zend/exception.php", 0xbfeb552c) = -1 enoent (no such file or directory) time(null)                              = 1369138768 lstat64("/usr/share/php/zend/exception.php", 0xbfeb552c) = -1 enoent (no such file or directory) time(null)                              = 1369138768 lstat64("/home/site-name/site-name/current/lib/zend/exception.php", {st_mode=s_ifreg|0777, st_size=2659, ...}) = 0 time(null)                              = 1369138768 time(null)                              = 1369138768 gettimeofday({1369138768, 51202}, null) = 0 write(2, "[tue may 21 07:19:28 2013] [erro"..., 489) = 489 getcwd("/home/site-name/site-name/current/www", 4096) = 39 time(null)                              = 1369138768 lstat64("/home/site-name/site-name/current/www/./zend/db/statement/exception.php", 0xbfeb51bc) = -1 enoent (no such file or directory) time(null)                              = 1369138768 lstat64("/usr/share/pear/zend/db/statement/exception.php", 0xbfeb51bc) = -1 enoent (no such file or directory) time(null)                              = 1369138768 lstat64("/usr/share/php/zend/db/statement/exception.php", 0xbfeb51bc) = -1 enoent (no such file or directory) time(null)                              = 1369138768 gettimeofday({1369138768, 51837}, null) = 0 write(2, "[tue may 21 07:19:28 2013] [erro"..., 1189) = 1189 chdir("/")                              = 0 time(null)                              = 1369138768 getcwd("/", 4096)                       = 2 time(null)                              = 1369138768 lstat64("//./zend/db/table/select.php", 0xbfeb6ccc) = -1 enoent (no such file or directory) time(null)                              = 1369138768 lstat64("/usr/share/pear/zend/db/table/select.php", 0xbfeb6ccc) = -1 enoent (no such file or directory) time(null)                              = 1369138768 lstat64("/usr/share/php/zend/db/table/select.php", 0xbfeb6ccc) = -1 enoent (no such file or directory) time(null)                              = 1369138768 lstat64("/home/site-name/site-name/current/lib/zend/db/table/select.php", {st_mode=s_ifreg|0777, st_size=6665, ...}) = 0 lstat64("/home/site-name/site-name/current/lib/zend/db/table", {st_mode=s_ifdir|0777, st_size=4096, ...}) = 0 getcwd("/", 4096)                       = 2 time(null)                              = 1369138768 lstat64("//./zend/db/statement/exception.php", 0xbfeb6ccc) = -1 enoent (no such file or directory) time(null)                              = 1369138768 lstat64("/usr/share/pear/zend/db/statement/exception.php", 0xbfeb6ccc) = -1 enoent (no such file or directory) time(null)                              = 1369138768 lstat64("/usr/share/php/zend/db/statement/exception.php", 0xbfeb6ccc) = -1 enoent (no such file or directory) time(null)                              = 1369138768 gettimeofday({1369138768, 52798}, null) = 0 write(2, "[tue may 21 07:19:28 2013] [erro"..., 136) = 136 munlock(0x1b50d70, 24)                  = 0 munlock(0xb766da80, 10624)              = 0 setitimer(itimer_prof, {it_interval={0, 0}, it_value={0, 0}}, null) = 0 writev(12, [{"http/1.0 500 internal server err"..., 466}, {"\37\213\10\0\0\0\0\0\0\3", 10}, {"\3\0", 2}, {"\0\0\0\0\0\0\0\0", 8}], 4) = 486 write(9, "wwww.sitename.com - - -"..., 223) = 223 shutdown(12, 1 /* send */)              = 0 poll([{fd=12, events=pollin}], 1, 2000) = 1 ([{fd=12, revents=pollin|pollhup}]) read(12, "", 512)                       = 0 close(12)                               = 0 read(5, 0xbfebbf8f, 1)                  = -1 eagain (resource temporarily unavailable) 


Comments

Popular posts from this blog

blackberry 10 - how to add multiple markers on the google map just by url? -

php - guestbook returning database data to flash -

delphi - Dynamic file type icon -