Status: Closed (View Workflow)
Affects Version/s: 10.1.19, 10.2, 10.1.24, 10.1
Component/s: Admin statements
CentOS release 6.8 (Final)
Linux db32119.bfi3.service-now.com 2.6.32-642.15.1.el6.x86_64 #1 SMP Fri Feb 24 14:31:22 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux
Also see it on CentOS 6.2.
MariaDB 10.1.19 and 10.1.24 have been tested and exhibit the slowness
Querying INFORMATION_SCHEMA repeatedly using CentOS 6 becomes slow in MariaDB 10.1 (10.1.19, 10.1.24).
With a basic table, and simple repeated SELECT from I_S, on CentOS 6, thus far, we see a slowdown. It remains sub-second from my testing on Windows, even up to 2K iterations.
I will provide the CREATE TABLE and test case in a private comment.
Here are a sample of times from 10.1.19 (compared to times on MySQL 5.5 and 5.6) on CentOS 6.8:
And here are times from Elena (10.1.24 on CentOS 6.2) using test case provided:
This latter one is faster than the first one, but still not sub-second.