压缩文件
bzip2 -z filename

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

server_tokens off;

client_max_body_size 1024M;

Nginx版本隐藏

server_tokens on;

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

深入理解SELECT … LOCK IN SHARE MODE和SELECT … FOR UPDATE

SELECT * FROM information_schema.INNODB_TRX

$t = 1504145678;
print_r(
    array(
        date('Y-m-d', $t),
        date('Y-m-d', strtotime('- 1 month', $t)),
        date('Y-m-d', strtotime('- 2 month', $t))
    ));

原文连接：http://www.xixinice.com/?post=5

<br />
<b>Deprecated</b>: Automatically populating $HTTP_RAW_POST_DATA is deprecated and will be removed in a future version. To avoid this warning set ‘always_populate_raw_post_data’ to ‘-1’ in php.ini and use the php://input stream instead. in
<b>Unknown</b> on line
<b>0</b>
<br />
<br />
<b>Warning</b>: Cannot modify header information – headers already sent in
<b>Unknown</b> on line
<b>0</b>
<br />

edit php.ini and set always_populate_raw_post_data = -1

; Always populate the $HTTP_RAW_POST_DATA variable. PHP’s default behavior is
; to disable this feature and it will be removed in a future version.
; If post reading is disabled through enable_post_data_reading,
; $HTTP_RAW_POST_DATA is *NOT* populated.
; http://php.net/always-populate-raw-post-data
always_populate_raw_post_data = -1