/etc/systemd/system/mariadb.service에서 mariadb의 서비스를 정의했습니다.
[Unit]
Description=start and stop MySQL(MariaDB) Server
After=syslog.target
After=network.target
[Service]
Type=simple
User=Umariadb
Group=Gmariadb
# Restart=always
# PermissionsStartOnly=true
ExecStart=/usr/local/ServerWeb/mariadb/bin/mysqld_safe --user=mysql --ledir=/usr/local/ServerWeb/mariadb/bin --datadir=/usr/local/ServerWeb/mariadb/data
# ExecStop=/usr/bin/vgaoff stop
TimeoutSec=300
PrivateTmp=true
[Install]
WantedBy=multi-user.target
나중에 활성화했습니다.
systemctl enable mariadb.service
이제 다시 시작한 후 서비스가시작하지 않음.
그런 다음 서비스를 다시 비활성화해야 합니다.
수동으로 다시 시도해보니 잘 되더라구요...
sudo /usr/local/ServerWeb/mariadb/bin/mysqld_safe --user=mysql --ledir=/usr/local/ServerWeb/mariadb/bin --datadir=/usr/local/ServerWeb/mariadb/data
내 서비스 스크립트가 잘 정의되어 있나요?
문제가 무엇인지 알고 싶습니다. 어떻게 해결하나요?
편집하다:
$ sudo /usr/local/ServerWeb/mariadb/bin/mysqld_safe --user=mysql --ledir=/usr/local/ServerWeb/mariadb/bin --datadir=/usr/local/ServerWeb/mariadb/data
[sudo] password for joseluisbz:
170308 19:54:07 mysqld_safe Logging to '/usr/local/ServerWeb/mariadb/data/server.err'.
파일 내부
170308 19:54:07 mysqld_safe Starting mysqld daemon with databases from /usr/local/ServerWeb/mariadb/data
2017-03-08 19:54:07 140588539000704 [Note] /usr/local/ServerWeb/mariadb/bin/mysqld (mysqld 10.1.20-MariaDB) starting as process 4411 ...
2017-03-08 19:54:07 140588539000704 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-03-08 19:54:07 140588539000704 [Note] InnoDB: The InnoDB memory heap is disabled
2017-03-08 19:54:07 140588539000704 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-03-08 19:54:07 140588539000704 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2017-03-08 19:54:07 140588539000704 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-03-08 19:54:07 140588539000704 [Note] InnoDB: Using Linux native AIO
2017-03-08 19:54:07 140588539000704 [Note] InnoDB: Using SSE crc32 instructions
2017-03-08 19:54:07 140588539000704 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-03-08 19:54:07 140588539000704 [Note] InnoDB: Completed initialization of buffer pool
2017-03-08 19:54:07 140588539000704 [Note] InnoDB: Highest supported file format is Barracuda.
2017-03-08 19:54:07 140588539000704 [Note] InnoDB: 128 rollback segment(s) are active.
2017-03-08 19:54:07 140588539000704 [Note] InnoDB: Waiting for purge to start
2017-03-08 19:54:07 140588539000704 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 1622938
2017-03-08 19:54:07 140588539000704 [Note] Plugin 'FEEDBACK' is disabled.
2017-03-08 19:54:07 140587999135488 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-03-08 19:54:07 140588539000704 [Note] Server socket created on IP: '::'.
2017-03-08 19:54:08 140588539000704 [Note] /usr/local/ServerWeb/mariadb/bin/mysqld: ready for connections.
Version: '10.1.20-MariaDB' socket: '/tmp/mysql.sock' port: 3306 MariaDB Server
사용성 테스트...
[joseluisbz@Vxbox-Lnx ~]$ mysql -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 2
Server version: 10.1.20-MariaDB MariaDB Server
Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>
리눅스를 종료하세요...
2017-03-08 19:59:29 140588538443520 [Note] /usr/local/ServerWeb/mariadb/bin/mysqld: Normal shutdown
2017-03-08 19:59:29 140588538443520 [Note] Event Scheduler: Purging the queue. 0 events
2017-03-08 19:59:29 140587982350080 [Note] InnoDB: FTS optimize thread exiting.
2017-03-08 19:59:29 140588538443520 [Note] InnoDB: Starting shutdown...
2017-03-08 19:59:31 140588538443520 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2017-03-08 19:59:32 140588538443520 [Note] InnoDB: Shutdown completed; log sequence number 1622948
2017-03-08 19:59:32 140588538443520 [Note] /usr/local/ServerWeb/mariadb/bin/mysqld: Shutdown complete
170308 19:59:32 mysqld_safe mysqld from pid file /usr/local/ServerWeb/mariadb/data/Vxbox-Lnx.pid ended
지금은 서비스가 있어요...
$ sudo systemctl enable mariadb.service
[sudo] password for joseluisbz:
Created symlink from /etc/systemd/system/multi-user.target.wants/mariadb.service to /etc/systemd/system/mariadb.service.
[joseluisbz@Vxbox-Lnx ~]$
조사하다...
[joseluisbz@Vxbox-Lnx ~]$ sudo service mariadb start
[sudo] password for joseluisbz:
Redirecting to /bin/systemctl start mariadb.service
[joseluisbz@Vxbox-Lnx ~]$ mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[joseluisbz@Vxbox-Lnx ~]$
상태
$ sudo systemctl status mariadb.service
[sudo] password for joseluisbz:
● mariadb.service - start and stop MySQL(MariaDB) Server
Loaded: loaded (/etc/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Active: failed (Result: exit-code) since Wed 2017-03-08 20:09:47 COT; 5min ago
Process: 4556 ExecStart=/usr/local/ServerWeb/mariadb/bin/mysqld_safe --user=mysql --ledir=/usr/local/ServerWeb/mariadb/bin --datadir=/usr/local/ServerWeb/mariadb/data (code=exited, status=1/FAILURE)
Main PID: 4556 (code=exited, status=1/FAILURE)
Mar 08 20:09:47 Vxbox-Lnx systemd[1]: Started start and stop MySQL(MariaDB) Server.
Mar 08 20:09:47 Vxbox-Lnx systemd[1]: Starting start and stop MySQL(MariaDB) Server...
Mar 08 20:09:47 Vxbox-Lnx mysqld_safe[4556]: 170308 20:09:47 mysqld_safe Logging to '/usr/local/ServerWeb/mariadb/data/server.err'.
Mar 08 20:09:47 Vxbox-Lnx systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
Mar 08 20:09:47 Vxbox-Lnx systemd[1]: Unit mariadb.service entered failed state.
Mar 08 20:09:47 Vxbox-Lnx systemd[1]: mariadb.service failed.
[joseluisbz@Vxbox-Lnx ~]$
또 다른 수표
$ sudo systemctl --failed
[sudo] password for joseluisbz:
UNIT LOAD ACTIVE SUB DESCRIPTION
● kdump.service loaded failed failed Crash recovery kernel arming
● mariadb.service loaded failed failed start and stop MySQL(MariaDB) Server
LOAD = Reflects whether the unit definition was properly loaded.
ACTIVE = The high-level unit activation state, i.e. generalization of SUB.
SUB = The low-level unit activation state, values depend on unit type.
2 loaded units listed. Pass --all to see loaded but inactive units, too.
To show all installed unit files use 'systemctl list-unit-files'.
[joseluisbz@Vxbox-Lnx ~]$
답변1
사용하지 마세요 mysqld_safe.
모든 종류의 문제에 직면하게 되지만 궁극적으로 문제는 경쟁자를 구축하고 이 분야에서 자리를 차지하는 것과 관련이 있습니다.시스템화 된 공포의 집서비스 관리자 아래에서 Poor Man's Dæmon Supervisor(셸 스크립트로 제대로 작성되지 않음)를 실행합니다. 더 나은 상호 운용성을 위해 힘들게 확인하고 조정하고, 준비 프로토콜 불일치를 처리하고, 서로 다른 두 장소에서 서로 다른 방식으로 설정하는 충돌로 끝날 수 있지만 실제로는 의미가 없습니다. 대신 daemontools 세계에서 배우십시오.mysqld_safe 사라졌다세기의 전환기부터.
몇 년이 지나면 시스템 세계에서도 벗어날 수 있습니다. Oracle 및 MySQL 세계와 달리 MariaDB 세계의 한 가지 차이점은 mysqld_safe서비스를 서비스로 사용하는 대신 daemontools/runit/s6 사용자가 수년 동안 원했던 방식으로 MariaDB를 실행하는 방법에 대한 좋은 문서가 실제로 있다는 것입니다. 관리를 위한 도구 세트입니다.
마리아 데이터베이스함께 제공mariadb.servicesystemd용 서비스 단위 및 설정을 systemd 서비스 단위 설정으로 mariadb-service-convert마이그레이션 하는 도구입니다. 사용자가 여러 서버를 서로 다른 서비스로 실행할 수 있는 서비스 단위 템플릿 my.cnf도 함께 제공됩니다 . [email protected]그것들을 사용하세요.
추가 읽기
- 조나단 데보인 폴라드(2015). 시스템화 된 공포의 집. 자주 주어지는 답변입니다.
- 조나단 데보인 폴라드(2016).nosh를 사용하는 MariaDB 및 MySQL. 소프트웨어.
- "체계". MariaDB 시작 및 중지. 지식 기반. 마리아 데이터베이스. 2016.
- "MariaDB 자동 시작 및 중지". MariaDB 시작 및 중지. 지식 기반. 마리아 데이터베이스. 2016.
답변2
내 설치 과정은 (묻기 전)
sudo tar zxvf /media/sf_Users/josebernal/Downloads/Php\ Tomcat\ Httpd\ MySQL/mariadb-10.1.20-linux-x86_64.tar.gz -C /usr/local/
sudo ln -s /usr/local/mariadb-10.1.20-linux-x86_64 /usr/local/ServerWeb/mariadb
sudo groupadd -r Gmariadb
sudo useradd -g Gmariadb -c "MariaDB User" -s /sbin/nologin -r Umariadb
sudo chown -R Umariadb:Gmariadb /usr/local/ServerWeb/mariadb/
sudo cp /usr/local/ServerWeb/mariadb/support-files/my-small.cnf /etc/my.cnf
... EDIT the config mariadb (mysql) file named my.cnf
sudo /usr/local/ServerWeb/mariadb/scripts/mysql_install_db --user=mysql --basedir=/usr/local/ServerWeb/mariadb --datadir=/usr/local/ServerWeb/mariadb/data --log-error=/usr/local/ServerWeb/mariadb/data/server.err &
....
... The next steps..
문제를 신고(질문)하기 전에도 소유권을 확인했는데…
[joseluisbz@Vxbox-Lnx ~]$ ls -al /usr/local/ServerWeb/mariadb/
total 224
drwxrwxr-x 13 Umariadb Gmariadb 4096 Dec 14 23:27 .
drwxr-xr-x. 18 root root 4096 Jan 5 12:00 ..
drwxrwxr-x 2 Umariadb Gmariadb 4096 Nov 18 15:03 bin
-rw-r--r-- 1 Umariadb Gmariadb 17987 Dec 14 14:25 COPYING
-rw-r--r-- 1 Umariadb Gmariadb 26545 Dec 14 14:25 COPYING.LESSER
-rw-r--r-- 1 Umariadb Gmariadb 86259 Dec 14 14:25 COPYING.thirdparty
-rw-r--r-- 1 Umariadb Gmariadb 2122 Dec 14 14:25 CREDITS
drwxrwxr-x 4 mysql Gmariadb 4096 Mar 8 20:25 data
drwxrwxr-x 2 Umariadb Gmariadb 30 Dec 14 23:26 DESTINATION
-rw-r--r-- 1 Umariadb Gmariadb 8245 Dec 14 14:25 EXCEPTIONS-CLIENT
drwxrwxr-x 3 Umariadb Gmariadb 18 Dec 14 23:26 include
-rw-r--r-- 1 Umariadb Gmariadb 8694 Dec 14 14:25 INSTALL-BINARY
drwxrwxr-x 4 Umariadb Gmariadb 4096 Nov 18 15:03 lib
drwxrwxr-x 4 Umariadb Gmariadb 28 Dec 14 23:27 man
drwxrwxr-x 11 Umariadb Gmariadb 4096 Dec 14 23:26 mysql-test
-rw-r--r-- 1 Umariadb Gmariadb 2105 Dec 14 14:25 README
-rw-r--r-- 1 Umariadb Gmariadb 19510 Dec 14 14:25 README-wsrep
drwxrwxr-x 2 Umariadb Gmariadb 29 Dec 14 23:27 scripts
drwxrwxr-x 29 Umariadb Gmariadb 4096 Dec 14 23:26 share
drwxrwxr-x 4 Umariadb Gmariadb 4096 Dec 14 23:27 sql-bench
drwxrwxr-x 3 Umariadb Gmariadb 4096 Jan 4 22:32 support-files
설치 후 소유권이 (mysql:mysql)에 속해 있음을 데이터 폴더에서 확인했지만 서비스 스크립트 문제(mariadb.service)인 것 같습니다...
[joseluisbz@Vxbox-Lnx ~]$ ls -al /usr/local/ServerWeb/mariadb/data/
total 110624
drwxrwxr-x 4 mysql Gmariadb 4096 Mar 8 20:25 .
drwxrwxr-x 13 Umariadb Gmariadb 4096 Dec 14 23:27 ..
-rw-rw---- 1 mysql mysql 16384 Mar 8 19:59 aria_log.00000001
-rw-rw---- 1 mysql mysql 52 Mar 8 19:59 aria_log_control
-rw-rw---- 1 mysql mysql 12582912 Mar 8 19:59 ibdata1
-rw-rw---- 1 mysql mysql 50331648 Mar 8 19:59 ib_logfile0
-rw-rw---- 1 mysql mysql 50331648 Jan 4 22:01 ib_logfile1
-rw-rw---- 1 mysql mysql 0 Jan 4 22:05 multi-master.info
drwx------ 2 mysql root 4096 Jan 4 22:01 mysql
drwx------ 2 mysql mysql 19 Jan 4 22:01 performance_schema
-rw-rw---- 1 mysql mysql 0 Mar 8 20:04 server.err
[joseluisbz@Vxbox-Lnx ~]$
@Kalavan이 소유권에 대한 의심을 확인했고, 설치 과정 후에 소유권을 변경해야 합니다...
sudo chown -R Umariadb:Gmariadb /usr/local/ServerWeb/mariadb/
CentOS 7을 다시 시작했는데 서비스가 정상적으로 실행되고 있습니다! ! !
로그 파일을 확인해보니/usr/local/ServerWeb/mariadb/data/server.err..
170308 20:36:23 mysqld_safe Starting mysqld daemon with databases from /usr/local/ServerWeb/mariadb/data
2017-03-08 20:36:23 140485189175168 [Note] /usr/local/ServerWeb/mariadb/bin/mysqld (mysqld 10.1.20-MariaDB) starting as process 2360 ...
2017-03-08 20:36:24 140485189175168 [Warning] One can only use the --user switch if running as root
2017-03-08 20:36:24 140485189175168 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-03-08 20:36:24 140485189175168 [Note] InnoDB: The InnoDB memory heap is disabled
2017-03-08 20:36:24 140485189175168 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-03-08 20:36:24 140485189175168 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2017-03-08 20:36:24 140485189175168 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-03-08 20:36:24 140485189175168 [Note] InnoDB: Using Linux native AIO
2017-03-08 20:36:24 140485189175168 [Note] InnoDB: Using SSE crc32 instructions
2017-03-08 20:36:24 140485189175168 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-03-08 20:36:24 140485189175168 [Note] InnoDB: Completed initialization of buffer pool
2017-03-08 20:36:24 140485189175168 [Note] InnoDB: Highest supported file format is Barracuda.
2017-03-08 20:36:24 140485189175168 [Note] InnoDB: 128 rollback segment(s) are active.
2017-03-08 20:36:24 140485189175168 [Note] InnoDB: Waiting for purge to start
2017-03-08 20:36:24 140485189175168 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 1622948
2017-03-08 20:36:25 140485189175168 [Note] Plugin 'FEEDBACK' is disabled.
2017-03-08 20:36:25 140484651484928 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-03-08 20:36:25 140485189175168 [Note] Server socket created on IP: '::'.
2017-03-08 20:36:25 140485189175168 [Note] /usr/local/ServerWeb/mariadb/bin/mysqld: ready for connections.
Version: '10.1.20-MariaDB' socket: '/tmp/mysql.sock' port: 3306 MariaDB Server
PID 확인
[joseluisbz@Vxbox-Lnx ~]$ ps -aux | grep mariadb
mysql 1652 0.0 0.1 113264 1656 ? Ss 11:42 0:00 /bin/sh /usr/local/ServerWeb/mariadb/bin/mysqld_safe --user=mysql --ledir=/usr/local/ServerWeb/mariadb/bin --datadir=/usr/local/ServerWeb/mariadb/data
mysql 2458 0.2 5.6 591028 87172 ? Sl 11:42 0:00 /usr/local/ServerWeb/mariadb/bin/mysqld --basedir=/usr/local/ServerWeb/mariadb --datadir=/usr/local/ServerWeb/mariadb/data --plugin-dir=/usr/local/ServerWeb/mariadb/lib/plugin --log-error=/usr/local/ServerWeb/mariadb/data/server.err --pid-file=Vxbox-Lnx.pid --socket=/tmp/mysql.sock --port=3306
joselui+ 4489 0.0 0.0 112652 964 pts/0 R+ 11:44 0:00 grep --color=auto mariadb
[joseluisbz@Vxbox-Lnx ~]$
mariadb가 효율적으로 실행되고 있습니다!
상태를 확인해보니
$ sudo systemctl status mariadb.service
[sudo] password for joseluisbz:
● mariadb.service - start and stop MySQL(MariaDB) Server
Loaded: loaded (/etc/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Active: active (running) since Fri 2017-03-10 11:42:07 COT; 17min ago
Main PID: 1652 (mysqld_safe)
CGroup: /system.slice/mariadb.service
├─1652 /bin/sh /usr/local/ServerWeb/mariadb/bin/mysqld_safe --user=mysql --ledir=/usr/local/ServerWeb/mariadb/bin --datadir=/usr/local/ServerWeb/mariadb/data...
└─2458 /usr/local/ServerWeb/mariadb/bin/mysqld --basedir=/usr/local/ServerWeb/mariadb --datadir=/usr/local/ServerWeb/mariadb/data --plugin-dir=/usr/local/Ser...
Mar 10 11:42:07 Vxbox-Lnx systemd[1]: Started start and stop MySQL(MariaDB) Server.
Mar 10 11:42:07 Vxbox-Lnx systemd[1]: Starting start and stop MySQL(MariaDB) Server...
Mar 10 11:42:09 Vxbox-Lnx mysqld_safe[1652]: 170310 11:42:09 mysqld_safe Logging to '/usr/local/ServerWeb/mariadb/data/server.err'.
[joseluisbz@Vxbox-Lnx ~]$
하지만연결할 수 없습니다! !
$ sudo mysql -u root -p
[sudo] password for joseluisbz:
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[joseluisbz@Vxbox-Lnx ~]$
존재하는지 확인해요mysql.sock문서화(그러나 아니오)...
# ls -al /tmp/
total 24
drwxrwxrwt. 22 root root 4096 Mar 10 12:28 .
dr-xr-xr-x. 19 root root 4096 Feb 18 21:21 ..
drwx------ 2 joseluisbz joseluisbz 52 Mar 10 11:42 akonadi-joseluisbz.Fim4n9
drwx------ 2 joseluisbz joseluisbz 50 Mar 10 09:20 .com.google.Chrome.I956Ja
drwx------ 2 joseluisbz joseluisbz 50 Mar 10 07:38 .com.google.Chrome.ibPaUS
drwx------ 2 joseluisbz joseluisbz 50 Mar 9 07:31 .com.google.Chrome.oIW6st
drwx------ 2 joseluisbz joseluisbz 50 Mar 8 19:22 .com.google.Chrome.pGYMUt
drwx------. 2 joseluisbz joseluisbz 19 Mar 10 11:42 .esd-1000
drwxrwxrwt. 2 root root 6 Oct 10 20:09 .font-unix
prw------- 1 root root 0 Mar 10 11:42 hogsuspend
drwxrwxrwt. 2 root root 4096 Mar 10 11:42 .ICE-unix
drwx------. 2 joseluisbz joseluisbz 50 Mar 10 12:25 kde-joseluisbz
drwx------ 2 root root 23 Mar 10 11:44 kde-root
drwx------ 2 root root 4096 Mar 10 11:44 ksocket-root
drwx------ 2 joseluisbz joseluisbz 23 Mar 10 11:42 ssh-aOJwbK0vltXX
drwx------ 3 root root 16 Mar 10 11:42 systemd-private-65b25dd58edd4711ad864dc007925904-colord.service-EVVMql
drwx------ 3 root root 16 Mar 10 11:42 systemd-private-65b25dd58edd4711ad864dc007925904-cups.service-jOD1sm
drwx------ 3 root root 16 Mar 10 11:42 systemd-private-65b25dd58edd4711ad864dc007925904-mariadb.service-eioofZ
drwx------ 3 root root 16 Mar 9 15:11 systemd-private-65b25dd58edd4711ad864dc007925904-rtkit-daemon.service-E5cH4Y
drwxrwxrwt. 2 root root 6 Oct 10 20:09 .Test-unix
drwx------. 2 joseluisbz joseluisbz 6 Oct 10 20:42 tracker-extract-files.1000
-r--r--r-- 1 root root 11 Mar 10 11:42 .X0-lock
drwxrwxrwt. 2 root root 24 Mar 10 11:42 .X11-unix
-rw------- 1 root root 54 Mar 10 08:35 xauth.XXXXTFUQeQ
drwxrwxrwt. 2 root root 6 Oct 10 20:09 .XIM-unix
[root@Vxbox-Lnx joseluisbz]#
그런 다음 구성 파일을 변경했습니다./etc/my.cnf소켓 위치를 변경하고 해당 위치의 소유권(각 사용자:그룹) 폴더를 결정합니다...
[client]
...
socket = /usr/local/ServerWeb/mariadb/tmp/mysql.sock
...
[mysqld]
...
socket = /usr/local/ServerWeb/mariadb/tmp/mysql.sock
...
소켓에 대한 tmp 폴더를 생성하고 소유권을 다시 확인했습니다!
sudo mkdir -pv /usr/local/ServerWeb/mariadb/tmp
sudo chown -R Umariadb:Gmariadb /usr/local/ServerWeb/mariadb/
나중에 변경하고 CentOS 7을 다시 시작하세요.
로그 파일 확인/usr/local/ServerWeb/mariadb/data/server.err..
170311 17:31:50 mysqld_safe Starting mysqld daemon with databases from /usr/local/ServerWeb/mariadb/data
2017-03-11 17:31:50 139805859948416 [Note] /usr/local/ServerWeb/mariadb/bin/mysqld (mysqld 10.1.20-MariaDB) starting as process 2187 ...
2017-03-11 17:31:51 139805859948416 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-03-11 17:31:51 139805859948416 [Note] InnoDB: The InnoDB memory heap is disabled
2017-03-11 17:31:51 139805859948416 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-03-11 17:31:51 139805859948416 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2017-03-11 17:31:51 139805859948416 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-03-11 17:31:51 139805859948416 [Note] InnoDB: Using Linux native AIO
2017-03-11 17:31:51 139805859948416 [Note] InnoDB: Using SSE crc32 instructions
2017-03-11 17:31:51 139805859948416 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-03-11 17:31:51 139805859948416 [Note] InnoDB: Completed initialization of buffer pool
2017-03-11 17:31:51 139805859948416 [Note] InnoDB: Highest supported file format is Barracuda.
2017-03-11 17:31:51 139805859948416 [Note] InnoDB: 128 rollback segment(s) are active.
2017-03-11 17:31:51 139805859948416 [Note] InnoDB: Waiting for purge to start
2017-03-11 17:31:51 139805859948416 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 1623144
2017-03-11 17:31:51 139805379786496 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-03-11 17:31:51 139805859948416 [Note] Plugin 'FEEDBACK' is disabled.
2017-03-11 17:31:51 139805859948416 [Note] Server socket created on IP: '::'.
2017-03-11 17:31:52 139805859948416 [Note] /usr/local/ServerWeb/mariadb/bin/mysqld: ready for connections.
Version: '10.1.20-MariaDB' socket: '/usr/local/ServerWeb/mariadb/tmp/mysql.sock' port: 3306 MariaDB Server
클라이언트 시작...
[joseluisbz@Vxbox-Lnx ~]$ mysql -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 2
Server version: 10.1.20-MariaDB MariaDB Server
Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>
완벽하게 작동합니다...
솔루션 이력서
- Umariadb로 소유권 변경: Gmariadb오직설치 후.
- user:group이 쓸 수 있는 소켓 위치를 변경합니다...
노트: 원본 파일/etc/systemd/system/mariadb.service괜찮아요!
답변3
이것은 나에게 효과적입니다.
mv /var/lib/mysql/* /opt/