MySQL: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
K (http://mysqltuner.com/) |
|||
(8 dazwischenliegende Versionen desselben Benutzers werden nicht angezeigt) | |||
Zeile 1: | Zeile 1: | ||
=Konfiguration | = Konfiguration = | ||
== Custom Settings == | |||
= | <source lang="">#/etc/mysql/conf.d/settings.cnf | ||
[mysqld] | |||
# | |||
# * Basic Settings | |||
# | |||
datadir = /srv/mysql/datadir55 | |||
= | ft_min_word_len=3 | ||
= | table_cache = 256</source> | ||
=== | ==Secure Installation== | ||
<source lang="bash">/usr/bin/mysqladmin -u root -h hostname password 'new-password' | |||
Alternatively you can run: | |||
/usr/bin/mysql_secure_installation | |||
which will also give you the option of removing the test | |||
databases and anonymous user created by default. This is | |||
strongly recommended for production servers.</source> | |||
== Apparmor config == | |||
<source lang="bash">#/etc/apparmor.d/usr.sbin.mysqld | |||
#find and replace | |||
#/var/lib/mysql/ r, | |||
#/var/lib/mysql/** rwk, | |||
/srv/mysql/datadir55/ r, | |||
/srv/mysql/datadir55/** rwk,</source> | |||
=Backup= | |||
*[[MySQLDumper]] | |||
*http://hollandbackup.org/ | |||
*[http://www.lenzg.net/mylvmbackup/ mylvmbackup is a tool for quickly creating full physical backups of a MySQLserver's data files.] | |||
= Clients = | |||
*[http://dev.mysql.com/downloads/tools/workbench/ MySQL Workbench] | |||
*[http://www.navicat.de/ Navicat] | |||
=Links= | |||
*[http://www.thomas-krenn.com/de/wiki/MySQL_Performance_Tuning MySQL Performance Tuning] | |||
*[http://mysqltuner.com/ MySQL Tuner] | |||
[[Kategorie:Datenbank]] | |||
[[Kategorie:MySQL]] |
Aktuelle Version vom 18. Dezember 2015, 22:37 Uhr
Konfiguration
Custom Settings
#/etc/mysql/conf.d/settings.cnf
[mysqld]
#
# * Basic Settings
#
datadir = /srv/mysql/datadir55
ft_min_word_len=3
table_cache = 256
Secure Installation
/usr/bin/mysqladmin -u root -h hostname password 'new-password'
Alternatively you can run:
/usr/bin/mysql_secure_installation
which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.
Apparmor config
#/etc/apparmor.d/usr.sbin.mysqld
#find and replace
#/var/lib/mysql/ r,
#/var/lib/mysql/** rwk,
/srv/mysql/datadir55/ r,
/srv/mysql/datadir55/** rwk,
Backup
- MySQLDumper
- http://hollandbackup.org/
- mylvmbackup is a tool for quickly creating full physical backups of a MySQLserver's data files.