[MDEV-656] LP:771934 - archive discovery very slow Created: 2011-04-27  Updated: 2013-11-08  Resolved: 2013-11-08

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 5.5.33, 5.1.67, 5.2.14, 5.3.12
Fix Version/s: 10.0.4

Type: Bug Priority: Minor
Reporter: Sergei Golubchik Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: Launchpad, plugins

Attachments: XML File LPexportBug771934.xml    
Issue Links:
Relates
relates to MDEV-3808 Better table discovery Closed

 Description   

according to our users with lots of archive tables, discovery overhead is very noticeable:

show table 'non-existing table' randomly times out in a database with thousands of archive tables.
..
<dreas> actually "show tables" is also very slow. MyISAM: 2961 rows in set (3.71 sec), ARCHIVE: 2954 rows in set (36.96 sec)

using a binary with disabled discovery in archive has solved these problems.

 Comments   
Comment by Rasmus Johansson (Inactive) [ 2011-04-27 ]

Launchpad bug id: 771934

Comment by Sergei Golubchik [ 2013-11-08 ]

Fixed in the new recovery code.
(I was not able to repeat the slowdown)

Generated at Thu Feb 08 06:30:23 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.