Skip to content

Instantly share code, notes, and snippets.

xuan exuan

Block or report user

Report or block exuan

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View mysql5.7-install
cmake . -DCMAKE_INSTALL_PREFIX=/data/database/mysql \
-DWITH_BOOST=../boost_1_63_0 \
-DSYSCONFDIR=/data/database/mysql \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DWITH_FEDERATED_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DENABLED_LOCAL_INFILE=1 \
-DENABLE_DTRACE=0 \
@exuan
exuan / git-config-core-ignorecase.md
Created Aug 1, 2016
git 默认不区分文件名大小写, 被黑的欲仙欲死
View git-config-core-ignorecase.md

git 默认不区分文件名大小写, 被黑的欲仙欲死, 需要关闭ignorecase

$ git config --global core.ignorecase false
View mysqlbinlog-decode.md
[root@localhost ~]# /usr/local/mysql/bin/mysqlbinlog --base64-output=DECODE-ROWS -v  /data/database/3306/data/mysql-bin.000034
@exuan
exuan / php7-configure.md
Last active May 24, 2016
php7 安装配置
View php7-configure.md

配置参数引用2015博客升级记(五):CentOS 7.1编译安装PHP7

  ./configure \
--prefix=/usr/local/php7 \
--exec-prefix=/usr/local/php7 \
--bindir=/usr/local/php7/bin \
--sbindir=/usr/local/php7/sbin \
--includedir=/usr/local/php7/include \
--libdir=/usr/local/php7/lib/php \
@exuan
exuan / purge-binay-logs.sql
Created Oct 26, 2015
清理MySQL bin log
View purge-binay-logs.sql
PURGE BINARY LOGS BEFORE DATE_SUB( NOW( ), INTERVAL 3 DAY);
PURGE BINARY LOGS TO 'mysql-bin.000082';
/**
* 重置
*/
RESET MASTER;
@exuan
exuan / excel-form.php
Last active Oct 19, 2015
phpexcel 画一个排期
View excel-form.php
<?php
$charts = array(); //26 * 27
for($i = 65; $i <91; $i++) {
$charts[] = chr($i);
}
for($i = 65; $i <91; $i++) {
$char = chr($i);
for($j = 65; $j <91; $j++) {
$charts[] = $char . chr($j);
}
@exuan
exuan / getExtension.php
Created May 4, 2015
获取文件后缀
View getExtension.php
echo pathinfo($file, PATHINFO_EXTENSION);
View chrome_extension_get_cookie.js
You can’t perform that action at this time.