- 创建gist
- 获取gist ID 如：https://gist.github.com/username/12331233, ID即为 12331233.
- clone gist 最好采用git ssh方式
git clone git@github.com:12331233.git
cd 12331233
jiangtao hustjiangtao
🏠
hustjiangtao
/ format-u-disk-on-macos.md
Created
November 4, 2019 13:19
Format sd card or U disk on MacOS
# list all disk
$ diskutil list
/dev/disk0
/dev/disk1
/dev/disk2
...
# format U-disk to FAT32
$ diskutil partitionDisk /dev/disk5 MBR FAT32 UNTITLED 0b
hustjiangtao
/ backup-with-tar-or-zip-on-linux.md
Created
November 3, 2019 05:13
Backup on linux with tar or zip command
- tar
# 打包压缩
$ tar -zcvf demo.tar ./demo/
$ tar zcvf demo.tar ./demo/
$ tar zcf demo.tar ./demo/
# 解压缩
$ tar xvf demo.tar
hustjiangtao
/ create_mysql_database_with_utf8mb4.md
Created
November 2, 2019 11:40
Create a new database with utf8mb4
-- Create a new database named xxx
create database demo_db character set utf8mb4 collate utf8mb4_unicode_ci;
- mysql在小内存服务器上的优化设置
直接安装的mysql5.7默认使用innodb引擎，默认开启performance_schema，故针对innodb优化，并关闭performance_schema，即可大幅优化内存占用
其中performance_schema影响最大，在不需要的前提下，可直接设置 performance_schema=0 即可。
# vim /etc/my.cnf
[mysqld]
performance_schema=0
innodb_buffer_pool_size = 64M
To see more: