跳到主要內容

停用Qnap MariaDB binary log

 停用Qnap MariaDB binary log


1.vi /etc/config/my.cnf

新增skip-log-bin

#log-bin=mysql-bin

skip-log-bin


2.重啟服務


https://www.qnap.com/zh-tw/how-to/faq/article/%E6%88%91%E5%8F%AF%E4%BB%A5%E5%9C%A8%E7%B3%BB%E7%B5%B1%E7%9A%84%E5%93%AA%E8%A3%A1%E6%89%BE%E5%88%B0-mariadb-%E7%9A%84%E8%A8%AD%E5%AE%9A%E6%AA%94

https://dba.stackexchange.com/questions/72770/disable-mysql-binary-logging-with-log-bin-variable

留言

張貼留言

這個網誌中的熱門文章

How do I compile ffmpeg on a QNAP NAS

Tested on QNAP TS-419p+ with ARM CPU, but should work the same way for others. Install “Optware (IPKG)” qpkg from  http://www.qnap.com/qpkg.asp In case the “ipkg update” fails, try to adjust the following two config files: [/opt/etc/ipkg] # more tsx19-kmod.conf src/gz cs08q1armel http://ipkg.nslu2-linux.org/feeds/optware/cs08q1armel/cross/unstable [/opt/etc/ipkg] # more tsx19.conf src/gz cs08q1armel http://ipkg.nslu2-linux.org/feeds/optware/cs08q1armel/cross/unstable ipkg update ipkg install optware-devel ipkg install git ipkg install yasm ipkg install lame mkdir /opt/compile cd /opt/compile git clone git://git.videolan.org/ffmpeg.git cd ffmpeg ./configure --enable-ssse3 --prefix=/opt --extra-cflags='-I/opt/include' --extra-ldflags='-L/opt/lib' --enable-static --disable-shared --disable-ffplay --disable-ffserver --enable-libmp3lame make make install replace built-in ffmpeg with link to new version rm /usr/bin/ffmpeg ln -s /opt/bin/ffmpeg /usr/bin http://bubbl
張貼留言
閱讀完整內容

Setting up a CUPS server with Docker on a Synology NAS for my Brother printer

I made the unfortunate mistake of purchasing a cheap brother printer, the Brother HL-L2300D, which is USB only. And not only is it a USB printer, it is a Winprinter which makes it very limited in anything other than Windows. from Pocket http://ift.tt/2gbYuYH via IFTTT
張貼留言
閱讀完整內容

台灣第一家「真．無人商店」登場，711 推出台灣第一家臉部辨識無人超商！

【我們為什麼挑選這篇文章】上週我們才看了亞馬遜盛大開幕，這週 711 就公布了無人商店實驗店，在這如雨後春筍般的無人商店潮中，我們的生活正在疾速變動。但我覺得全家的概念也蠻有意思的：「與其推出一間跨時代概 from Pocket http://ift.tt/2BCDxQp via IFTTT
張貼留言
閱讀完整內容