search

MySQL Logging


Die verschiedenen LogTypen:

Log Type Information Written to Log
Error log Problems encountered starting, running, or stopping mysqld
General query log Established client connections and statements received from clients
Binary log Statements that change data (also used for replication)
Relay log Data changes received from a replication master server
Slow query log Queries that took more than long_query_time seconds to execute

 

Die Mysql config Datei muss wie folgt angepasst werden, damit Logs geschrieben werden (/etc/my.cnf)(http://www.pontikis.net/blog/how-and-when-to-enable-mysql-logs):

[mysqld]

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

user=mysql

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

log-error=/var/log/mysql_error.log

 

log-bin=mysql-bin

 

general_log_file       = /var/log/mysql.log

general_log             = 1

 

log_slow_queries        = /var/log/mysql-slow.log

long_query_time = 2

log-queries-not-using-indexes

 

[mysqld_safe]

log-error=/var/log/mysql_error.log

pid-file=/var/run/mysqld/mysqld.pid

 

mysql-bin Speicherort ist: „/var/lib/MySQL“

Um die Logs beim Start zu aktivieren, muss man sich mit „mysql –u root –p“ bei mysql anmelden und dann folgendes ausführen:

SET GLOBAL general_log = ‘ON’;

SET GLOBAL slow_query_log = ‘ON’;

FLUSH LOGS; Führt zur Neuerstellung des bin Logs.

Schreiben Sie einen Kommentar

Ihre E-Mail-Adresse wird nicht veröffentlicht. Erforderliche Felder sind mit * markiert.

close
search
Instagram
  • Morgäspaziergang vum Obersee ufä Rauti🏃‍♂️ #inlovewiththemountains #dabinidihei #glarusnord #glarus #glarnerland #glarneralpen #switzerland #swissalps #swissmountains #iloveswitzerland #rauti #rautispitz #obersee #sunrise #sonnenuntergang #trailrunningswitzerland #trailrunning #mountains #mountainlove #mondayevening
#traumtag😍
  • wänn jedä Mäntig so wür ändä😍🏞❤ #bikeandhike #inlovewiththemountains #dabinidihei #glarusnord #glarus #glarnerland #glarneralpen #switzerland #swissalps #swissmountains #iloveswitzerland #fronalpstock #sunset #sonnenuntergang #trailrunningswitzerland #trailrunning #mountains #mountainlove #mondayevening
#traumtag😍
#leidernureshandyfoti #merktdochehkeisau
  • Wunderschünä Morgä uf dr Siwelle😍

#5sternehotel #traumhaft #sunrise #sonnenaufgang #schilt #tödi #glarus #glarusnord #glarusalps #glarusphoto #alpen #alps #swissalps #switzerland #mountains #mountainlove #getupearly #dosomething #tent #camping #msr  #photographer #nature #naturelove #photography #sony #alpha7iii #sonya7iii 
oh wäri froh heti es 200mm... f8 | 1/160s | ISO 100
  • Ufem erstä im Hintergrund s Rheinwaldhorm und ufem zweitä zoberst😍

#rheinwaldhorn #adula #tessin #graubünden #switzerland #schweiz #alps #mountains #steilischgeil #bergsteigen
  • ⛷🌄📷😍 #traumhaft #sunset #sonnenuntergang #sunrise #sonnenaufgang #schilt #glärnisch #wiggis #glarus #skitour #skitouring #alpen #mountains #tent #camping #msr #dynafit #photographer #nature #photography #sony #alpha7iii #sonya7iii #gmaster1635 
f2.8 | 1/1000s | ISO 100
f22 | 1/80s | ISO 100
f22 | 1s | ISO 100
f22 | 1/15s | ISO 100
  • #traumtag😍 
Besser hets nüd chänä sii👌

#mountains #mitstigisäundpickel #sanbernardino #zapporthorn #graubünden #switzerland #alps #ski #skitour #skitouring #snowymountains
  • Wienacht am Meer😍🎅🎄 #sunset #sonnenuntergang #sea #meer #sommervibes #christmas #roadtrip #roadtripusa #travel #traveler #travelusa #america #usa #nature #photography #sony #alpha7iii #sonya7iii #gmaster1635 
f22 | 1/50s | ISO 100
  • Nei dr Wald brännt nüd🔥

#sunset #sonnenuntergang #lake #forest #nature #photography #longtimeexposure #louisiana #lafayette #roadtrip #roadtripusa #travel #travelusa #america #usa #sony #alpha7iii #sonya7iii

f25 | 3.5s | ISO 50
#hanhaltkeindfilter #hätaberaufunktioniert
  • Lüäg än Aff👀

#houston #texas #zoo #houstonzoo #affe #dschungel #ape #roadtrip #roadtripusa #travel #travelusa #america #usa #sony #alpha7iii #sonya7iii #gmaster1635

f5.6 | 1/250s | ISO 1000

Follow Me!

Neue Kommentare

    Hi, guest!

    settings

    menu

    By continuing to use the site, you agree to the use of cookies. more information

    The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

    Close