bradost

some mysql ssh

Jan 18th, 2019
183
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.88 KB | None | 0 0
  1. ======================================================================================
  2. mysqladmin pr
  3. +--------+--------------+-----------+-------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+
  4. | Id | User | Host | db | Command | Time | State | Info |
  5. +--------+--------------+-----------+-------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+
  6. | 257444 | yarbra_wpusr | localhost | yarbra_wpku | Query | 0 | Sending data | SELECT wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relati |
  7. | 257445 | yarbra_wpusr | localhost | yarbra_wpku | Query | 0 | Sending data | SELECT wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relati |
  8. | 257446 | yarbra_wpusr | localhost | yarbra_wpku | Sleep | 0 | | |
  9. | 257449 | yarbra_wpusr | localhost | yarbra_wpku | Sleep | 0 | | |
  10. | 257450 | yarbra_wpusr | localhost | yarbra_wpku | Query | 0 | Sending data | SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'
  11.  
  12.  
  13. ======================================================================================
  14.  
  15. mysql -e "\s;" |grep -i threads
  16. Threads: 6 Questions: 18031701 Slow queries: 70 Opens: 2461 Flush tables: 1 Open tables: 1150 Queries per second avg: 407.229
  17.  
  18. ======================================================================================
Advertisement
Add Comment
Please, Sign In to add comment