MySQL Tipps und Tricks: Revision history

23 November 2022

• curprev 15:1715:17, 23 November 2022‎ Lollypop talk contribs‎ 31,428 bytes +86‎ →‎/etc/idmapd.conf
• curprev 13:0713:07, 23 November 2022‎ Lollypop talk contribs‎ 31,342 bytes 0‎ →‎/etc/idmapd.conf
• curprev 13:0713:07, 23 November 2022‎ Lollypop talk contribs‎ 31,342 bytes +87‎ →‎/etc/idmapd.conf

26 November 2021

• curprev 03:4503:45, 26 November 2021‎ Lollypop talk contribs‎ m 31,255 bytes −1‎ Text replacement - "[[Kategorie:" to "[[Category:"

25 November 2021

• curprev 17:5217:52, 25 November 2021‎ Lollypop talk contribs‎ m 31,256 bytes +648‎ Text replacement - "<source" to "<syntaxhighlight"
• curprev 16:2216:22, 25 November 2021‎ Lollypop talk contribs‎ m 30,608 bytes +648‎ Text replacement - "</source" to "</syntaxhighlight"

26 October 2020

• curprev 17:0117:01, 26 October 2020‎ Lollypop talk contribs‎ 29,960 bytes −21‎ →‎/etc/modprobe.d/blacklist-rpcsec_gss_krb5.conf
• curprev 17:0117:01, 26 October 2020‎ Lollypop talk contribs‎ 29,981 bytes +30‎ →‎/etc/modprobe.d/rpcsec_gss_krb5
• curprev 17:0017:00, 26 October 2020‎ Lollypop talk contribs‎ 29,951 bytes +275‎ →‎On Linux

7 December 2018

• curprev 17:1717:17, 7 December 2018‎ Lollypop talk contribs‎ 29,676 bytes −4‎ →‎All grants
• curprev 17:0017:00, 7 December 2018‎ Lollypop talk contribs‎ 29,680 bytes +865‎ →‎All grants

28 August 2018

• curprev 18:5418:54, 28 August 2018‎ Lollypop talk contribs‎ 28,815 bytes −248‎ →‎All grants

17 May 2018

• curprev 14:0514:05, 17 May 2018‎ Lollypop talk contribs‎ 29,063 bytes −5‎ No edit summary
• curprev 13:5313:53, 17 May 2018‎ Lollypop talk contribs‎ 29,068 bytes +10‎ No edit summary

9 March 2018

• curprev 16:0716:07, 9 March 2018‎ Lollypop talk contribs‎ 29,058 bytes +402‎ →‎Analyze

21 December 2017

• curprev 12:3412:34, 21 December 2017‎ Lollypop talk contribs‎ 28,656 bytes +472‎ →‎Oneliner

15 June 2017

• curprev 18:0618:06, 15 June 2017‎ Lollypop talk contribs‎ 28,184 bytes +25‎ →‎All grants
• curprev 17:3817:38, 15 June 2017‎ Lollypop talk contribs‎ 28,159 bytes +870‎ →‎All grants
• curprev 13:5913:59, 15 June 2017‎ Lollypop talk contribs‎ 27,289 bytes +2,940‎ →‎All grants

23 May 2017

• curprev 09:4009:40, 23 May 2017‎ Lollypop talk contribs‎ 24,349 bytes +176‎ →‎What did we see from the master
• curprev 09:3109:31, 23 May 2017‎ Lollypop talk contribs‎ 24,173 bytes +759‎ No edit summary

12 May 2017

• curprev 17:3117:31, 12 May 2017‎ Lollypop talk contribs‎ 23,414 bytes +153‎ →‎Modify systemd service to wait for NFS
• curprev 17:2817:28, 12 May 2017‎ Lollypop talk contribs‎ 23,261 bytes +136‎ →‎Modify systemd service to wait for NFS
• curprev 17:2417:24, 12 May 2017‎ Lollypop talk contribs‎ 23,125 bytes +357‎ →‎Modify systemd service to raise the number of files limit
• curprev 17:1917:19, 12 May 2017‎ Lollypop talk contribs‎ 22,768 bytes +13‎ →‎Raise allowed number of open files /etc/security/limits.d/mysql.conf
• curprev 17:1917:19, 12 May 2017‎ Lollypop talk contribs‎ 22,755 bytes +310‎ →‎On Linux
• curprev 17:1617:16, 12 May 2017‎ Lollypop talk contribs‎ 22,445 bytes +405‎ →‎Modify systemd service to wait for NFS
• curprev 17:1517:15, 12 May 2017‎ Lollypop talk contribs‎ 22,040 bytes −36‎ →‎Modify systemd service to wait for NFS
• curprev 17:1217:12, 12 May 2017‎ Lollypop talk contribs‎ 22,076 bytes +76‎ →‎Modify systemd service to wait for NFS

