phpor – 第52页 – PHPor 的Blog

记录一次sql优化

一大早到公司，加班一宿的同事就跟我抱怨，说，一个表只有8w条数据，需要更新一列，根据目前进度估算，大概需要3个 …

用shell试图使用大量内存的方法

一条命令：

dd if=/dev/zero of=/dev/null bs=1G count=1 && echo succ

1	dd if=/dev/zero of=/dev/null bs=1G count=1 && echo succ

如果要持续占用一段时间呢? [c …

继续阅读“用shell试图使用大量内存的方法”

关于docker-runc

docker命令行会有一系列的操作容器的方法，如： create 、run、start、exec等等，这些都是 …

继续阅读“关于docker-runc”

关于容器中进程的继承关系

下图是一个容器中的进程：每个容器总是有一个1号进程 1号进程的父进程在容器中显示为0号进程，而在容器外表现为 …

继续阅读“关于容器中进程的继承关系”

关于PHP Fatal error时获取更多信息

PHP 输出错误时的堆栈情况：

#0  php_error_cb (type=1, error_filename=0x7ffff7fdbaf0 "/data3/eatmem.php", error_lineno=3,
    format=<value optimized out>, args=<value optimized out>)
    at /data3/rpmbuild/SOURCES/beebank-php5-5.5.25.1/main/main.c:1132
#1  0x00000000006ae29c in zend_error (type=1,
    format=0xb09580 "Allowed memory size of %ld bytes exhausted (tried to allocate %lu bytes)")
    at /data3/rpmbuild/SOURCES/beebank-php5-5.5.25.1/Zend/zend.c:1128
#2  0x0000000000687848 in zend_mm_safe_error (heap=0xe2f050,
    format=0xb09580 "Allowed memory size of %ld bytes exhausted (tried to allocate %lu bytes)", limit=1048576,
    size=2048001) at /data3/rpmbuild/SOURCES/beebank-php5-5.5.25.1/Zend/zend_alloc.c:1777
#3  0x00000000006884e6 in _zend_mm_alloc_int (heap=0xe2f050, size=2048001)
    at /data3/rpmbuild/SOURCES/beebank-php5-5.5.25.1/Zend/zend_alloc.c:1980
#4  0x000000000061195b in zif_str_repeat (ht=<value optimized out>, return_value=0x7ffff7fdb058,
    return_value_ptr=<value optimized out>, this_ptr=<value optimized out>,
    return_value_used=<value optimized out>)
    at /data3/rpmbuild/SOURCES/beebank-php5-5.5.25.1/ext/standard/string.c:4917
#5  0x000000000073070b in zend_do_fcall_common_helper_SPEC (execute_data=<value optimized out>)
    at /data3/rpmbuild/SOURCES/beebank-php5-5.5.25.1/Zend/zend_vm_execute.h:550
#6  0x0000000000721f50 in execute_ex (execute_data=0x7ffff7fa8210)
    at /data3/rpmbuild/SOURCES/beebank-php5-5.5.25.1/Zend/zend_vm_execute.h:363
#7  0x00000000006ad719 in zend_execute_scripts (type=8, retval=0x0, file_count=3)
    at /data3/rpmbuild/SOURCES/beebank-php5-5.5.25.1/Zend/zend.c:1327
#8  0x000000000064ef7a in php_execute_script (primary_file=0x7fffffffe070)
    at /data3/rpmbuild/SOURCES/beebank-php5-5.5.25.1/main/main.c:2525
#9  0x000000000075fdbc in do_cli (argc=6, argv=0xe2ec30)
    at /data3/rpmbuild/SOURCES/beebank-php5-5.5.25.1/sapi/cli/php_cli.c:994
#10 0x0000000000760558 in main (argc=6, argv=0xe2ec30)
    at /data3/rpmbuild/SOURCES/beebank-php5-5.5.25.1/sapi/cli/php_cli.c:1378

#0 php_error_cb (type=1, error_filename=0x7ffff7fdbaf0 "/data3/eatmem.php", error_lineno=3,

format=<value optimized out>, args=<value optimized out>)

at /data3/rpmbuild/SOURCES/beebank-php5-5.5.25.1/main/main.c:1132

#1 0x00000000006ae29c in zend_error (type=1,

