uptrends uptime

(){# Echo $ MYSQL $ @Echo "show slave status \ G" | $ MYSQL $ @ | perl-p-e's/: \ s (. *) $/= "$1 usd/g; s/^ \ s + // g; s/^ \*. * \ * //; '> $ VAR_LOG}Function check_slave_results (){If ["$ Slave_IO_Running" = "Yes"] ["$ Slave_ SQL _Running" = "Yes"]; thenIf [$ tmp_code-ne 0] [$ Seconds_Behind_Master-gt 100]; thenCode = 2Elif [$ Seconds_Behind_Master-lt 50]; thenCode = 0ElseCode = 1FiElseCode = 2Fi}If [$ #-le 0] | ["$1" = "-h"]; thenUsageFiIf ["$1" = "-s"]; then# Echo "Check slave mode"Check_

If you want to write ruby code on your own and deploy it at any time, you can view it everywhere. The heroku domain name is unfriendly and slow in China, so I think of capistrano, so I started learning... Capistrano Https://www.evernote.com/shard/s6/sh/72a2b7c8-d531-4efc-9e16-ac82af2a92b7/e54fca8a9e7014ad87c79e7a7a5538c4 Capistrano new version installation Http://capistranorb.com/documentation/getting-started/preparing-your-application/ Http://capistranorb.com/ # Deploy in GemfileGem 'capis

Tags: showstatus; flushstatus; view current number of connections SHOWSTATUSLIKE ' thread_% '; Thread_cached: Number of threads cached thread_running: Number of threads active thread_connected: Number of threads currently connected thread_created: The number of threads that are created in total cachehitsthread_connected=showglobalstatuslikethread_ Created connections=showglobalstatuslike ' Connections '; Tch= (1- (threads_created/connections)) *100 View active connection content showprocesslist

%, creating a connection takes time and increases the number of thread_cachedQPS(query throughput per second) MyISAM engineQuestions = SHOW GLOBAL STATUS like ' Questions ';Uptime = SHOW GLOBAL STATUS like ' Uptime ';Qps=questions/uptimeTps(number of things transferred per second), that is, the number of transactions processed per second by the server, and if InnoDB is displayed, no InnoDB will be displayed

There are two sorting fields, the update time: upTime release time: After the addTime article is published, there will be its release time. If you modify the article, a modification time will be saved. Sort data on the homepage according to the following rules: 1. If an article with an update time uses upTime, only the published time uses ad..., there are two sorting fields, Update Time:

Original post address:Http://community.csdn.net/Expert/topic/3662/3662135.xml? Temp =. 4289972. -- Test DataCreate Table Tb (ID int primary key, grade varchar (10), uptime datetime)Insert TB select 1, 'A', '2017-12-11'Union all select 2, 'B', '2017-12-11'Union all select 3, 'C', '2017-12-11'Union all select 4, 'A', '2017-12-12'Union all select 5, 'C', '2017-12-13'Union all select 6, 'C', '2017-12-13'Union all select 7, 'A', '2017-12-14'Union all Selec

] [$ Seconds_Behind_Master-gt 100]; thenCode = 2Elif [$ Seconds_Behind_Master-lt 50]; thenCode = 0ElseCode = 1FiElseCode = 2Fi}If [$ #-le 0] | ["$1" = "-h"]; thenUsageFiIf ["$1" = "-s"]; then# Echo "Check slave mode"Check_mysql_slave_status $2FiCode = 0Check_mysql_status $2. $ VAR_LOGPER_SECOND_QUESTION = 'echo "$ Uptime $ Queries" | awk '{printf ("% 4.3f"), $2/$1} END {if ($2/$1 Tmp_code = $?If [-z $ Uptime