Mysql: Revision history

Diff selection: Mark the radio buttons of the revisions to compare and hit enter or the button at the bottom.
Legend: (cur) = difference with latest revision, (prev) = difference with preceding revision, m = minor edit.

curprev 12:5412:54, 12 January 2023‎ Ekaanbj talk contribs‎ 21,391 bytes +83‎ →‎alter table

curprev 07:2807:28, 10 May 2022‎ Ekaanbj talk contribs‎ 21,308 bytes +130‎ →‎Show column where page_counter is max in table page. Other values are min, avg, sum

curprev 11:1211:12, 1 April 2022‎ Ekaanbj talk contribs‎ 21,178 bytes +1‎ →‎setup slave xtrabackup
curprev 07:2907:29, 1 April 2022‎ Ekaanbj talk contribs‎ 21,177 bytes +86‎ →‎slave stops fix
curprev 07:2007:20, 1 April 2022‎ Ekaanbj talk contribs‎ 21,091 bytes +71‎ →‎slave stops fix

curprev 14:5514:55, 23 March 2022‎ Ekaanbj talk contribs‎ 21,020 bytes +11‎ →‎whoami
curprev 12:5812:58, 23 March 2022‎ Ekaanbj talk contribs‎ 21,009 bytes +60‎ →‎Show tables

curprev 10:3610:36, 17 March 2022‎ Ekaanbj talk contribs‎ 20,949 bytes +10‎ →‎expire_logs_days
curprev 10:3510:35, 17 March 2022‎ Ekaanbj talk contribs‎ 20,939 bytes +94‎ →‎expire_logs_days

curprev 10:2610:26, 15 March 2022‎ Ekaanbj talk contribs‎ 20,845 bytes +76‎ →‎show stored procedures
curprev 08:5808:58, 15 March 2022‎ Ekaanbj talk contribs‎ 20,769 bytes +546‎ →‎List indexes
curprev 08:2608:26, 15 March 2022‎ Ekaanbj talk contribs‎ 20,223 bytes +92‎ →‎timeout

curprev 14:4814:48, 10 March 2022‎ Ekaanbj talk contribs‎ 19,529 bytes +32‎ →‎join

curprev 14:1714:17, 13 January 2022‎ Ekaanbj talk contribs‎ 19,467 bytes +202‎ →‎Reset mysql root password

curprev 07:0607:06, 22 September 2021‎ Ekaanbj talk contribs‎ 19,265 bytes +1,047‎ →‎Test to verify functionality of slave database

curprev 12:2712:27, 11 August 2021‎ Ekaanbj talk contribs‎ 18,218 bytes +107‎ →‎slave stops fix

curprev 09:3409:34, 8 June 2021‎ Ekaanbj talk contribs‎ 18,111 bytes +168‎ →‎Delete logs

curprev 10:0610:06, 7 June 2021‎ Ekaanbj talk contribs‎ 17,943 bytes +17‎ →‎aternative5

curprev 11:0011:00, 15 March 2021‎ Ekaanbj talk contribs‎ 17,926 bytes +67‎ →‎Alternative3.

curprev 13:0713:07, 22 December 2020‎ Ekaanbj talk contribs‎ 17,859 bytes +4‎ →‎slave stops
curprev 13:0513:05, 22 December 2020‎ Ekaanbj talk contribs‎ 17,855 bytes +116‎ →‎find cpu intensive queries

curprev 19:1519:15, 15 December 2020‎ Ekaanbj talk contribs‎ 17,739 bytes +322‎ →‎database usage. Is database using myisam or innodb
curprev 16:3116:31, 15 December 2020‎ Ekaanbj talk contribs‎ 17,417 bytes +397‎ →‎queries per second
curprev 15:4215:42, 15 December 2020‎ Ekaanbj talk contribs‎ 17,020 bytes +40‎ →‎expire_logs_days

curprev 11:4711:47, 10 December 2020‎ Ekaanbj talk contribs‎ 16,980 bytes +143‎ →‎List indexes

curprev 12:1712:17, 27 November 2020‎ Ekaanbj talk contribs‎ 16,837 bytes +20‎ →‎expire_logs_days

