Are these stats reasonable? If not, where should I start?SSAS queries time out when Windows File System Cache...
Should corporate security training be tailored based on a users' job role?
What prevents people from lying about where they live in order to reduce state income taxes?
Buying a "Used" Router
Smooth Density Histogram with probability areas
How to assess the susceptibility of a U.S. company to go bankrupt?
How to write pow math?
Is 'bad luck' with former employees a red flag?
Sing Baby Shark
How to make clear what a part-humanoid character looks like when they're quite common in their world?
Publication rates for different areas of mathematics?
What happens if you declare more than $10,000 at the US border?
Is it appropriate to give a culturally-traditional gift to a female coworker?
Why do most space probes survive for far longer than they were designed for?
Why is Bernie Sanders maximum accepted donation on actblue $5600?
Why do climate experts from the UN/IPCC rarely mention Grand Solar Minimum?
How to use the viewer node?
Headless horseman claims new head
Does limiting the number of sources help simplify the game for a new DM with new and experienced players?
How can I portray body horror and still be sensitive to people with disabilities?
Discouraging missile alpha strikes
How to write a character overlapping another character
How can guns be countered by melee combat without raw-ability or exceptional explanations?
Badly designed reimbursement form. What does that say about the company?
Do error bars on probabilities have any meaning?
Are these stats reasonable? If not, where should I start?
SSAS queries time out when Windows File System Cache dropsWhy are these queries slow in some environments and not others? Can we fix their performance?Are these MySQL queries efficient?What to do with unused RAM on a MySQL database server?Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQLApplication querying empty tablesVery Slow InsertsOptimize MySQL Server PerformancePage Life Expectancy (PLE), where to start?Does logical reads in RAM appears in wait stats or where?
The below is the output result of mysqladmin for our mysql server which has been having consistent problems for months since we switched from a dedicated server to the cloud. In the switch, we changed some tuning parameters, and it seems possible that one of these parameters was messed up. I'm the defacto DBA, but don't know much. I'm trying to figure out how to interpret the below:
Server version 5.7.23-0ubuntu0.16.04.1-log
Uptime: 117 days 22 hours 28 min 44 sec
Threads: 29 Questions: 1969788526 Slow queries: 143857 Opens: 11865506181 Flush tables: 1 Open tables: 512 Queries per second avg: 193.311
performance performance-tuning
asked 45 mins ago
sclscl
11
add a comment |
The below is the output result of mysqladmin for our mysql server which has been having consistent problems for months since we switched from a dedicated server to the cloud. In the switch, we changed some tuning parameters, and it seems possible that one of these parameters was messed up. I'm the defacto DBA, but don't know much. I'm trying to figure out how to interpret the below:
Server version 5.7.23-0ubuntu0.16.04.1-log
Uptime: 117 days 22 hours 28 min 44 sec
Threads: 29 Questions: 1969788526 Slow queries: 143857 Opens: 11865506181 Flush tables: 1 Open tables: 512 Queries per second avg: 193.311
performance performance-tuning
asked 45 mins ago
sclscl
11
Show you current settings?SHOW GLOBAL STATUS? Include a [mysql] tag. What exact prolems are you having.
– danblack
11 mins ago
add a comment |
The below is the output result of mysqladmin for our mysql server which has been having consistent problems for months since we switched from a dedicated server to the cloud. In the switch, we changed some tuning parameters, and it seems possible that one of these parameters was messed up. I'm the defacto DBA, but don't know much. I'm trying to figure out how to interpret the below:
Server version 5.7.23-0ubuntu0.16.04.1-log
Uptime: 117 days 22 hours 28 min 44 sec
Threads: 29 Questions: 1969788526 Slow queries: 143857 Opens: 11865506181 Flush tables: 1 Open tables: 512 Queries per second avg: 193.311
performance performance-tuning
asked 45 mins ago
sclscl
11
The below is the output result of mysqladmin for our mysql server which has been having consistent problems for months since we switched from a dedicated server to the cloud. In the switch, we changed some tuning parameters, and it seems possible that one of these parameters was messed up. I'm the defacto DBA, but don't know much. I'm trying to figure out how to interpret the below:
Server version 5.7.23-0ubuntu0.16.04.1-log
Uptime: 117 days 22 hours 28 min 44 sec
Threads: 29 Questions: 1969788526 Slow queries: 143857 Opens: 11865506181 Flush tables: 1 Open tables: 512 Queries per second avg: 193.311
performance performance-tuning
performance performance-tuning
asked 45 mins ago
sclscl
11
asked 45 mins ago
sclscl
11
asked 45 mins ago
sclscl
11
asked 45 mins ago
sclscl
11
asked 45 mins ago
sclscl
11
11
Show you current settings?SHOW GLOBAL STATUS? Include a [mysql] tag. What exact prolems are you having.
– danblack
11 mins ago
add a comment |
Show you current settings?SHOW GLOBAL STATUS? Include a [mysql] tag. What exact prolems are you having.
– danblack
11 mins ago
Show you current settings?
SHOW GLOBAL STATUS? Include a [mysql] tag. What exact prolems are you having.– danblack
11 mins ago
Show you current settings?
SHOW GLOBAL STATUS? Include a [mysql] tag. What exact prolems are you having.– danblack
11 mins ago
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f230197%2fare-these-stats-reasonable-if-not-where-should-i-start%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f230197%2fare-these-stats-reasonable-if-not-where-should-i-start%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Show you current settings?
SHOW GLOBAL STATUS? Include a [mysql] tag. What exact prolems are you having.– danblack
11 mins ago