format=0xb09580 "Allowed memory size of %ld bytes exhausted (tried to allocate %lu bytes)")

at /data3/rpmbuild/SOURCES/beebank-php5-5.5.25.1/Zend/zend.c:1128

#2 0x0000000000687848 in zend_mm_safe_error (heap=0xe2f050,

format=0xb09580 "Allowed memory size of %ld bytes exhausted (tried to allocate %lu bytes)", limit=1048576,

size=2048001) at /data3/rpmbuild/SOURCES/beebank-php5-5.5.25.1/Zend/zend_alloc.c:1777

#3 0x00000000006884e6 in _zend_mm_alloc_int (heap=0xe2f050, size=2048001)

at /data3/rpmbuild/SOURCES/beebank-php5-5.5.25.1/Zend/zend_alloc.c:1980

#4 0x000000000061195b in zif_str_repeat (ht=<value optimized out>, return_value=0x7ffff7fdb058,

return_value_ptr=<value optimized out>, this_ptr=<value optimized out>,

return_value_used=<value optimized out>)

at /data3/rpmbuild/SOURCES/beebank-php5-5.5.25.1/ext/standard/string.c:4917

#5 0x000000000073070b in zend_do_fcall_common_helper_SPEC (execute_data=<value optimized out>)

at /data3/rpmbuild/SOURCES/beebank-php5-5.5.25.1/Zend/zend_vm_execute.h:550

#6 0x0000000000721f50 in execute_ex (execute_data=0x7ffff7fa8210)

at /data3/rpmbuild/SOURCES/beebank-php5-5.5.25.1/Zend/zend_vm_execute.h:363

#7 0x00000000006ad719 in zend_execute_scripts (type=8, retval=0x0, file_count=3)

at /data3/rpmbuild/SOURCES/beebank-php5-5.5.25.1/Zend/zend.c:1327

#8 0x000000000064ef7a in php_execute_script (primary_file=0x7fffffffe070)

at /data3/rpmbuild/SOURCES/beebank-php5-5.5.25.1/main/main.c:2525

#9 0x000000000075fdbc in do_cli (argc=6, argv=0xe2ec30)

at /data3/rpmbuild/SOURCES/beebank-php5-5.5.25.1/sapi/cli/php_cli.c:994

#10 0x0000000000760558 in main (argc=6, argv=0xe2ec30)

at /data3/rpmbuild/SOURCES/beebank-php5-5.5.25.1/sapi/cli/php_cli.c:1378

如果需要添加 …

继续阅读“关于PHP Fatal error时获取更多信息”

关于C语言之字符串拼接（堆与栈）

且看一个demo:

int do_sth(int type) {
    char *errstr;
    
    switch(type) {
    case 1:
        errstr = "Error";break
    case 2:
        errstr = "Warn";break
    case 3:
        errstr = "Info";break
    case 4:
        errstr = "Debug";break
    default:
        return 0;
    }

    if (...) {..}
    if (...) {
        ..;
        fprintf(stdout, "%s %s", errstr, ...);
        return 1;
    }
    if (...) { return 1;}
    if (...) {
        fprintf(stderr, "%s %s", errstr, ...);
    }
    ...
    return 0;
}

int do_sth(int type) {

char *errstr;

switch(type) {

case 1:

errstr = "Error";break

case 2:

errstr = "Warn";break

case 3:

errstr = "Info";break

case 4:

errstr = "Debug";break

default:

return 0;

}

if (...) {..}

if (...) {

..;

fprintf(stdout, "%s %s", errstr, ...);

return 1;

}

if (...) { return 1;}

if (...) {

fprintf(stderr, "%s %s", errstr, ...);

}

...

return 0;

}

问题：如何在errst …

继续阅读“关于C语言之字符串拼接（堆与栈）”

关于php-fpm reload的优雅实现

我们知道，nginx的reload是不会影响服务的，php-fpm也有reload 功能，而且确实不是rest …

继续阅读“关于php-fpm reload的优雅实现”

关于PHP中的长连接

长连接（也叫持久连接）是啥？对于PHP来讲，如果是运行在web模式，每次请求完成，php会回收所有需要的申请 …

继续阅读“关于PHP中的长连接”