curprev 07:5007:50, 14 September 2020‎ Ekaanbj talk contribs‎ 16,817 bytes +86‎ →‎expire_logs_days
curprev 07:4307:43, 14 September 2020‎ Ekaanbj talk contribs‎ 16,731 bytes +234‎ →‎whoami

curprev 05:0305:03, 26 June 2020‎ Ekaanbj talk contribs‎ 16,497 bytes +42‎ →‎slow queries

curprev 07:1107:11, 9 June 2020‎ Ekaanbj talk contribs‎ 16,455 bytes +307‎ →‎start transaction/commit/rollback

curprev 14:1214:12, 8 June 2020‎ Ekaanbj talk contribs‎ 16,148 bytes +37‎ →‎mysqltuner

curprev 12:4112:41, 29 May 2020‎ Ekaanbj talk contribs‎ 16,111 bytes +171‎ →‎comment

curprev 14:2314:23, 20 January 2020‎ Ekaanbj talk contribs‎ 15,940 bytes +167‎ →‎truncate table

curprev 13:1613:16, 30 December 2019‎ Ekaanbj talk contribs‎ 15,773 bytes +71‎ →‎backup all databases

curprev 06:3606:36, 28 November 2019‎ Ekaanbj talk contribs‎ 15,702 bytes +102‎ →‎search for values matching null
curprev 06:2906:29, 28 November 2019‎ Ekaanbj talk contribs‎ 15,600 bytes −29‎ →‎How many rows are on the table.
curprev 06:2106:21, 28 November 2019‎ Ekaanbj talk contribs‎ 15,629 bytes +20‎ →‎Show which data is stored in a table in descending order limit to 100

curprev 12:5012:50, 21 November 2019‎ Ekaanbj talk contribs‎ 15,609 bytes +191‎ →‎dump database in innodb consistent way.

curprev 13:5413:54, 13 November 2019‎ Ekaanbj talk contribs‎ 15,418 bytes +146‎ →‎move row between tables

curprev 13:3513:35, 7 November 2019‎ Ekaanbj talk contribs‎ 15,272 bytes +202‎ →‎mysqltuner

curprev 07:5707:57, 3 October 2019‎ Ekaanbj talk contribs‎ 15,070 bytes +292‎ →‎nestled queries

curprev 12:0712:07, 26 September 2019‎ Ekaanbj talk contribs‎ 14,778 bytes +259‎ No edit summary

curprev 06:5006:50, 13 September 2019‎ Ekaanbj talk contribs‎ 14,519 bytes +91‎ →‎search for values matching null

curprev 09:1709:17, 9 September 2019‎ Ekaanbj talk contribs‎ 14,428 bytes +68‎ →‎match multiple strings

curprev 15:2215:22, 27 August 2019‎ Ekaanbj talk contribs‎ 14,360 bytes +60‎ →‎maxconnections in runtime.

curprev 10:1010:10, 15 March 2019‎ Ekaanbj talk contribs‎ 14,300 bytes +171‎ →‎foreign keys to a table or column
curprev 10:0710:07, 15 March 2019‎ Ekaanbj talk contribs‎ 14,129 bytes +268‎ →‎Show more information about table, show constrains on tables

curprev 07:5907:59, 27 November 2018‎ Ekaanbj talk contribs‎ 13,861 bytes +78‎ →‎List indexes

curprev 08:2608:26, 16 November 2018‎ Ekaanbj talk contribs‎ 13,783 bytes −2‎ →‎explain
curprev 08:2508:25, 16 November 2018‎ Ekaanbj talk contribs‎ 13,785 bytes +1,283‎ →‎explain

curprev 14:3014:30, 13 November 2018‎ Ekaanbj talk contribs‎ 12,502 bytes +134‎ →‎Show more information about table, show constrains on tables

curprev 08:1408:14, 24 October 2018‎ Ekaanbj talk contribs‎ 12,368 bytes +37‎ →‎Show more information about table, show constrains on tables

