[MDEV-28372] Extremely long answer to get the result of a sql query Created: 2022-04-20 Updated: 2022-04-20 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major |
| Reporter: | Jaroslav Zeman | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Environment: |
Window 10 -> WSL Ubuntu -> Docker -> MariaDB |
||
| Description |
|
Hi After send sql query to SQL server, I always wait for an answer in minutes. when the number of rows exceeds approximately more than 100 ( In show processlist I see the status: sending data more as 200 seconds). For the sql query, I used a mysql client inside the container, so it's not a network problem out of the container. The same sql query on a mariadb server directly installed in Windows is 7 seconds (the same data, after default installation - no changes in my.cnf). Advise on how to diagnose the problem and fix it. My configuration:
Jaroslav |