Data We Need
A few questions and the list of data that would be most useful for analysis.
Questions for you or your team leader:
HOW DID YOU FIND US? web search, referral by ______________, Facebook, Instagram, can not remember, ________________.
Power Plan in use?
High Performance recommended for busy server
rather than Balanced or Power Saver.
For Windows, Run, powercfg.cpl to determine current setting.
Search for Linux Power Plan Settings to find a way to determine your setting.
BIOS settings could still be in your way of achieving high performance.
End of initial questions about your operating environment to be included in your email to mydatalinks@mysqlservertuning.com with your order number as the subject (assigned later), please.
If you are ONLY interested in log analysis, attach your log(s) to be analyzed and skip to POST DATA DESTINATION.
TEXT results of following requests to be "Attached" to email to mydatalinks@mysqlservertuning.com with your Invoice/Order Number leading the Subject line please.
About TEXT results: (If you choose to provide xlsx rather than TEXT data, our Suggestions COULD be DELAYED)
Using SSH for root login
From MySQL Command prompt,
A) SHOW GLOBAL STATUS; minimum UPTIME 1 business day, 7 days or more preferred
Copy results to clipboard and save to Notepad (or similar) text file.
B) SHOW GLOBAL VARIABLES;
Copy results to clipboard and save to Notepad (or similar) text file.
C) SHOW FULL PROCESSLIST;
Copy results to clipboard and save to Notepad (or similar) text file.
ALL suggestions for configuration changes
should be carefully evaluated BEFORE taking action.
POST DATA DESTINATION
After using SHOP to complete your Purchase and you have INVOICE/ORDER # make the Subject of your email INVOICE/ORDER #(assigned at purchase), please so we know which INVOICE/ORDER # your data is to be associated with for analysis, please.
TEXT results to be "Attached" to email to mydatalinks@MySQLServerTuning.com for your OFF CPU analysis processing.
Receipt of these readable attachments STARTS (or RESTARTS) your 4 Business day clock for expected email delivery of our Suggestions.
Additional information or data may be requested.