Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

Link zu dieser Vergleichsansicht

Beide Seiten der vorigen Revision Vorhergehende Überarbeitung
Nächste Überarbeitung
Vorhergehende Überarbeitung
centos:mariadb [20.02.2017 17:24. ]
django MariaDB [my.cnf] Konfigurationsvorschläge #MariaDB #CentOS7
centos:mariadb [20.04.2018 09:08. ] (aktuell)
Zeile 192: Zeile 192:
 ==== erster Start ==== ==== erster Start ====
 Nun ist es an der Zeit unseren Datenbank-Server das erste mal zu starten. Nun ist es an der Zeit unseren Datenbank-Server das erste mal zu starten.
-   # systemctl start mariadb+   # systemctl start mariadb.service
  
 Der Start wird im Logfile des Datenbankservers //​**/​var/​log/​mariadb/​mariadb.log**//​ entsprechend dokumentiert. Der Start wird im Logfile des Datenbankservers //​**/​var/​log/​mariadb/​mariadb.log**//​ entsprechend dokumentiert.
    # less /​var/​log/​mariadb/​mariadb.log    # less /​var/​log/​mariadb/​mariadb.log
-<​code>​150307 22:10:14 mysqld_safe Starting mysqld daemon with databases from /​var/​lib/​mysql/data +<​code>​170220 18:25:10 mysqld_safe Starting mysqld daemon with databases from /​var/​lib/​mysql 
-150307 22:10:14 InnoDB: The InnoDB memory heap is disabled +170220 18:25:10 [Note] /​usr/​libexec/​mysqld (mysqld 5.5.52-MariaDB) starting as process 3256 ... 
-150307 22:10:14 InnoDB: Mutexes and rw_locks use GCC atomic builtins +170220 18:25:10 InnoDB: The InnoDB memory heap is disabled 
-150307 22:10:14 InnoDB: Compressed tables use zlib 1.2.7 +170220 18:25:10 InnoDB: Mutexes and rw_locks use GCC atomic builtins 
-150307 22:10:14 InnoDB: Using Linux native AIO +170220 18:25:10 InnoDB: Compressed tables use zlib 1.2.7 
-150307 22:10:14 InnoDB: Initializing buffer pool, size = 128.0M +170220 18:25:10 InnoDB: Using Linux native AIO 
-150307 22:10:14 InnoDB: Completed initialization of buffer pool+170220 18:25:10 InnoDB: Initializing buffer pool, size = 128.0M 
 +170220 18:25:10 InnoDB: Completed initialization of buffer pool
 InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: The first specified data file ./ibdata1 did not exist:
 InnoDB: a new database to be created! InnoDB: a new database to be created!
-150307 22:10:14  ​InnoDB:​ Setting file ./ibdata1 size to 10 MB+170220 18:25:10  ​InnoDB:​ Setting file ./ibdata1 size to 10 MB
 InnoDB: Database physically writes the file full: wait... InnoDB: Database physically writes the file full: wait...
-150307 22:10:14  ​InnoDB:​ Log file ./​ib_logfile0 did not exist: new to be created+170220 18:25:10  ​InnoDB:​ Log file ./​ib_logfile0 did not exist: new to be created
 InnoDB: Setting log file ./​ib_logfile0 size to 5 MB InnoDB: Setting log file ./​ib_logfile0 size to 5 MB
 InnoDB: Database physically writes the file full: wait... InnoDB: Database physically writes the file full: wait...
-150307 22:10:14  ​InnoDB:​ Log file ./​ib_logfile1 did not exist: new to be created+170220 18:25:10  ​InnoDB:​ Log file ./​ib_logfile1 did not exist: new to be created
 InnoDB: Setting log file ./​ib_logfile1 size to 5 MB InnoDB: Setting log file ./​ib_logfile1 size to 5 MB
 InnoDB: Database physically writes the file full: wait... InnoDB: Database physically writes the file full: wait...
Zeile 218: Zeile 219:
 InnoDB: Creating foreign key constraint system tables InnoDB: Creating foreign key constraint system tables
 InnoDB: Foreign key constraint system tables created InnoDB: Foreign key constraint system tables created
