[#MCOL-157] DROP TABLE is very slow

[MCOL-157] DROP TABLE is very slow Created: 2016-06-21 Updated: 2016-12-21 Resolved: 2016-12-21
Status:	Closed
Project:	MariaDB ColumnStore
Component/s:	MariaDB Server
Affects Version/s:	None
Fix Version/s:	1.0.6

Type:

Bug

Priority:

Major

Reporter:

Justin Swanhart (Inactive)

Assignee:

Unassigned

Resolution:

Fixed

Votes:

Labels:

None

Description

MariaDB [test]> drop table lost;
Query OK, 0 rows affected (2.29 sec)

Comments

Comment by Justin Swanhart (Inactive) [ 2016-06-21 ]

This is a 1 row table. Imagine dropping a schema with 30 tables, especially if tables are large. This could takes minutes.

Comment by David Thompson (Inactive) [ 2016-12-21 ]

similar to ~~MCOL-118~~ this takes about .5s in my machine. Could be related to past performance issues.

ColumnStore has more overhead to deal with because of storage per column so it's never going to be as fast as innodb.

Generated at Thu Feb 08 02:18:56 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.