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
Post a Comment