[SERVER-4785] slowms should be per database for profiler Created: 26/Jan/12 Updated: 06/Dec/22 |
|
| Status: | Backlog |
| Project: | Core Server |
| Component/s: | Performance |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | New Feature | Priority: | Major - P3 |
| Reporter: | Scott Hernandez (Inactive) | Assignee: | Backlog - Query Optimization |
| Resolution: | Unresolved | Votes: | 2 |
| Labels: | profiling, query-44-grooming, stats | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||||||||||||||||||
| Assigned Teams: |
Query Optimization
|
||||||||||||||||||||||||
| Participants: | |||||||||||||||||||||||||
| Case: | (copied to CRM) | ||||||||||||||||||||||||
| Description |
|
The slowms constant is not per database but is process wide.
Notice how slowms went to 2 in the test database... That is not good. |
| Comments |
| Comment by Asya Kamsky [ 24/Jan/18 ] |
|
Since slowms applies to profiling as well as logging, should per-db change also apply to both or to profiling only? |
| Comment by Asya Kamsky [ 24/Jan/18 ] |
|
Open questions that aren't clear and need to be clarified before implementation for this ticket can be completed (as well as for any ticket dealing with logging operations on mongos). Does the "db-only" flag apply to slowms and sampleRate? What if global setting is later changed, does the global setting override earlier set DB only setting? Or should the most "verbose" setting apply between global and per-db? |
| Comment by Asya Kamsky [ 02/Jan/18 ] |
|
SERVER-5266 was closed won't fix but if the syntax of db.setProfilingLevel is changed to only affect a single database there will be requirement to have syntax to set globally what slowms is (without having to restart mongod with new slowms setting). Note that this change as proposed is backwards breaking to every instruction given by our support which is currently assumed to have global effect. Recommend we consider non-backwards breaking syntax, like db.setProfilingLevel(0,1,false) where last parameter is "applyGlobally" and by default is true. (or applyToCurrentDB only and by default is false). |