Unterschiede
Hier werden die Unterschiede zwischen zwei Versionen angezeigt.
Beide Seiten der vorigen Revision Vorhergehende Überarbeitung Nächste Überarbeitung | Vorhergehende ÜberarbeitungLetzte ÜberarbeitungBeide Seiten der Revision | ||
centos:mariadb [20.02.2017 17:22. ] – [Installation] mariadb-server #sql #CentOS7 django | centos:mariadb [20.02.2017 17:37. ] – MariaDB [erster Start] #MariaDB #CentOS7 django | ||
---|---|---|---|
Zeile 175: | Zeile 175: | ||
Zusätzliche Beispiele finden sich übrigens auch im Verzeichnis // | Zusätzliche Beispiele finden sich übrigens auch im Verzeichnis // | ||
# ll / | # ll / | ||
- | < | + | < |
- | -rw-r--r--. 1 root root 20438 Feb 5 15:44 / | + | -rw-r--r--. 1 root root 20438 Nov 15 00:14 / |
- | -rw-r--r--. 1 root root 4907 Feb 5 15:44 / | + | -rw-r--r--. 1 root root 4907 Nov 15 00:14 / |
- | -rw-r--r--. 1 root root 4920 Feb 5 15:44 / | + | -rw-r--r--. 1 root root 4920 Nov 15 00:14 / |
- | -rw-r--r--. 1 root root 2846 Feb 5 15:44 / | + | -rw-r--r--. 1 root root 2846 Nov 15 00:14 / |
</ | </ | ||
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 // | Der Start wird im Logfile des Datenbankservers // | ||
# less / | # less / | ||
- | < | + | < |
- | 150307 22:10:14 InnoDB: The InnoDB memory heap is disabled | + | 170220 18:25:10 [Note] / |
- | 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 | + | 170220 18:25:10 |
InnoDB: Database physically writes the file full: wait... | InnoDB: Database physically writes the file full: wait... | ||
- | 150307 22:10:14 | + | 170220 18:25:10 |
InnoDB: Setting log file ./ | InnoDB: Setting log file ./ | ||
InnoDB: Database physically writes the file full: wait... | InnoDB: Database physically writes the file full: wait... | ||
- | 150307 22:10:14 | + | 170220 18:25:10 |
InnoDB: Setting log file ./ | InnoDB: Setting log file ./ | ||
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 | + | 170220 18:25:11 |
- | 150307 22:10:16 Percona XtraDB (http:// | + | 170220 18:25:12 Percona XtraDB (http:// |
- | 150307 22:10:16 [Note] Plugin ' | + | 170220 18:25:12 [Note] Plugin ' |
- | 150307 22:10:16 [Note] Server socket created on IP: ' | + | 170220 18:25:12 [Note] Server socket created on IP: ' |
- | 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] / | + | 170220 18:25:12 [Note] / |
- | Version: '5.5.41-MariaDB' | + | Version: '5.5.52-MariaDB' |
</ | </ | ||
Zeile 245: | Zeile 246: | ||
Möchten wir überprüfen, | Möchten wir überprüfen, | ||
- | - **systemctl** \\ < | + | - **systemctl** \\ < |
- | | + | <font style=" |
- | | + | |
- | Process: | + | |
- | Process: | + | Process: |
- | Main PID: 27039 (mysqld_safe) | + | Process: |
+ | Main PID: 3098 (mysqld_safe) | ||
| | ||
- | | + | |
- | | + | |
- | Mar 07 22:10:13 vml000117.dmz.nausch.org mariadb-prepare-db-dir[26961]: The latest information about MariaDB is available | + | Feb 20 18:25:10 vml000117.dmz.nausch.org mariadb-prepare-db-dir[3019]: To start mysqld |
- | 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/ |
- | Mar 07 22:10:13 vml000117.dmz.nausch.org mariadb-prepare-db-dir[26961]: http:// | + | 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]: '/ |
- | 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]: '/ |
- | Mar 07 22:10:13 vml000117.dmz.nausch.org mariadb-prepare-db-dir[26961]: http:// | + | 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 '/ | + | Feb 20 18:25:10 vml000117.dmz.nausch.org mysqld_safe[3098]: 170220 18:25:10 mysqld_safe Logging to '/ |
- | Mar 07 22:10:14 vml000117.dmz.nausch.org mysqld_safe[27039]: 150307 22:10:14 mysqld_safe Starting mysqld daemon with databases from / | + | Feb 20 18:25:10 vml000117.dmz.nausch.org mysqld_safe[3098]: 170220 18:25:10 mysqld_safe Starting mysqld daemon with databases from / |
- | Mar 07 22:10:17 vml000117.dmz.nausch.org systemd[1]: Started MariaDB database server.</ | + | Feb 20 18:25:12 vml000117.dmz.nausch.org systemd[1]: Started MariaDB database server.</ |
+ | </ | ||
- **ps** \\ < | - **ps** \\ < | ||
mysql 27198 0.0 8.3 905348 84784 ? Sl | mysql 27198 0.0 8.3 905348 84784 ? Sl |