mydumper: FTWRL too long due to g_list_append poor performance

Bug #1394309 reported by nong LO
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL Data Dumper
New
Undecided
Unassigned

Bug Description

When backuping 977 databases with 293 tables, which total to 286 261 tables, mydumper set FTWRL for a least 30 minutes.
At first mydumper process "SHOW TABLE STATUS" quite fast, then slow down quickly.

Revision history for this message
nong LO (nong-lo) wrote :

It would be way faster to use g_list_append follow by g_list_reverse.

Revision history for this message
nong LO (nong-lo) wrote :

I mean g_list_prepend

Revision history for this message
nong LO (nong-lo) wrote :
Revision history for this message
nong LO (nong-lo) wrote :
Revision history for this message
Domas Mituzas (domas-mituzas) wrote :

hm, isn't it a double-linked list, why would append be slow?

Revision history for this message
nong LO (nong-lo) wrote :

It seem glist does not have the link to the list tail, so in order to append, it has to traverse the entire list.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.