Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.3.17
-
None
-
None
-
CentOS Linux 8.2.2004 (Core)
Description
I have two systems Windows 10 and CentOS 8.2
Windows 10 with Server-Version: 10.4.11-MariaDB - mariadb.org binary distribution
CentOS 8.2 with Server-Version: 10.3.17-MariaDB-log - MariaDB Server
I have a PHP Variable with 11.098 integer values and ask DB where I can find this values. DB have 58.088 entries. This is a analyse script and its called only by hand.
SELECT id,field2 FROM table1 WHERE field1=0 AND field2 IN (_12000_ids_);
Windows 10 with MariaDB 10.4 is very fast. ~200ms on a 8 years old laptop (home-pc).
CentOS 8.2 with MariaDB 10.3 is very slow. >10min on a modern Ryzen 9 3900 root server.
EXPLAIN for Windows 10
| id1 | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | PRIMARY | table1 | ALL | NULL | NULL | NULL | NULL | 58088 | Using where |
| 1 | PRIMARY | <subquery2> | eq_ref | distinct_key | distinct_key | 4 | func | 1 | Using where |
| 2 | MATERIALIZED | <derived3> | ALL | NULL | NULL | NULL | NULL | 11098 | |
| 3 | DERIVED | NULL | NULL | NULL | NULL | NULL | NULL | NULL | No tables used |
EXPLAIN for CentOs 8.2 (slow)
| id1 | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | PRIMARY | <subquery2> | ALL | distinct_key | NULL | NULL | NULL | 11098 | |
| 1 | PRIMARY | table1 | ALL | NULL | NULL | NULL | NULL | 58088 | Using where |
| 2 | MATERIALIZED | <derived3> | ALL | NULL | NULL | NULL | NULL | 11098 | |
| 3 | DERIVED | NULL | NULL | NULL | NULL | NULL | NULL | NULL | No tables used |
Is here a bug or is this a difference between 10.3 and 10.4?