Marostegui added a comment. |
In T205865#4657924, @hoo wrote:wikiadmin@db1109(wikidatawiki)> SELECT * FROM information_schema.tables WHERE table_name = 'wb_changes_dispatch'\G *************************** 1. row *************************** TABLE_CATALOG: def TABLE_SCHEMA: wikidatawiki TABLE_NAME: wb_changes_dispatch TABLE_TYPE: BASE TABLE ENGINE: InnoDB VERSION: 10 ROW_FORMAT: Compact TABLE_ROWS: 577 AVG_ROW_LENGTH: 141 DATA_LENGTH: 81920 MAX_DATA_LENGTH: 0 INDEX_LENGTH: 4907859968 DATA_FREE: 7340032 AUTO_INCREMENT: NULL CREATE_TIME: 2018-04-26 09:16:42 UPDATE_TIME: NULL CHECK_TIME: NULL TABLE_COLLATION: binary CHECKSUM: NULL CREATE_OPTIONS: TABLE_COMMENT: 1 row in set (0.00 sec) wikiadmin@db2083(wikidatawiki)> SELECT * FROM information_schema.tables WHERE table_name = 'wb_changes_dispatch'\G *************************** 1. row *************************** TABLE_CATALOG: def TABLE_SCHEMA: wikidatawiki TABLE_NAME: wb_changes_dispatch TABLE_TYPE: BASE TABLE ENGINE: InnoDB VERSION: 10 ROW_FORMAT: Compressed TABLE_ROWS: 577 AVG_ROW_LENGTH: 70 DATA_LENGTH: 40960 MAX_DATA_LENGTH: 0 INDEX_LENGTH: 540672 DATA_FREE: 9961472 AUTO_INCREMENT: NULL CREATE_TIME: 2018-05-31 10:31:11 UPDATE_TIME: NULL CHECK_TIME: NULL TABLE_COLLATION: binary CHECKSUM: NULL CREATE_OPTIONS: row_format=COMPRESSED key_block_size=8 TABLE_COMMENT: 1 row in set (0.03 sec)The index length differences look interesting…
That's probably because the table is compressed on db2083 and not compressed on db1109.
db1109 and db2083 run a different version of MariaDB.
db1109 runs 10.1.36
db2083 runs 10.1.33
Could this be a 10.1.36 regression? It wouldn't be surprising. Maybe we are being hit by: https://jira.mariadb.org/browse/MDEV-17155
db1109 is being rebuilt now due to T206743 and it is getting compressed tables, so I will run the query there to see if compression has any effect on this equation.
Once that is done, l'll try to upgrade db2083 to 10.1.36 and see if it gets worse there, which could mean a regression on that version.
TASK DETAIL
EMAIL PREFERENCES
To: Marostegui
Cc: Nikerabbit, Stashbot, gerritbot, aaron, hoo, Joe, User-Marostegui, Banyek, jcrespo, Marostegui, Addshore, Aklapper, CucyNoiD, Nandana, NebulousIris, thifranc, jijiki, AndyTan, Gaboe420, Phukettaxigroup, Versusxo, Majesticalreaper22, Giuliamocci, Davinaclare77, Adrian1985, Qtn1293, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Jayprakash12345, Th3d3v1ls, Hfbn0, Ramalepe, Liugev6, QZanden, LawExplorer, Vali.matei, Lewizho99, Minhnv-2809, Zppix, Volans, Maathavan, D3r1ck01, Volker_E, Wong128hk, Luke081515, Wikidata-bugs, aude, GWicke, Dinoguy1000, faidon, Mbch331, Jay8g, Krenair, akosiaris, fgiunchedi
Cc: Nikerabbit, Stashbot, gerritbot, aaron, hoo, Joe, User-Marostegui, Banyek, jcrespo, Marostegui, Addshore, Aklapper, CucyNoiD, Nandana, NebulousIris, thifranc, jijiki, AndyTan, Gaboe420, Phukettaxigroup, Versusxo, Majesticalreaper22, Giuliamocci, Davinaclare77, Adrian1985, Qtn1293, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Jayprakash12345, Th3d3v1ls, Hfbn0, Ramalepe, Liugev6, QZanden, LawExplorer, Vali.matei, Lewizho99, Minhnv-2809, Zppix, Volans, Maathavan, D3r1ck01, Volker_E, Wong128hk, Luke081515, Wikidata-bugs, aude, GWicke, Dinoguy1000, faidon, Mbch331, Jay8g, Krenair, akosiaris, fgiunchedi
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs