NoPaste

MariaDB-Settings

von heisenberg

SNIPPET_TEXT:
  1. # systemctl show mariadb.service
  2.  
  3. Type=notify
  4. Restart=always
  5. NotifyAccess=main
  6. RestartUSec=5s
  7. TimeoutStartUSec=15min
  8. TimeoutStopUSec=15min
  9. TimeoutAbortUSec=15min
  10. TimeoutStartFailureMode=terminate
  11. TimeoutStopFailureMode=terminate
  12. RuntimeMaxUSec=infinity
  13. WatchdogUSec=0
  14. WatchdogTimestampMonotonic=0
  15. RootDirectoryStartOnly=no
  16. RemainAfterExit=no
  17. GuessMainPID=yes
  18. MainPID=996588
  19. ControlPID=0
  20. FileDescriptorStoreMax=0
  21. NFileDescriptorStore=0
  22. StatusText=Taking your SQL requests now...
  23. StatusErrno=0
  24. Result=success
  25. ReloadResult=success
  26. CleanResult=success
  27. UID=106
  28. GID=112
  29. NRestarts=0
  30. OOMPolicy=stop
  31. ExecMainStartTimestamp=Sun 2024-11-03 15:11:10 CET
  32. ExecMainStartTimestampMonotonic=575857541802
  33. ExecMainExitTimestampMonotonic=0
  34. ExecMainPID=996588
  35. ExecMainCode=0
  36. ExecMainStatus=0
  37. ExecStartPre={ path=/usr/bin/install ; argv[]=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld ; ignore_errors=no ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }
  38. ExecStartPre={ path=/bin/sh ; argv[]=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION ; ignore_errors=no ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }
  39. ExecStartPre={ path=/bin/sh ; argv[]=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 ; ignore_errors=no ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }
  40. ExecStartPreEx={ path=/usr/bin/install ; argv[]=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld ; flags= ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }
  41. ExecStartPreEx={ path=/bin/sh ; argv[]=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION ; flags= ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }
  42. ExecStartPreEx={ path=/bin/sh ; argv[]=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 ; flags= ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }
  43. ExecStart={ path=/usr/sbin/mariadbd ; argv[]=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION ; ignore_errors=no ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }
  44. ExecStartEx={ path=/usr/sbin/mariadbd ; argv[]=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION ; flags= ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }
  45. ExecStartPost={ path=/bin/sh ; argv[]=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION ; ignore_errors=no ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }
  46. ExecStartPost={ path=/etc/mysql/debian-start ; argv[]=/etc/mysql/debian-start ; ignore_errors=no ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }
  47. ExecStartPostEx={ path=/bin/sh ; argv[]=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION ; flags= ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }
  48. ExecStartPostEx={ path=/etc/mysql/debian-start ; argv[]=/etc/mysql/debian-start ; flags= ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }
  49. Slice=system.slice
  50. ControlGroup=/system.slice/mariadb.service
  51. MemoryCurrent=30410006528
  52. CPUUsageNSec=1144194473000
  53. EffectiveCPUs=0-10
  54. EffectiveMemoryNodes=0
  55. TasksCurrent=32
  56. IPIngressBytes=[no data]
  57. IPIngressPackets=[no data]
  58. IPEgressBytes=[no data]
  59. IPEgressPackets=[no data]
  60. IOReadBytes=18446744073709551615
  61. IOReadOperations=18446744073709551615
  62. IOWriteBytes=18446744073709551615
  63. IOWriteOperations=18446744073709551615
  64. Delegate=no
  65. CPUAccounting=yes
  66. CPUWeight=[not set]
  67. StartupCPUWeight=[not set]
  68. CPUShares=[not set]
  69. StartupCPUShares=[not set]
  70. CPUQuotaPerSecUSec=infinity
  71. CPUQuotaPeriodUSec=infinity
  72. AllowedCPUs=
  73. AllowedMemoryNodes=
  74. IOAccounting=no
  75. IOWeight=[not set]
  76. StartupIOWeight=[not set]
  77. BlockIOAccounting=no
  78. BlockIOWeight=[not set]
  79. StartupBlockIOWeight=[not set]
  80. MemoryAccounting=yes
  81. DefaultMemoryLow=0
  82. DefaultMemoryMin=0
  83. MemoryMin=0
  84. MemoryLow=0
  85. MemoryHigh=infinity
  86. MemoryMax=infinity
  87. MemorySwapMax=infinity
  88. MemoryLimit=infinity
  89. DevicePolicy=auto
  90. TasksAccounting=yes
  91. TasksMax=902431
  92. IPAccounting=no
  93. ManagedOOMSwap=auto
  94. ManagedOOMMemoryPressure=auto
  95. ManagedOOMMemoryPressureLimitPercent=0%
  96. UMask=0007
  97. LimitCPU=infinity
  98. LimitCPUSoft=infinity
  99. LimitFSIZE=infinity
  100. LimitFSIZESoft=infinity
  101. LimitDATA=infinity
  102. LimitDATASoft=infinity
  103. LimitSTACK=infinity
  104. LimitSTACKSoft=8388608
  105. LimitCORE=infinity
  106. LimitCORESoft=0
  107. LimitRSS=infinity
  108. LimitRSSSoft=infinity
  109. LimitNOFILE=32768
  110. LimitNOFILESoft=32768
  111. LimitAS=infinity
  112. LimitASSoft=infinity
  113. LimitNPROC=455773
  114. LimitNPROCSoft=455773
  115. LimitMEMLOCK=65536
  116. LimitMEMLOCKSoft=65536
  117. LimitLOCKS=infinity
  118. LimitLOCKSSoft=infinity
  119. LimitSIGPENDING=455773
  120. LimitSIGPENDINGSoft=455773
  121. LimitMSGQUEUE=819200
  122. LimitMSGQUEUESoft=819200
  123. LimitNICE=0
  124. LimitNICESoft=0
  125. LimitRTPRIO=0
  126. LimitRTPRIOSoft=0
  127. LimitRTTIME=infinity
  128. LimitRTTIMESoft=infinity
  129. RootHashSignature=
  130. OOMScoreAdjust=0
  131. CoredumpFilter=0x33
  132. Nice=0
  133. IOSchedulingClass=0
  134. IOSchedulingPriority=0
  135. CPUSchedulingPolicy=0
  136. CPUSchedulingPriority=0
  137. CPUAffinity=
  138. CPUAffinityFromNUMA=no
  139. NUMAPolicy=n/a
  140. NUMAMask=
  141. TimerSlackNSec=50000
  142. CPUSchedulingResetOnFork=no
  143. NonBlocking=no
  144. StandardInput=null
  145. StandardInputData=
  146. StandardOutput=journal
  147. StandardError=inherit
  148. TTYReset=no
  149. TTYVHangup=no
  150. TTYVTDisallocate=no
  151. SyslogPriority=30
  152. SyslogLevelPrefix=yes
  153. SyslogLevel=6
  154. SyslogFacility=3
  155. LogLevelMax=-1
  156. LogRateLimitIntervalUSec=0
  157. LogRateLimitBurst=0
  158. SecureBits=0
  159. CapabilityBoundingSet=cap_chown cap_dac_override cap_dac_read_search cap_fowner cap_fsetid cap_kill cap_setgid cap_setuid cap_setpcap cap_linux_immutable cap_net_bind_service cap_net_broadcast cap_net_admin cap_net_raw cap_ipc_lock cap_ipc_owner cap_sys_module cap_sys_rawio cap_sys_chroot cap_sys_ptrace cap_sys_pacct cap_sys_admin cap_sys_boot cap_sys_nice cap_sys_resource cap_sys_time cap_sys_tty_config cap_mknod cap_lease cap_audit_write cap_audit_control cap_setfcap cap_mac_override cap_mac_admin cap_syslog cap_wake_alarm cap_block_suspend cap_audit_read cap_perfmon cap_bpf cap_checkpoint_restore
  160. AmbientCapabilities=cap_dac_override cap_ipc_lock cap_audit_write
  161. User=mysql
  162. Group=mysql
  163. DynamicUser=no
  164. RemoveIPC=no
  165. MountFlags=
  166. PrivateTmp=no
  167. PrivateDevices=no
  168. ProtectClock=no
  169. ProtectKernelTunables=no
  170. ProtectKernelModules=no
  171. ProtectKernelLogs=no
  172. ProtectControlGroups=no
  173. PrivateNetwork=no
  174. PrivateUsers=no
  175. PrivateMounts=no
  176. ProtectHome=yes
  177. ProtectSystem=full
  178. SameProcessGroup=no
  179. UtmpMode=init
  180. IgnoreSIGPIPE=yes
  181. NoNewPrivileges=no
  182. SystemCallErrorNumber=2147483646
  183. LockPersonality=no
  184. RuntimeDirectoryPreserve=no
  185. RuntimeDirectoryMode=0755
  186. StateDirectoryMode=0755
  187. CacheDirectoryMode=0755
  188. LogsDirectoryMode=0755
  189. ConfigurationDirectoryMode=0755
  190. TimeoutCleanUSec=infinity
  191. MemoryDenyWriteExecute=no
  192. RestrictRealtime=no
  193. RestrictSUIDSGID=no
  194. RestrictNamespaces=no
  195. MountAPIVFS=no
  196. KeyringMode=private
  197. ProtectProc=default
  198. ProcSubset=all
  199. ProtectHostname=no
  200. KillMode=control-group
  201. KillSignal=15
  202. RestartKillSignal=15
  203. FinalKillSignal=9
  204. SendSIGKILL=no
  205. SendSIGHUP=no
  206. WatchdogSignal=6
  207. Id=mariadb.service
  208. Names=mariadb.service mysqld.service mysql.service
  209. Requires=sysinit.target system.slice
  210. WantedBy=multi-user.target
  211. Conflicts=shutdown.target
  212. Before=shutdown.target multi-user.target
  213. After=systemd-journald.socket network.target sysinit.target system.slice basic.target
  214. Documentation="man:mariadbd(8)" https://mariadb.com/kb/en/library/systemd/
  215. Description=MariaDB 10.5.26 database server
  216. LoadState=loaded
  217. ActiveState=active
  218. FreezerState=running
  219. SubState=running
  220. FragmentPath=/lib/systemd/system/mariadb.service
  221. DropInPaths=/etc/systemd/system/mariadb.service.d/override.conf
  222. UnitFileState=enabled
  223. UnitFilePreset=enabled
  224. StateChangeTimestamp=Sun 2024-11-03 15:11:11 CET
  225. StateChangeTimestampMonotonic=575858474830
  226. InactiveExitTimestamp=Sun 2024-11-03 15:11:10 CET
  227. InactiveExitTimestampMonotonic=575857472562
  228. ActiveEnterTimestamp=Sun 2024-11-03 15:11:11 CET
  229. ActiveEnterTimestampMonotonic=575858474830
  230. ActiveExitTimestamp=Sun 2024-11-03 15:11:01 CET
  231. ActiveExitTimestampMonotonic=575848727292
  232. InactiveEnterTimestamp=Sun 2024-11-03 15:11:04 CET
  233. InactiveEnterTimestampMonotonic=575851532428
  234. CanStart=yes
  235. CanStop=yes
  236. CanReload=no
  237. CanIsolate=no
  238. CanFreeze=yes
  239. StopWhenUnneeded=no
  240. RefuseManualStart=no
  241. RefuseManualStop=no
  242. AllowIsolate=no
  243. DefaultDependencies=yes
  244. OnFailureJobMode=replace
  245. IgnoreOnIsolate=no
  246. NeedDaemonReload=no
  247. JobTimeoutUSec=infinity
  248. JobRunningTimeoutUSec=infinity
  249. JobTimeoutAction=none
  250. ConditionResult=yes
  251. AssertResult=yes
  252. ConditionTimestamp=Sun 2024-11-03 15:11:10 CET
  253. ConditionTimestampMonotonic=575857471061
  254. AssertTimestamp=Sun 2024-11-03 15:11:10 CET
  255. AssertTimestampMonotonic=575857471063
  256. Transient=no
  257. Perpetual=no
  258. StartLimitIntervalUSec=10s
  259. StartLimitBurst=5
  260. StartLimitAction=none
  261. FailureAction=none
  262. SuccessAction=none
  263. InvocationID=6f42977b58c64fa7bd5cd01c5fc72fd8
  264. CollectMode=inactive

Quellcode

Hier kannst du den Code kopieren und ihn in deinen bevorzugten Editor einfügen. PASTEBIN_DOWNLOAD_SNIPPET_EXPLAIN

Verlinken

URL: alles markieren
https://nopaste.debianforum.de/42247

BBCode: alles markieren
[NP]42247[/NP]

LATEST_SNIPPETS