[MDEV-13375] back_log ignored Created: 2017-07-23 Updated: 2017-08-19 Resolved: 2017-08-14 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Configuration, Documentation |
| Affects Version/s: | 10.2.7 |
| Fix Version/s: | 10.2.8 |
| Type: | Bug | Priority: | Major |
| Reporter: | Reindl Harald | Assignee: | Sergei Golubchik |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Environment: |
Fedora 25 x86_64 |
||
| Description |
|
https://mariadb.com/kb/en/mariadb/server-system-variables/#back_log besides that the value is completly ignored - from where comes the 110 when the docs say it would be the same as "max_connections" which is on 300?
|
| Comments |
| Comment by Reindl Harald [ 2017-07-23 ] |
|
see also https://bugs.php.net/bug.php?id=74971 - the "HY000/2002): Resource temporarily unavailable" needs to go away because the machine itself is far away from overload when it respons within 0.003 seconds on additional requests from the browser due benchmarks are running |
| Comment by Elena Stepanova [ 2017-07-31 ] |
|
For the original issue (about back_log value): it is not completely ignored, but the actual rules for its setting are indeed far from what the KB says. I'm not even sure it's a documentation issue only, possibly it needs to be fixed on the server side as well. Apparently the current rules for back_log are such:
I'll leave it to serg to decide if it's supposed to be this way, and also what to do with the issue in the comment. |
| Comment by Reindl Harald [ 2017-07-31 ] |
|
frankly when i set a value i mean that value without any "but" or "if" - there is no point to autosize something any longer - you can warn in the error log for whatever reason and if i find out that the value has the desired result of running a benchmark on a 6 years old machine wihtout database connecetion errors i will write another bugreport - but leave my config values in peace or at least mention in the errorlog that you don't care about them instead make the databaseserver like a gambling machine |
| Comment by Sergei Golubchik [ 2017-08-12 ] |
|
I don't think it was supposed to be quite that way. I'll do this:
I think this was the original intent. |
| Comment by Reindl Harald [ 2017-08-12 ] |
|
"If back_log value is specified to be larger than max_connections, it's clipped to be equal to max_connections" is at least better than the current behavior but in reality a so called "backlog" is used to keep new connections in a queue instead let the client fail hard and this makes a lot of sense because it helps due load-spikes keep the active threads as low as configured, don't fail every new connection immediately but let them suceed as soon as a previous connection closed and no timeouts exceeded |
| Comment by Sergei Golubchik [ 2017-08-13 ] |
|
I agree. Removed "larger than max_connections" logic altogether. |
| Comment by Reindl Harald [ 2017-08-19 ] |
|
looks way better with 10.2.8 - no single "HY000/2002): Resource temporarily unavailable" message in the application errorlog Concurrency Level: 150 |