MySQL日期加减
http://blog.csdn.net/arkblue/article/details/51860327
EXCEL日期转时间戳
https://yq.aliyun.com/ziliao/28096
fastboot命令
http://blog.csdn.net/whu_zhangmin/article/details/23848597
月度归档：2017年11月
论make clean的重要性？
PHP配置不能忘记的东西
时区
date.timezone = Asia/Shanghai
opcache
zend_extension=opcache.so
MySQL链式复制一坑–log-slave-updates
A -> B -> C
默认情况下，来至master的数据是不会写入二进制日志的，导致A复制到B，却不能接着复制到C，要解决这个问题必须开启log-slave-updates=1
https://dev.mysql.com/doc/refman/5.7/en/replication-options-slave.html
bzip2
压缩文件
bzip2 -z filename
Got fatal error 1236 from master when reading data from binary log: ‘Binary log is not open’
Got fatal error 1236 from master when reading data from binary log: ‘Binary log is not open’
Master没有开启log_bin
https://dev.mysql.com/doc/refman/5.6/en/replication-howto-masterbaseconfig.html
[mysqld] log-bin=mysql-bin server-id=1 innodb_flush_log_at_trx_commit=1 sync_binlog=1
resize2fs: Bad magic number in super-block while trying to open /dev/mapper/vg1-lvMysql
resize2fs 对xfs无效问题
resize2fs 1.42.9 (28-Dec-2013)
resize2fs: Bad magic number in super-block while trying to open /dev/mapper/vg1-lvMysql
Couldn’t find valid filesystem superblock.
xfs_growfs /dev/centos/root df -h
ref：https://www.cnblogs.com/pinganzi/p/6478255.html
[root@web5 ~]# xfs_growfs /mnt/mysql
meta-data=/dev/mapper/vg1-lvMysql isize=512 agcount=4, agsize=7864320 blks
= sectsz=512 attr=2, projid32bit=1
= crc=1 finobt=0 spinodes=0
data = bsize=4096 blocks=31457280, imaxpct=25
= sunit=0 swidth=0 blks
naming =version 2 bsize=4096 ascii-ci=0 ftype=1
log =internal bsize=4096 blocks=15360, version=2
= sectsz=512 sunit=0 blks, lazy-count=1
realtime =none extsz=4096 blocks=0, rtextents=0
data blocks changed from 31457280 to 44564480
Nginx常规配置
server_tokens off;
client_max_body_size 1024M;
nginx和php版本号隐藏
Nginx版本隐藏
| Syntax: | server_tokens on | off | build | string; |
|---|---|
| Default: |
server_tokens on; |
| Context: | http, server, location |
PHP版本隐藏
; Decides whether PHP may expose the fact that it is installed on the server
; (e.g. by adding its signature to the Web server header). It is no security
; threat in any way, but it makes it possible to determine whether you use PHP
; on your server or not.
; http://php.net/expose-php
expose_php = Off
authorized_keys
chmod 600 .ssh/authorized_keys
chmod 700 .ssh