关于docker daemon占用大量内存的问题

问题现象：问题环境：

# docker info
Containers: 5
 Running: 3
 Paused: 0
 Stopped: 2
Images: 6
Server Version: 1.12.1
Storage Driver: devicemapper
 Pool Name: data-docker_thinpool
 Pool Blocksize: 524.3 kB
 Base Device Size: 21.47 GB
 Backing Filesystem: xfs
 Data file:
 Metadata file:
 Data Space Used: 5.911 GB
 Data Space Total: 42.95 GB
 Data Space Available: 37.04 GB
 Metadata Space Used: 1.122 MB
 Metadata Space Total: 2.147 GB
 Metadata Space Available: 2.146 GB
 Thin Pool Minimum Free Space: 4.295 GB
 Udev Sync Supported: true
 Deferred Removal Enabled: true
 Deferred Deletion Enabled: false
 Deferred Deleted Device Count: 0
 Library Version: 1.02.107-RHEL7 (2016-06-09)
Logging Driver: json-file
Cgroup Driver: cgroupfs
Plugins:
 Volume: local
 Network: bridge null overlay host
Swarm: inactive
Runtimes: runc
Default Runtime: runc
Security Options: seccomp
Kernel Version: 3.10.0-327.el7.x86_64
Operating System: CentOS Linux 7 (Core)
OSType: linux
Architecture: x86_64
CPUs: 4
Total Memory: 7.389 GiB
Name: iZbp10zkx5pckci8f8gzalZ
ID: NRZQ:4DNU:U4LN:M4K2:TOKQ:Q7HP:ZI7A:Q6UT:RGLR:OS5G:5VDS:AYOH
Docker Root Dir: /data3/docker
Debug Mode (client): false
Debug Mode (server): false
Registry: https://index.docker.io/v1/
WARNING: bridge-nf-call-iptables is disabled
WARNING: bridge-nf-call-ip6tables is disabled
Insecure Registries:
 docker-registry.i.beebank.com:5000
 127.0.0.0/8

# docker info

Containers: 5

Running: 3

Paused: 0

Stopped: 2

Images: 6

Server Version: 1.12.1

Storage Driver: devicemapper

Pool Name: data-docker_thinpool

Pool Blocksize: 524.3 kB

Base Device Size: 21.47 GB

Backing Filesystem: xfs

Data file:

Metadata file:

Data Space Used: 5.911 GB

Data Space Total: 42.95 GB

Data Space Available: 37.04 GB

Metadata Space Used: 1.122 MB

Metadata Space Total: 2.147 GB

Metadata Space Available: 2.146 GB

Thin Pool Minimum Free Space: 4.295 GB

Udev Sync Supported: true

Deferred Removal Enabled: true

Deferred Deletion Enabled: false

Deferred Deleted Device Count: 0

Library Version: 1.02.107-RHEL7 (2016-06-09)

Logging Driver: json-file

Cgroup Driver: cgroupfs

Plugins:

Volume: local

Network: bridge null overlay host

Swarm: inactive

Runtimes: runc

Default Runtime: runc

Security Options: seccomp

Kernel Version: 3.10.0-327.el7.x86_64

Operating System: CentOS Linux 7 (Core)

OSType: linux

Architecture: x86_64

CPUs: 4

Total Memory: 7.389 GiB

Name: iZbp10zkx5pckci8f8gzalZ

ID: NRZQ:4DNU:U4LN:M4K2:TOKQ:Q7HP:ZI7A:Q6UT:RGLR:OS5G:5VDS:AYOH

Docker Root Dir: /data3/docker

Debug Mode (client): false

Debug Mode (server): false

Registry: https://index.docker.io/v1/

WARNING: bridge-nf-call-iptables is disabled

WARNING: bridge-nf-call-ip6tables is disabled

Insecure Registries:

docker-registry.i.beebank.com:5000

127.0.0.0/8

dockerd 打开 …

继续阅读“关于docker daemon占用大量内存的问题”

shell 点滴之 printf

将数组信息已多行格式输出

# A=(1 2 3) && echo ${A[@]}
1 2 3

1 2	# A=(1 2 3) && echo ${A[@]} 1 2 3

如何输出为： [c …

继续阅读“shell 点滴之 printf”