[MDEV-17150] Bind variables using PHP with named placeholders Created: 2018-09-06 Updated: 2018-10-23 Resolved: 2018-10-23 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Data Manipulation - Subquery |
| Affects Version/s: | 10.1.35, 10.2.16 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Major |
| Reporter: | Henrik Juul-Nyholm | Assignee: | Unassigned |
| Resolution: | Incomplete | Votes: | 0 |
| Labels: | innodb, need_feedback | ||
| Environment: |
PHP 5.6 on Linux |
||
| Description |
|
(UPD: psergey edited a bit to make more readable)
No problem when sending this:
Performance fluctuating from 0.01 up to 160 s when sending this:
It is the execute() taking time. There is an index on S_T2, but it doesn't make any difference removing it. ANALYSE TABLE doesnt make any difference. FLUSG QUERY CASHE neither. The issue is hard to reproduce as repeated queries with the same parameters values run fast. Only when you are change :id parameter repeatedly the problem comes after several iterations, and then persists. |
| Comments |
| Comment by Sergei Petrunia [ 2018-09-07 ] | ||
|
Difference between OK and problem queries:
| ||
| Comment by Sergei Petrunia [ 2018-09-07 ] | ||
|
Is V_T2 a View? (If yes, can you provide its definition?) Does the server have Slow Query Log enabled? If not, is it possible to turn it on, with log_slow_verbosity=query_plan,explain ? Then, the slow query should be caught into the log, and we are interested to see what gets printed there. |