curprev 13:5613:56, 23 October 2018‎ Ekaanbj talk contribs‎ 12,331 bytes −54‎ →‎show constrains on tables
curprev 13:5613:56, 23 October 2018‎ Ekaanbj talk contribs‎ 12,385 bytes +27‎ →‎Show more information about table
curprev 13:2113:21, 23 October 2018‎ Ekaanbj talk contribs‎ 12,358 bytes +78‎ →‎show tables status

curprev 17:3817:38, 18 June 2018‎ Ekaanbj talk contribs‎ 12,280 bytes +48‎ →‎revoke permissions
curprev 17:2817:28, 18 June 2018‎ Ekaanbj talk contribs‎ 12,232 bytes +71‎ →‎Change root password

curprev 22:1122:11, 10 March 2018‎ Ekaanbj talk contribs‎ 12,161 bytes +71‎ →‎search for values matching null

curprev 13:0813:08, 20 February 2018‎ Ekaanbj talk contribs‎ 12,090 bytes +132‎ →‎Show tables

curprev 13:5213:52, 22 January 2018‎ Ekaanbj talk contribs‎ 11,958 bytes +94‎ →‎match rows with multiple equal columns

curprev 06:2206:22, 25 November 2017‎ Ekaanbj talk contribs‎ 11,864 bytes +51‎ →‎database usage. Is database using myisam or innodb

curprev 10:4610:46, 16 October 2017‎ Ekaanbj talk contribs‎ 11,813 bytes +96‎ →‎password snooping

curprev 20:1620:16, 10 October 2017‎ Ekaanbj talk contribs‎ 11,717 bytes +199‎ →‎password snooping

curprev 11:0911:09, 19 September 2017‎ Ekaanbj talk contribs‎ 11,518 bytes 0‎ →‎match multiple strings
curprev 11:0511:05, 19 September 2017‎ Ekaanbj talk contribs‎ 11,518 bytes +102‎ →‎show value from query

curprev 11:5311:53, 11 April 2017‎ Ekaanbj talk contribs‎ 11,416 bytes +80‎ →‎List indexes

curprev 13:0013:00, 29 March 2017‎ Ekaanbj talk contribs‎ 11,336 bytes +48‎ →‎select whithout column names

curprev 10:3810:38, 9 February 2017‎ Ekaanbj talk contribs‎ 11,288 bytes −1‎ →‎Clear flush MySQL hosts cache dns
curprev 10:3410:34, 9 February 2017‎ Ekaanbj talk contribs‎ 11,289 bytes +173‎ →‎flush dns

curprev 13:5213:52, 7 February 2017‎ Ekaanbj talk contribs‎ 11,116 bytes +94‎ →‎List indexes
curprev 13:4913:49, 7 February 2017‎ Ekaanbj talk contribs‎ 11,022 bytes +65‎ →‎FOREIGN_KEY

curprev 08:1008:10, 19 January 2017‎ Ekaanbj talk contribs‎ 10,957 bytes +98‎ →‎How many rows are on the table.

curprev 08:2908:29, 2 November 2016‎ Ekaanbj talk contribs‎ 10,859 bytes +64‎ →‎dump database in innodb consistent way.

curprev 10:5510:55, 24 October 2016‎ Ekaanbj talk contribs‎ 10,795 bytes +64‎ →‎unlock tables

curprev 07:3507:35, 19 October 2016‎ Ekaanbj talk contribs‎ 10,731 bytes +138‎ →‎unlock tables

curprev 11:1111:11, 18 October 2016‎ Ekaanbj talk contribs‎ 10,593 bytes +37‎ →‎Show permission on database

curprev 07:4507:45, 28 September 2016‎ Ekaanbj talk contribs‎ 10,556 bytes +20‎ →‎Setting the Replication Slave Configuration

curprev 15:1815:18, 6 September 2016‎ Ekaanbj talk contribs‎ 10,536 bytes +33‎ →‎mysql_upgrade

curprev 19:4719:47, 13 June 2016‎ Ekaanbj talk contribs‎ 10,503 bytes +2‎ →‎Change password

curprev 06:3106:31, 2 June 2016‎ Ekaanbj talk contribs‎ 10,501 bytes +96‎ →‎optimize execution

