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.
- 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