-150307 22:10:15  ​InnoDB:​ Waiting for the background threads to start +170220 18:25:11  ​InnoDB:​ Waiting for the background threads to start 
-150307 22:10:16 Percona XtraDB (http://​www.percona.com) 5.5.40-MariaDB-36.started; log sequence number 0 +170220 18:25:12 Percona XtraDB (http://​www.percona.com) 5.5.49-MariaDB-38.started; log sequence number 0 
-150307 22:10:16 [Note] Plugin '​FEEDBACK'​ is disabled. +170220 18:25:12 [Note] Plugin '​FEEDBACK'​ is disabled. 
-150307 22:10:16 [Note] Server socket created on IP: '​0.0.0.0'​. +170220 18:25:12 [Note] Server socket created on IP: '​0.0.0.0'​. 
-150307 22:10:16 [Note] Event Scheduler: Loaded 0 events +170220 18:25:12 [Note] Event Scheduler: Loaded 0 events 
-150307 22:10:16 [Note] /​usr/​libexec/​mysqld:​ ready for connections. +170220 18:25:12 [Note] /​usr/​libexec/​mysqld:​ ready for connections. 
-Version: '5.5.41-MariaDB' ​ socket: '/​var/​lib/​mysql/​mysql.sock' ​ port: 3306  MariaDB Server+Version: '5.5.52-MariaDB' ​ socket: '/​var/​lib/​mysql/​mysql.sock' ​ port: 3306  MariaDB Server
 </​code>​ </​code>​
  
Zeile 245: Zeile 246:
  
 Möchten wir überprüfen,​ ob der MariaDB-Server läuft, haben wir mehrere Möglichkeiten. Möchten wir überprüfen,​ ob der MariaDB-Server läuft, haben wir mehrere Möglichkeiten.
-  - **systemctl** \\ <​code>​ # systemctl status mariadb -l</​code><​code>​mariadb.service - MariaDB database server +  - **systemctl** \\ <​code>​ # systemctl status mariadb -l</​code>​ <html><​pre class="​code">​ 
-   ​Loaded:​ loaded (/​usr/​lib/​systemd/​system/​mariadb.service;​ disabled) +<font style="​color:​ rgb(0, 255, 0)"><​b>​● </​b></​font><​font style="​color:​ rgb(0, 0, 0)">​mariadb.service - MariaDB database server 
-   ​Active:​ active (running) since Sat 2015-03-07 22:10:17 CET; 27min ago +   ​Loaded:​ loaded (/​usr/​lib/​systemd/​system/​mariadb.service; ​disabled; vendor preset: ​disabled) 
-  Process: ​27040 ExecStartPost=/​usr/​libexec/​mariadb-wait-ready $MAINPID (code=exited,​ status=0/​SUCCESS) +   ​Active: ​<font style="​color:​ rgb(0, 255, 0)"><​b>​active (running) ​</​b></​font><​font style="​color:​ rgb(0, 0, 0)">​since Mon 2017-02-20 18:25:12 CET; 1min 6s ago 
-  Process: ​26961 ExecStartPre=/​usr/​libexec/​mariadb-prepare-db-dir %n (code=exited,​ status=0/​SUCCESS) +  Process: ​3099 ExecStartPost=/​usr/​libexec/​mariadb-wait-ready $MAINPID (code=exited,​ status=0/​SUCCESS) 
- Main PID: 27039 (mysqld_safe)+  Process: ​3019 ExecStartPre=/​usr/​libexec/​mariadb-prepare-db-dir %n (code=exited,​ status=0/​SUCCESS) 
 + Main PID: 3098 (mysqld_safe)
    ​CGroup:​ /​system.slice/​mariadb.service    ​CGroup:​ /​system.slice/​mariadb.service
-           ​├─27039 /bin/sh /​usr/​bin/​mysqld_safe --basedir=/​usr +           ​├─3098 /bin/sh /​usr/​bin/​mysqld_safe --basedir=/​usr 
-           ​└─27198 /​usr/​libexec/​mysqld --basedir=/​usr --datadir=/​var/​lib/​mysql/data --plugin-dir=/​usr/​lib64/​mysql/​plugin --log-error=/​var/​log/​mariadb/​mariadb.log --pid-file=/​var/​run/​mariadb/​mariadb.pid --socket=/​var/​lib/​mysql/​mysql.sock+           ​└─3256 /​usr/​libexec/​mysqld --basedir=/​usr --datadir=/​var/​lib/​mysql --plugin-dir=/​usr/​lib64/​mysql/​plugin --log-error=/​var/​log/​mariadb/​mariadb.log --pid-file=/​var/​run/​mariadb/​mariadb.pid --socket=/​var/​lib/​mysql/​mysql.sock
  
-Mar 07 22:10:13 vml000117.dmz.nausch.org mariadb-prepare-db-dir[26961]: The latest information about MariaDB is available ​at http://​mariadb.org/​. +Feb 20 18:25:10 vml000117.dmz.nausch.org mariadb-prepare-db-dir[3019]: To start mysqld ​at boot time you have to copy 
-Mar 07 22:10:13 vml000117.dmz.nausch.org mariadb-prepare-db-dir[26961]: You can find additional information about the MySQL part at: +Feb 20 18:25:10 vml000117.dmz.nausch.org mariadb-prepare-db-dir[3019]: support-files/​mysql.server to the right place for your system 
-Mar 07 22:10:13 vml000117.dmz.nausch.org mariadb-prepare-db-dir[26961]: http://​dev.mysql.com +Feb 20 18:25:10 vml000117.dmz.nausch.org mariadb-prepare-db-dir[3019]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER ! 
-Mar 07 22:10:13 vml000117.dmz.nausch.org mariadb-prepare-db-dir[26961]: Support MariaDB development by buying support/new features from MariaDB +Feb 20 18:25:10 vml000117.dmz.nausch.org mariadb-prepare-db-dir[3019]: To do so, start the server, then issue the following commands: 
-Mar 07 22:10:13 vml000117.dmz.nausch.org mariadb-prepare-db-dir[26961]: Corporation Ab. You can contact us about this at sales@mariadb.com. +Feb 20 18:25:10 vml000117.dmz.nausch.org mariadb-prepare-db-dir[3019]: '/​usr/​bin/​mysqladmin'​ -u root password '​new-password'​ 
-Mar 07 22:10:13 vml000117.dmz.nausch.org mariadb-prepare-db-dir[26961]: Alternatively consider joining our community based development effort: +Feb 20 18:25:10 vml000117.dmz.nausch.org mariadb-prepare-db-dir[3019]: '/​usr/​bin/​mysqladmin'​ -u root -h vml000117.dmz.nausch.org password '​new-password'​ 
-Mar 07 22:10:13 vml000117.dmz.nausch.org mariadb-prepare-db-dir[26961]: http://​mariadb.com/​kb/​en/​contributing-to-the-mariadb-project/​ +Feb 20 18:25:10 vml000117.dmz.nausch.org mariadb-prepare-db-dir[3019]: Alternatively you can run
-Mar 07 22:10:14 vml000117.dmz.nausch.org mysqld_safe[27039]: 150307 22:10:14 mysqld_safe Logging to '/​var/​log/​mariadb/​mariadb.log'​. +Feb 20 18:25:10 vml000117.dmz.nausch.org mysqld_safe[3098]: 170220 18:25:10 mysqld_safe Logging to '/​var/​log/​mariadb/​mariadb.log'​. 
-Mar 07 22:10:14 vml000117.dmz.nausch.org mysqld_safe[27039]: 150307 22:10:14 mysqld_safe Starting mysqld daemon with databases from /​var/​lib/​mysql +Feb 20 18:25:10 vml000117.dmz.nausch.org mysqld_safe[3098]: 170220 18:25:10 mysqld_safe Starting mysqld daemon with databases from /​var/​lib/​mysql 
-Mar 07 22:10:17 vml000117.dmz.nausch.org systemd[1]: Started MariaDB database server.</​code>+Feb 20 18:25:12 vml000117.dmz.nausch.org systemd[1]: Started MariaDB database server.</​font> 
 +</​pre></​html>
   - **ps** \\ <​code>​ # ps aux | grep mysql</​code><​code>​mysql ​   27039  0.0  0.1 115344 ​ 1620 ?        Ss   ​22:​10 ​  0:00 /bin/sh /​usr/​bin/​mysqld_safe --basedir=/​usr   - **ps** \\ <​code>​ # ps aux | grep mysql</​code><​code>​mysql ​   27039  0.0  0.1 115344 ​ 1620 ?        Ss   ​22:​10 ​  0:00 /bin/sh /​usr/​bin/​mysqld_safe --basedir=/​usr
 mysql    27198  0.0  8.3 905348 84784 ?        Sl   ​22:​10 ​  0:01 /​usr/​libexec/​mysqld --basedir=/​usr --datadir=/​var/​lib/​mysql/​data --plugin-dir=/​usr/​lib64/​mysql/​plugin --log-error=/​var/​log/​mariadb/​mariadb.log --pid-file=/​var/​run/​mariadb/​mariadb.pid --socket=/​var/​lib/​mysql/​mysql.sock mysql    27198  0.0  8.3 905348 84784 ?        Sl   ​22:​10 ​  0:01 /​usr/​libexec/​mysqld --basedir=/​usr --datadir=/​var/​lib/​mysql/​data --plugin-dir=/​usr/​lib64/​mysql/​plugin --log-error=/​var/​log/​mariadb/​mariadb.log --pid-file=/​var/​run/​mariadb/​mariadb.pid --socket=/​var/​lib/​mysql/​mysql.sock
Zeile 1030: Zeile 1033:
   * **[[http://​dokuwiki.nausch.org/​doku.php/​|Zurück zur Startseite]]**   * **[[http://​dokuwiki.nausch.org/​doku.php/​|Zurück zur Startseite]]**
  
-~~DISCUSSION~~ 
 ~~AUTOTWEET:​~~ ~~AUTOTWEET:​~~
 +
  • centos/mariadb.txt
  • Zuletzt geändert: 20.04.2018 09:08.
  • (Externe Bearbeitung)