curprev 19:4119:41, 1 June 2016‎ Ekaanbj talk contribs‎ 10,405 bytes +129‎ →‎alter table

curprev 21:0721:07, 31 May 2016‎ Ekaanbj talk contribs‎ 10,276 bytes +62‎ →‎alter table
curprev 05:2905:29, 31 May 2016‎ Ekaanbj talk contribs‎ 10,214 bytes +142‎ →‎explain

curprev 14:2014:20, 25 May 2016‎ Ekaanbj talk contribs‎ 10,072 bytes +1‎ →‎explain
curprev 14:1814:18, 25 May 2016‎ Ekaanbj talk contribs‎ 10,071 bytes +44‎ →‎truncate table

curprev 07:2207:22, 24 May 2016‎ Ekaanbj talk contribs‎ 10,027 bytes +264‎ →‎Usage of database files/size

curprev 07:3407:34, 23 May 2016‎ Ekaanbj talk contribs‎ 9,763 bytes +59‎ →‎Fragmentation

curprev 06:4006:40, 14 May 2016‎ Ekaanbj talk contribs‎ 9,704 bytes +54‎ →‎Show master/slave status.

curprev 08:1408:14, 11 May 2016‎ Ekaanbj talk contribs‎ 9,650 bytes +2‎ →‎kill query

curprev 11:2411:24, 25 April 2016‎ Ekaanbj talk contribs‎ 9,648 bytes −5‎ →‎replication master slave
curprev 11:2311:23, 25 April 2016‎ Ekaanbj talk contribs‎ 9,653 bytes +5‎ No edit summary
curprev 11:1811:18, 25 April 2016‎ Ekaanbj talk contribs‎ 9,648 bytes −727‎ No edit summary

curprev 19:5019:50, 20 April 2016‎ Ekaanbj talk contribs‎ 10,375 bytes −302‎ →‎Show permission on database

curprev 07:0407:04, 19 April 2016‎ Ekaanbj talk contribs‎ 10,677 bytes +284‎ →‎kill query

curprev 12:3012:30, 14 April 2016‎ Ekaanbj talk contribs‎ 10,393 bytes +1‎ →‎What is happening in database. Who is connected to database
curprev 12:2812:28, 14 April 2016‎ Ekaanbj talk contribs‎ 10,392 bytes +32‎ →‎show constrains on tables

curprev 14:1914:19, 12 April 2016‎ Ekaanbj talk contribs‎ 9,958 bytes +262‎ →‎last row

curprev 12:5112:51, 8 April 2016‎ Ekaanbj talk contribs‎ 9,696 bytes +46‎ →‎What is happening in database. Who is connected to database

curprev 09:5509:55, 18 March 2016‎ Ekaanbj talk contribs‎ 9,650 bytes +65‎ →‎mysqld man page

curprev 12:1812:18, 26 February 2016‎ Ekaanbj talk contribs‎ 9,585 bytes +1‎ →‎Test to verify functionality
curprev 12:1812:18, 26 February 2016‎ Ekaanbj talk contribs‎ 9,584 bytes +112‎ →‎Test to verify functionality

curprev 22:5922:59, 25 February 2016‎ Ekaanbj talk contribs‎ 9,472 bytes +27‎ →‎Useful commands

curprev 16:4916:49, 11 January 2016‎ Ekaanbj talk contribs‎ 9,445 bytes +59‎ →‎look at health of slave database

curprev 10:5710:57, 23 November 2015‎ Ekaanbj talk contribs‎ 9,386 bytes +161‎ →‎Useful commands

curprev 22:3122:31, 11 November 2015‎ Ekaanbj talk contribs‎ 9,225 bytes +13‎ →‎Useful commands

curprev 13:2913:29, 19 August 2015‎ Ekaanbj talk contribs‎ 9,212 bytes +25‎ →‎maxconnections in runtime.

curprev 12:4712:47, 25 June 2015‎ Ekaanbj talk contribs‎ 9,187 bytes 0‎ No edit summary

curprev 14:1114:11, 24 June 2015‎ Ekaanbj talk contribs‎ 9,187 bytes −35‎ →‎Show permission on database

