Mysql data optimization

Server environment

1
2
3
4
5
6
7
8
9
10
11
12
13
14
$ cat /etc/issue
Ubuntu 14.04.5 LTS

$ free -h
total used free shared buffers cached
Mem: 7.8G 7.7G 132M 260K 276K 6.8M
-/+ buffers/cache: 7.7G 139M
Swap: 8.0G 2.3G 5.7G

$ mysqld -V
mysqld Ver 5.5.58-0ubuntu0.14.04.1 for debian-linux-gnu on x86_64 ((Ubuntu))

$ php -v
PHP 7.1.12

Mysql Table Horizontal Split By Mycat

Server environment

1
2
3
4
5
6
7
8
$ cat /etc/issue
Ubuntu 14.04.5 LTS

$ mysqld -V
mysqld Ver 5.5.58-0ubuntu0.14.04.1 for debian-linux-gnu on x86_64 ((Ubuntu))

$ java -version
java version "1.7.0_151"

About Mysql Partition

Server environment

1
2
3
4
5
$ cat /etc/issue
Ubuntu 14.04.5 LTS

$ mysqld -V
mysqld Ver 5.5.58-0ubuntu0.14.04.1 for debian-linux-gnu on x86_64 ((Ubuntu))

Separate Mysql Slow Log Using Logrotate In Ubuntu

Server environment

1
2
3
4
$ cat /etc/issue
Ubuntu 16.04.2 LTS
$ logrotate --version
logrotate 3.8.7

Mysql Slave Config With Docker

Server environment

1
2
3
4
5
6
7
8
9
10
11
12
$ cat /etc/issue
Ubuntu 14.04.5 LTS

$ docker -v
Docker version 1.6.2, build 7c8fca2

mysql> select version();
+------------+
| version() |
+------------+
| 5.7.12-log |
+------------+

How to install Go1.8 in ubuntu14.04

Server environment

1
2
3
4
5
$ cat /etc/issue
Ubuntu 14.04.5 LTS

# go version
go version go1.8.4 linux/amd64

Solve the usb not available problem under Virtualbox win7

Server environment

1
2
3
4
5
$ cat /etc/issue
Ubuntu 14.04.5 LTS

$ virtualbox --help
Oracle VM VirtualBox Manager 5.1.30_Ubuntu

Get real client IP from Nginx to Apache

Server environment

1
2
3
4
5
6
7
8
$ cat /etc/issue
Ubuntu 14.04.5 LTS

$ nginx -v
nginx version: nginx/1.4.6 (Ubuntu)

$ apachectl -v
Server version: Apache/2.4.7 (Ubuntu)

PHP shared session

Server environment

1
2
3
4
5
$ cat /etc/issue
Ubuntu 14.04.5 LTS

$ php -v
PHP 5.6.32-1+ubuntu14.04.1+deb.sury.org+2 (cli)

Operate on Elasticsearch 2.2

Server environment

1
2
3
4
5
6
7
8
$ cat /etc/issue
Ubuntu 14.04.5 LTS

$ curl localhost:9200
{
"version" : {
"number" : "2.2.0",
...

Compile and install LAMP in Ubuntu

Server environment

1
2
$ cat /etc/issue
Ubuntu 14.04.5 LTS

Move gitlab repository to new server

Server environment

1
2
$ cat /etc/issue
Ubuntu 14.04.4 LTS

How to install sock5 proxy on ubuntu

Server environment

1
2
$ cat /etc/issue
Ubuntu 14.04.4 LTS

Be care of the expose ports when docker running in your server

Server environment

1
2
3
4
5
$ cat /etc/issue
Ubuntu 14.04.5 LTS

$ docker -v
Docker version 1.6.2

How sentinel build Redis master-slave

Server Environment

1
2
3
4
5
$ cat /etc/issue
Ubuntu 16.04.2 LTS \n \l

$ redis-server --version
Redis server v=3.0.6 sha=00000000:0 malloc=jemalloc-3.6.0 bits=64
Your browser is out-of-date!

Update your browser to view this website correctly. Update my browser now

×