start:disclaimer
I'm not a MySql Server DBA; I know mostly of MSSQL - which is why I need your help.
end:disclaimer
I've been asked to check why the MySql server engine is performing poorly - I have not seen nor held the databases involved and would like to know where to start.
Where do I start?
What questions should I be asking those who have access to MySql - I don't even know if they are using phpmyadmin or some other tool.
Essentially:
- What items should I ask for and how would I respond to each piece they give?
What are the key items to ask for when the issue is in the performance of the database?
in MSSQL I can check sp_who2
for existing connections to see if anything is blocking, what is the counterpart in mysql?
* do not have to be specific as there can be many kinds of results for each item but would like to help get the ball rolling since it is affecting users - apparently they set up the mysql engine without having a dba on-board.