curprev 09:5409:54, 23 June 2015‎ Ekaanbj talk contribs‎ 9,222 bytes +120‎ →‎backup databases

curprev 07:0707:07, 29 May 2015‎ Ekaanbj talk contribs‎ 9,102 bytes +114‎ →‎fix database/check database

curprev 13:2213:22, 13 March 2015‎ Ekaanbj talk contribs‎ 8,988 bytes +159‎ →‎pager

curprev 10:5010:50, 26 February 2015‎ Ekaanbj talk contribs‎ 8,829 bytes +37‎ →‎Show permission on database

curprev 13:4013:40, 11 August 2014‎ Ekaanbj talk contribs‎ 8,792 bytes +184‎ →‎Usage of database files/size

curprev 14:0514:05, 29 October 2013‎ Ekaanbj talk contribs‎ 8,608 bytes +110‎ →‎backup databases

curprev 21:2121:21, 23 October 2012‎ Ekaanbj talk contribs‎ 8,498 bytes +1‎ →‎backup databases
curprev 21:2121:21, 23 October 2012‎ Ekaanbj talk contribs‎ 8,497 bytes +6‎ →‎backup databases
curprev 21:2021:20, 23 October 2012‎ Ekaanbj talk contribs‎ 8,491 bytes +123‎ →‎Useful commands

curprev 13:0813:08, 15 October 2012‎ Ekaanbj talk contribs‎ 8,368 bytes −2‎ →‎Show permission on database
curprev 13:0813:08, 15 October 2012‎ Ekaanbj talk contribs‎ 8,370 bytes +55‎ →‎Useful commands

curprev 14:3114:31, 27 February 2012‎ Ekaanbj talk contribs‎ 8,315 bytes +118‎ →‎Useful commands

curprev 15:4915:49, 26 February 2012‎ Ekaanbj talk contribs‎ 8,197 bytes +44‎ →‎Useful commands

curprev 10:1910:19, 22 November 2011‎ Ekaanbj talk contribs‎ 8,153 bytes +104‎ →‎Useful commands

curprev 07:4007:40, 25 September 2011‎ Ekaanbj talk contribs‎ 8,049 bytes +49‎ →‎Useful commands

curprev 12:2212:22, 24 August 2010‎ Ekaanbj talk contribs‎ 8,000 bytes +73‎ →‎Usage of database files/size

curprev 07:4007:40, 15 March 2010‎ Ekaanbj talk contribs‎ 7,927 bytes +46‎ →‎Useful commands

curprev 22:2122:21, 28 December 2009‎ Ekaanbj talk contribs‎ 7,881 bytes +224‎ →‎Test to verify functionality

curprev 14:0214:02, 11 November 2009‎ Ekaanbj talk contribs‎ 7,657 bytes +44‎ →‎Useful commands

curprev 11:1511:15, 5 November 2009‎ Ekaanbj talk contribs‎ 7,613 bytes +5‎ →‎Useful commands

curprev 12:5112:51, 15 December 2008‎ Ekaanbj talk contribs‎ 7,608 bytes +59‎ →‎Useful commands

curprev 08:5908:59, 9 December 2008‎ Ekaanbj talk contribs‎ 7,549 bytes +64‎ →‎Useful commands

curprev 20:1420:14, 22 November 2008‎ 88.80.164.157 talk‎ 7,485 bytes +103‎ →‎Useful commands

curprev 08:3008:30, 3 November 2008‎ Ekaanbj talk contribs‎ 7,382 bytes +209‎ →‎Setting the Replication Slave Configuration

curprev 14:5614:56, 20 October 2008‎ Ekaanbj talk contribs‎ 7,173 bytes +44‎ No edit summary

curprev 10:5610:56, 30 September 2008‎ 88.80.164.166 talk‎ 7,129 bytes +83‎ →‎Useful commands

curprev 08:3608:36, 19 September 2008‎ 88.80.164.166 talk‎ 7,046 bytes +54‎ →‎Useful commands

curprev 13:3913:39, 9 September 2008‎ 88.80.164.166 talk‎ 6,992 bytes +120‎ →‎Useful commands

