Mysql: Revision history

View logs for this page

Jump to navigation Jump to search

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.

(newest | oldest) View (newer 100 | older 100) (20 | 50 | 100 | 250 | 500)

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

(newest | oldest) View (newer 100 | older 100) (20 | 50 | 100 | 250 | 500)

Retrieved from "https://halfface.se/wiki/index.php/Mysql"

Navigation menu