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 |
+————————————-+———+
October 13th, 2009 at 4:49 am
Hello,
We are interested in becoming a sponsor on your home page. Can you kindly let em know what types of advertising options are available?
Thanks,
Yavar
October 22nd, 2009 at 9:30 pm
looks like a real magazine
October 28th, 2009 at 11:31 am
Hi,
Really this site is very helpful for the web designers and this post solves my problem .
Thanks.
November 1st, 2009 at 7:30 am
thanx for post
November 25th, 2009 at 6:16 am
thanks for your info, very good work.
November 30th, 2009 at 11:12 pm
Hello, you have written a very informative article. Thank you. By the way, I invite you to share your knowledge with more people in my website – http://www.eiksys.net/say
Thank you
With regards,
December 15th, 2009 at 1:30 am
Hello, you have written a very informative article.
Thank you.
December 22nd, 2009 at 8:05 am
We are interested in becoming a sponsor on your home page. Can you kindly let em know what types of advertising options are available?
Regards,
zubair mehar,
Happy new year
January 4th, 2010 at 7:40 am
I think it look like a magazine in itself.
January 18th, 2010 at 7:21 am
do you know how to change content based on location of the computer or ip address??
alternativeenergyblog.net
January 20th, 2010 at 3:11 pm
i even know sql its used in RAC installation in oracle ssh has wider implementation
greenenergyequipment.org
February 1st, 2010 at 2:34 pm
I’m still new to MYSQL and I’ve been looking to some of your post for tips, just want to say that you doing doing a great job in this site thanks and keep it up.
March 13th, 2010 at 6:45 am
very nice sharing
May 7th, 2010 at 11:17 pm
صور دردشه صوتيه شات صوتي دردشه منتديات صور دليل دردشات
July 21st, 2010 at 9:21 am
I am new to mysql database find the blog while go ogling,thanks for the tips for beginners like me..
July 31st, 2010 at 4:55 am
Samimi Sohbet , Chat Odaları , Seviyeli Sohbet , Chat , Sohbet Odalari, Sohbet
Odaları, Chat Odalari, Sohbet Yap , Chat Yap Kelebek Sohbet, Mirc Sohbet,
kelebek chat,
August 6th, 2010 at 12:49 am
listbox en vb 6concierto de la academia
August 23rd, 2010 at 4:33 am
Nice Sharing
August 25th, 2010 at 2:46 am
Thanks for sharing