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:22. ]
django [Installation] mariadb-server #sql #CentOS7
centos:mariadb [22.07.2019 14:52. ] (aktuell)
Zeile 175: Zeile 175:
 Zusätzliche Beispiele finden sich übrigens auch im Verzeichnis //**/usr/share/mysql/**//. Zusätzliche Beispiele finden sich übrigens auch im Verzeichnis //**/usr/share/mysql/**//.
    # ll /usr/share/mysql/*.cnf    # ll /usr/share/mysql/*.cnf
-<code>-rw-r--r--. 1 root root  4920 Feb  5 15:44 /usr/share/mysql/my-huge.cnf +<code>-rw-r--r--. 1 root root  4920 Nov 15 00:14 /usr/share/mysql/my-huge.cnf 
--rw-r--r--. 1 root root 20438 Feb  5 15:44 /usr/share/mysql/my-innodb-heavy-4G.cnf +-rw-r--r--. 1 root root 20438 Nov 15 00:14 /usr/share/mysql/my-innodb-heavy-4G.cnf 
--rw-r--r--. 1 root root  4907 Feb  5 15:44 /usr/share/mysql/my-large.cnf +-rw-r--r--. 1 root root  4907 Nov 15 00:14 /usr/share/mysql/my-large.cnf 
--rw-r--r--. 1 root root  4920 Feb  5 15:44 /usr/share/mysql/my-medium.cnf +-rw-r--r--. 1 root root  4920 Nov 15 00:14 /usr/share/mysql/my-medium.cnf 
--rw-r--r--. 1 root root  2846 Feb  5 15:44 /usr/share/mysql/my-small.cnf+-rw-r--r--. 1 root root  2846 Nov 15 00:14 /usr/share/mysql/my-small.cnf
 </code> </code>
  
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:~~+
  • centos/mariadb.1487611321.txt.gz
  • Zuletzt geändert: 20.02.2017 17:22.
  • von django