Jump to content
Sign in to follow this  
ala888

diagnostic mysql table locking

Recommended Posts

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...