MySQL: Unterschied zwischen den Versionen

Aus crazylinux.de
Zur Navigation springen Zur Suche springen
K (cats)
K (x)
Zeile 1: Zeile 1:
= Konfiguration =
= Konfiguration =


== Volltextsuche ==
== Custom Settings ==


Damit die Volltextsuche bereits ab 3 Buchstaben indiziert, ist ein Eintrag in /etc/mysql/my.cnf notwendig (http://dev.mysql.com/doc/refman/4.1/en/fulltext-fine-tuning.html):
<source lang="">#/etc/mysql/conf.d/settings.cnf
[mysqld]
#
# * Basic Settings
#
datadir        = /srv/mysql/datadir55


[mysqld]
ft_min_word_len=3
ft_min_word_len=3


<br>  
table_cache            = 256</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>


= Clients =
= Clients =

Version vom 20. August 2012, 19:50 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


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,

Clients

MySQL QueryBrowser

http://dev.mysql.com/downloads/query-browser/1.1.html

SQLManager

http://www.sqlmanager.net/products/mysql/manager

Navicat

http://www.navicat.de/

SQLyog

http://www.webyog.com/
Abgerufen von „https://crazylinux.de/?title=MySQL&oldid=4236“