MySQL Data Dumper

Add option to skip SHOW TABLE STATUS queries

Bug #1239588 reported by Przemek on 2013-10-14

This bug affects 2 people

Affects		Status	Importance	Assigned to	Milestone
	MySQL Data Dumper	New	Wishlist	Unassigned

Bug Description

For many databases/tables querying SHOW TABLE STATUS per each db adds significant speed overhead. --skip-table-status option would be nice to have.

Tags:

Revision history for this message

Daniel Guzmán Burgos (nethalo) wrote on 2013-10-22:

Replacement of "show table status" using information_schema.tables table Edit (550 bytes, text/plain)

I've made a patch of the mydumper.c code before compile it to override the use of "show table status". Insted, i'm using information_schema.
Tested on mydumper version 0.2.3

Max Bubenick (max-bubenick) on 2013-11-22

Changed in mydumper:
importance:	Undecided → Wishlist

Report a bug

This report contains Public information

Everyone can see this information.

You are

Subscribing...

Edit bug mail

Other bug subscribers

Patches

Replacement of "show table status" using information_schema.tables table Edit

Add patch

Remote bug watches

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