Tuesday, April 25, 2017

.::: Simple, Advanced & Full Power Level Tuning Performance MySQL or MariaDB :::.


1. copying/backup my.cnf on linux/unix or my.ini on windows
Linux
[root@SAMLab mysql]# cat /etc/my.cnf

Windows
C:\ProgramData\MySQL\MySQL Server 5.7\my.ini

C:\Users\teguh.triharto>cd C:\ProgramData\MySQL\MySQL Server 5.7

C:\ProgramData\MySQL\MySQL Server 5.7>dir
 Volume in drive C has no label.
 Volume Serial Number is 40FC-A9B1

.::: Install MySQL 57 On Linux Rhel/Centos using RPM/Offline :::.


1. Download rpm instalation from http://dev.mysql.com/downloads/mysql/ as sample

mysql-community-common-5.7.16-1.el6.x86_64.rpm
mysql-community-libs-5.7.16-1.el6.x86_64.rpm
mysql-community-devel-5.7.16-1.el6.x86_64.rpm
mysql-community-client-5.7.16-1.el6.x86_64.rpm
mysql-community-server-5.7.16-1.el6.x86_64.rpm

wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-community-common-5.7.16-1.el6.x86_64.rpm
wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-community-libs-5.7.16-1.el6.x86_64.rpm
wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-community-devel-5.7.16-1.el6.x86_64.rpm
wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-community-client-5.7.16-1.el6.x86_64.rpm
wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-community-server-5.7.16-1.el6.x86_64.rpm


[root@TEGUHTH mysql]# ls -lh
total 173M
-rw-r--r-- 1 root root  23M Nov  7 15:19 mysql-community-client-5.7.16-1.el6.x86_64.rpm
-rw-r--r-- 1 root root 328K Nov 10 15:20 mysql-community-common-5.7.16-1.el6.x86_64.rpm
-rw-r--r-- 1 root root 3.6M Nov 10 14:08 mysql-community-devel-5.7.16-1.el6.x86_64.rpm
-rw-r--r-- 1 root root 2.1M Nov  7 15:21 mysql-community-libs-5.7.16-1.el6.x86_64.rpm
-rw-r--r-- 1 root root 144M Nov  7 15:06 mysql-community-server-5.7.16-1.el6.x86_64.rpm
[root@TEGUHTH mysql]#

Popular Posts