curprev 22:0222:02, 23 June 2008‎ 88.80.164.157 talk‎ 6,872 bytes +16‎ →‎Setting the Replication Slave Configuration
curprev 22:0122:01, 23 June 2008‎ 88.80.164.157 talk‎ 6,856 bytes +29‎ →‎Setting the Replication Master Configuration
curprev 21:5921:59, 23 June 2008‎ 88.80.164.157 talk‎ 6,827 bytes +2,168‎ →‎Web resources

curprev 08:2308:23, 28 May 2008‎ 88.80.164.166 talk‎ 4,659 bytes +62‎ →‎Useful commands

curprev 13:2713:27, 18 April 2008‎ 88.80.164.166 talk‎ 4,597 bytes +76‎ →‎Web resources

curprev 12:0612:06, 8 April 2008‎ 88.80.164.166 talk‎ 4,521 bytes +10‎ →‎Useful commands
curprev 12:0412:04, 8 April 2008‎ 88.80.164.166 talk‎ 4,511 bytes +111‎ →‎Useful commands

curprev 17:3117:31, 29 February 2008‎ 192.168.2.8 talk‎ 4,400 bytes −9‎ →‎Useful commands

curprev 08:3208:32, 27 February 2008‎ 88.80.164.166 talk‎ 4,409 bytes +267‎ No edit summary

curprev 13:3013:30, 19 February 2008‎ 88.80.164.166 talk‎ 4,142 bytes +195‎ →‎Useful commands

curprev 13:1613:16, 21 January 2008‎ 88.80.164.166 talk‎ 3,632 bytes +114‎ No edit summary

curprev 14:5914:59, 25 October 2007‎ 217.10.60.85 talk‎ 3,518 bytes −8‎ No edit summary
curprev 14:4714:47, 25 October 2007‎ 217.10.60.85 talk‎ 3,526 bytes +975‎ No edit summary
curprev 13:1313:13, 25 October 2007‎ 217.10.60.85 talk‎ 2,551 bytes −9‎ No edit summary
curprev 13:0913:09, 25 October 2007‎ 217.10.60.85 talk‎ 2,560 bytes +2,416‎ No edit summary

curprev 21:5721:57, 10 October 2007‎ 192.168.2.57 talk‎ 144 bytes +20‎ No edit summary
curprev 21:5521:55, 10 October 2007‎ 192.168.2.57 talk‎ 124 bytes +21‎ No edit summary
curprev 21:5421:54, 10 October 2007‎ 192.168.2.57 talk‎ 103 bytes +4‎ No edit summary

curprev 21:5321:53, 10 October 2007‎ 192.168.2.57 talk‎ 99 bytes +99‎ New page: ==Mysql== ===Useful commands=== *backup all databases. mysqldump --all-databases -p > /temp/mysql

Mysql: Revision history

12 January 2023

10 May 2022

1 April 2022

23 March 2022

17 March 2022

15 March 2022

11 March 2022

10 March 2022

19 January 2022

13 January 2022

22 September 2021

11 August 2021

8 June 2021

7 June 2021

15 March 2021

22 December 2020

15 December 2020

10 December 2020

27 November 2020

14 September 2020

26 June 2020

9 June 2020

8 June 2020

29 May 2020

20 January 2020

30 December 2019

28 November 2019

21 November 2019

13 November 2019

7 November 2019

3 October 2019

26 September 2019

13 September 2019

9 September 2019

27 August 2019

15 March 2019

27 November 2018

16 November 2018

13 November 2018

24 October 2018

23 October 2018

18 June 2018

10 March 2018

20 February 2018

22 January 2018

25 November 2017

16 October 2017

10 October 2017

19 September 2017

11 April 2017

29 March 2017

9 February 2017

7 February 2017

19 January 2017

2 November 2016

24 October 2016

19 October 2016

18 October 2016

28 September 2016

6 September 2016

13 June 2016

2 June 2016

1 June 2016

31 May 2016

25 May 2016

24 May 2016

23 May 2016

14 May 2016

11 May 2016

25 April 2016

20 April 2016

19 April 2016

14 April 2016

13 April 2016

12 April 2016

8 April 2016

18 March 2016

26 February 2016

25 February 2016