More SSH/Command Line MySQL commands
I noticed that my previous post with basic MySQL SSH commands was relatively popular and I’ve been meaning to save some of the recent ones I’ve been using before I forget them, so…
show full processlist;
This shows all the processes (queries) running on the server at the moment you run it. Helpful if the server is running slow to see which queries might be causing the slowness.
show status like ‘qcache%’;
This shows several variables related to your MySQL query cache (see below). Important to note are the following:
- Qcache_free_memory – how much memory you have available for caching
- Qcache_inserts - if this number is larger than your Qcache_hits, it probably means your MySQL acche is not being used properly
+————————————-+———+
| Variable_name | Value |
+————————————-+———+
| Qcache_free_blocks | 798 |
| Qcache_free_memory | 4161824 |
| Qcache_hits | 9260760 |
| Qcache_inserts | 4366152 |
| Qcache_lowmem_prunes | 595048 |
| Qcache_not_cached | 304800 |
| Qcache_queries_in_cache | 7729 |
| Qcache_total_blocks | 40040 |
+————————————-+———+
Recent articles
- Top Browser Resolutions for Jan 201218 Feb 2012
- Jesus > Religion12 Jan 2012
- Nobody Tells This to Beginners09 Jan 2012
- Over 300,000 Free Icons02 Jan 2012
- Proverbs 22:29 NKJV05 May 2011
Reading this reminds me of my old area mate. That guy was a single of the smartest human beings I know, but he was a little odd for my tastes although. Anyways I appreciated studying this, thanks. Will give me a thing to go into when I see him.
It’s the best time to make some plans for the future and it’s time to be happy. I’ve read this post and if I could I wish to suggest you some interesting things or advice. Maybe you could write next articles referring to this article. I wish to read even more things about it!