ala888 Posted December 12, 2014 Share Posted December 12, 2014 i remember distinctly that it was possible to get a list of avg read lock wait time or read queue or whatever with mysql tables... i seem to have forgotten what it is called... like some diagnostic tool to see if writes are locking out reads and whatnot Link to comment Share on other sites More sharing options...
justsomeguy Posted December 12, 2014 Share Posted December 12, 2014 MySQL keeps all of those statistics, you can see everything in phpMyAdmin. There is also a slow query log which will log queries that take over a certain amount of time if enabled. Link to comment Share on other sites More sharing options...
ala888 Posted December 14, 2014 Author Share Posted December 14, 2014 >that feeling when I dont run apache>that feeling when I dont use phpMyAdmin>that feeling when server is on aws hosted sql server any alternatives in command line ? like a sql statement or something? Link to comment Share on other sites More sharing options...
justsomeguy Posted December 15, 2014 Share Posted December 15, 2014 This doesn't have anything to do with Apache. any alternatives in command line ? like a sql statement or something?What research have you done? What things have you tried? You've looked through the manual first before asking me to do it for you, right? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now