slow query 설정

/etc/my.cnf 수정


[mysqld]

long_query_time = 3

log_output = 'TABLE' of 'FILE'

slow_query_log = 1

slow_query_log_file = /var/log/mysql/mysql-slow.log

max_user_connections=500;

max_connections=500;

-------------------



[performance_schema] table on필요

statements_digest

events_statements_history_long

--------------------


[바로설정]

SET global log_output = 'table';

set global long_query_time = 3;

set global slow_query_log = 1;

set global long_query_log_file = 'slow-queries.log';

set global general_log=1;

set global general_log_file = '';

select @@general_log;

select @@general_log_file;


[에러로그 위치]

/var/log/mysqld.log


[max connection 설정]

GRANT USAGE ON *.* TO 'root'@'%' with MAX_USER_CONNECTIONS 500;


'Database' 카테고리의 다른 글

[AWS] MySQL 설치  (0) 2016.08.22
MySQL 설치 (우분투)  (0) 2016.08.17
MySQL 설치(CentOS)  (0) 2016.08.17

[MySql설치]

wget http://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm

sudo yum localinstall http://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm

sudo yum install mysql-community-server

 sudo service mysqld start


root 패스워드 변경

/usr/bin/mysqladmin -u root password 'maxgauge'
또는 update user set password=password('new-password') where user='root';
mysql -uroot -p


원격접속 허용

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' identified by 'maxgauge';

FLUSH PRIVILEGES;


확인


Mysql –h (접속IP) –p(포트번호) –u root –p

'Database' 카테고리의 다른 글

MySQL 옵션 변경  (0) 2016.08.24
MySQL 설치 (우분투)  (0) 2016.08.17
MySQL 설치(CentOS)  (0) 2016.08.17

확인[편집]

root@zetawiki:~# cat /etc/init.d/mysql
cat: /etc/init.d/mysql: No such file or directory

root@zetawiki:~# dpkg -l | grep mysql-server
root@zetawiki:~# aptitude show mysql-server | grep ^State
State: not installed

설치[편집]

root@zetawiki:~# apt-get install mysql-server
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following extra packages will be installed:
  libaio1 libdbd-mysql-perl libdbi-perl libhtml-template-perl libmysqlclient18
  mysql-client-5.5 mysql-client-core-5.5 mysql-common mysql-server-5.5
  mysql-server-core-5.5
Suggested packages:
  libclone-perl libmldbm-perl libnet-daemon-perl libplrpc-perl
  libsql-statement-perl libipc-sharedcache-perl tinyca mailx
The following NEW packages will be installed:
  libaio1 libdbd-mysql-perl libdbi-perl libhtml-template-perl libmysqlclient18
  mysql-client-5.5 mysql-client-core-5.5 mysql-common mysql-server
  mysql-server-5.5 mysql-server-core-5.5
0 upgraded, 11 newly installed, 0 to remove and 31 not upgraded.
Need to get 9,302 kB of archives.
After this operation, 96.6 MB of additional disk space will be used.
Do you want to continue? [Y/n]

... (생략)
New password for the MySQL "root" user:
→ MySQL의 root 계정 패스워드 지정
Repeat password for the MySQL "root" user:
→ MySQL의 root 계정 패스워드 재입력
... (생략)
160315 17:44:19 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
160315 17:44:19 [Note] /usr/sbin/mysqld (mysqld 5.5.47-0ubuntu0.14.04.1) starting as process 4054 ...
mysql start/running, process 4217
Setting up libhtml-template-perl (2.95-1) ...
Processing triggers for ureadahead (0.100.0-16) ...
Setting up mysql-server (5.5.47-0ubuntu0.14.04.1) ...
Processing triggers for libc-bin (2.19-0ubuntu6.6) ...

확인[편집]

root@zetawiki:~# /etc/init.d/mysql status
 * /usr/bin/mysqladmin  Ver 8.42 Distrib 5.5.47, for debian-linux-gnu on x86_64
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Server version		5.5.47-0ubuntu0.14.04.1
Protocol version	10
Connection		Localhost via UNIX socket
UNIX socket		/var/run/mysqld/mysqld.sock
Uptime:			1 min 55 sec

Threads: 1  Questions: 584  Slow queries: 0  Opens: 189  Flush tables: 1  Open tables: 41  Queries per second avg: 5.078

root@zetawiki:~# netstat -ntlp | grep mysqld
tcp        0      0 127.0.0.1:3306          0.0.0.0:*               LISTEN      4217/mysqld

root@zetawiki:~# mysql -uroot -pP@ssw0rd -e'show databases'
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
+--------------------+


'Database' 카테고리의 다른 글

MySQL 옵션 변경  (0) 2016.08.24
[AWS] MySQL 설치  (0) 2016.08.22
MySQL 설치(CentOS)  (0) 2016.08.17 
rpm -qa | grep ^mysql-server
yum install mysql-server
service mysqld start


root 패스워드 변경

/usr/bin/mysqladmin -u root password 'maxgauge'
또는 update user set password=password('new-password') where user='root';
mysql -uroot -p


원격접속 허용

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' identified by 'maxgauge';

FLUSH PRIVILEGES;


부팅시 자동시작 설정

chkconfig --list mysqld
chkconfig mysqld on
chkconfig --list mysqld


'Database' 카테고리의 다른 글

MySQL 옵션 변경  (0) 2016.08.24
[AWS] MySQL 설치  (0) 2016.08.22
MySQL 설치 (우분투)  (0) 2016.08.17

+ Recent posts

티스토리툴바