5 May 2017

• curprev 10:2010:20, 5 May 2017‎ Lollypop talk contribs‎ 22,000 bytes +158‎ →‎On NetApp CDOT SVM
• curprev 10:1910:19, 5 May 2017‎ Lollypop talk contribs‎ 21,842 bytes +260‎ →‎On NetApp CDOT SVM
• curprev 10:1710:17, 5 May 2017‎ Lollypop talk contribs‎ 21,582 bytes +274‎ →‎On NetApp CDOT SVM

4 May 2017

• curprev 17:4117:41, 4 May 2017‎ Lollypop talk contribs‎ 21,308 bytes +712‎ →‎/etc/mysql/mysql.conf.d/query_cache.cnf
• curprev 17:4017:40, 4 May 2017‎ Lollypop talk contribs‎ 20,596 bytes +250‎ →‎On Linux
• curprev 17:2917:29, 4 May 2017‎ Lollypop talk contribs‎ 20,346 bytes +1,201‎ →‎On Linux
• curprev 17:1917:19, 4 May 2017‎ Lollypop talk contribs‎ 19,145 bytes +313‎ →‎NFSv4
• curprev 17:1717:17, 4 May 2017‎ Lollypop talk contribs‎ 18,832 bytes +2,775‎ →‎NFSv4
• curprev 17:0417:04, 4 May 2017‎ Lollypop talk contribs‎ 16,057 bytes +66‎ →‎NFSv4
• curprev 17:0117:01, 4 May 2017‎ Lollypop talk contribs‎ 15,991 bytes +1,933‎ →‎Filesystems for MySQL

1 December 2016

• curprev 15:3415:34, 1 December 2016‎ Lollypop talk contribs‎ 14,058 bytes +434‎ No edit summary

11 January 2016

• curprev 15:1915:19, 11 January 2016‎ Lollypop talk contribs‎ 13,624 bytes +7‎ →‎All grants

20 August 2015

• curprev 10:1610:16, 20 August 2015‎ Lollypop talk contribs‎ 13,617 bytes −3‎ →‎Sysbench

17 August 2015

• curprev 12:5412:54, 17 August 2015‎ Lollypop talk contribs‎ 13,620 bytes +121‎ →‎Filesystems for MySQL
• curprev 10:2110:21, 17 August 2015‎ Lollypop talk contribs‎ 13,499 bytes +4,094‎ No edit summary
• curprev 09:1109:11, 17 August 2015‎ Lollypop talk contribs‎ 9,405 bytes +299‎ →‎Lost grants

13 August 2015

• curprev 17:4317:43, 13 August 2015‎ Lollypop talk contribs‎ 9,106 bytes +506‎ →‎Analyze
• curprev 17:1717:17, 13 August 2015‎ Lollypop talk contribs‎ 8,600 bytes 0‎ →‎Analyze
• curprev 17:1617:16, 13 August 2015‎ Lollypop talk contribs‎ 8,600 bytes +93‎ →‎Analyze
• curprev 17:1117:11, 13 August 2015‎ Lollypop talk contribs‎ 8,507 bytes 0‎ →‎Analyse
• curprev 17:1017:10, 13 August 2015‎ Lollypop talk contribs‎ 8,507 bytes +69‎ →‎Analyse
• curprev 16:5816:58, 13 August 2015‎ Lollypop talk contribs‎ 8,438 bytes +48‎ →‎Sysbench
• curprev 16:5616:56, 13 August 2015‎ Lollypop talk contribs‎ 8,390 bytes +462‎ →‎Sysbench
• curprev 16:4116:41, 13 August 2015‎ Lollypop talk contribs‎ 7,928 bytes +341‎ No edit summary
• curprev 13:3713:37, 13 August 2015‎ Lollypop talk contribs‎ 7,587 bytes +187‎ →‎Last update time
• curprev 13:3413:34, 13 August 2015‎ Lollypop talk contribs‎ 7,400 bytes +167‎ No edit summary

12 August 2015

• curprev 19:4019:40, 12 August 2015‎ Lollypop talk contribs‎ 7,233 bytes +46‎ →‎Recover a damaged root account
• curprev 19:3219:32, 12 August 2015‎ Lollypop talk contribs‎ 7,187 bytes +18‎ →‎Recover a damaged root account
• curprev 19:2019:20, 12 August 2015‎ Lollypop talk contribs‎ 7,169 bytes +661‎ No edit summary
• curprev 16:2216:22, 12 August 2015‎ Lollypop talk contribs‎ 6,508 bytes −3‎ →‎Sample InnoDB configuration
• curprev 16:2116:21, 12 August 2015‎ Lollypop talk contribs‎ 6,511 bytes +734‎ No edit summary
• curprev 16:1716:17, 12 August 2015‎ Lollypop talk contribs‎ 5,777 bytes +258‎ →‎Raw devices with InnoDB
• curprev 15:5915:59, 12 August 2015‎ Lollypop talk contribs‎ 5,519 bytes +13‎ →‎Raw devices with InnoDB
• curprev 15:5415:54, 12 August 2015‎ Lollypop talk contribs‎ 5,506 bytes +597‎ →‎Raw devices with InnoDB
• curprev 15:5015:50, 12 August 2015‎ Lollypop talk contribs‎ 4,909 bytes +459‎ →‎Raw devices with InnoDB
• curprev 15:4815:48, 12 August 2015‎ Lollypop talk contribs‎ 4,450 bytes +1,603‎ →‎Filesystems for MySQL
• curprev 13:5413:54, 12 August 2015‎ Lollypop talk contribs‎ 2,847 bytes +98‎ No edit summary
• curprev 12:5812:58, 12 August 2015‎ Lollypop talk contribs‎ 2,749 bytes +356‎ No edit summary
• curprev 12:5012:50, 12 August 2015‎ Lollypop talk contribs‎ 2,393 bytes +483‎ →‎Choose logging destination FILE/TABLE/NONE
• curprev 11:4211:42, 12 August 2015‎ Lollypop talk contribs‎ 1,910 bytes +198‎ →‎What can I log?
• curprev 11:3811:38, 12 August 2015‎ Lollypop talk contribs‎ 1,712 bytes +144‎ →‎Logging
• curprev 11:3511:35, 12 August 2015‎ Lollypop talk contribs‎ 1,568 bytes +117‎ →‎Logging
• curprev 11:3411:34, 12 August 2015‎ Lollypop talk contribs‎ 1,451 bytes +11‎ →‎Enable/disable general logging
• curprev 11:3311:33, 12 August 2015‎ Lollypop talk contribs‎ 1,440 bytes +394‎ →‎Logging
• curprev 11:3211:32, 12 August 2015‎ Lollypop talk contribs‎ 1,046 bytes +113‎ →‎Enable/disable logging
• curprev 11:3111:31, 12 August 2015‎ Lollypop talk contribs‎ 933 bytes +225‎ No edit summary

11 August 2015

• curprev 10:3310:33, 11 August 2015‎ Lollypop talk contribs‎ 708 bytes +23‎ →‎Per database
• curprev 10:3110:31, 11 August 2015‎ Lollypop talk contribs‎ 685 bytes +5‎ →‎Per table
• curprev 10:3110:31, 11 August 2015‎ Lollypop talk contribs‎ 680 bytes +5‎ →‎Per database
• curprev 10:2910:29, 11 August 2015‎ Lollypop talk contribs‎ 675 bytes +13‎ →‎Per database
• curprev 10:2910:29, 11 August 2015‎ Lollypop talk contribs‎ 662 bytes +12‎ →‎Per table
• curprev 10:2810:28, 11 August 2015‎ Lollypop talk contribs‎ 650 bytes −20‎ →‎Per table
• curprev 10:2810:28, 11 August 2015‎ Lollypop talk contribs‎ 670 bytes +422‎ No edit summary

29 December 2014

• curprev 11:1511:15, 29 December 2014‎ Lollypop talk contribs‎ 248 bytes +17‎ No edit summary
• curprev 11:1411:14, 29 December 2014‎ Lollypop talk contribs‎ 231 bytes +231‎ Die Seite wurde neu angelegt: „Kategorie:MySQL ==Einzeiler== ===Alle Grants=== <source lang=bash> # mysql --skip-column-names --batch --execute 'select concat_ws("@",user,host) from my…“