Discover command to check server uptime, include the articles, news, trends, analysis and practical advice about command to check server uptime on alibabacloud.com
The showprocesslist command is very practical. Sometimes mysql runs to more than 50% or more, you need to use this command to check which SQL statement occupies more resources, and you will know which website program is faulty.
The show processlist command is very practical. Sometimes mysql runs to more than 50% or mor
issues, you can determine whether the network device is saturated through the throughput of the network device.9.sar-n tcp,etcp 1The SAR command is used here to view the status of the TCP connection, which includes:
ACTIVE/S: The number of locally initiated TCP connections per second, both of which are created by the Connect call;
PASSIVE/S: The number of TCP connections initiated remotely per second, that is, the TCP connection created
In order to check the network connection status between the daq01 and the blade server,1. Use the output rule of ping command, if can ping pass, will output 0% packet loss value; If you cannot ping the pass, the 0% packet loss is not output2. If the ping command output 0% packet loss successful execution, the network c
, sending data and other statuses to complete the SQL statement. The Info column displays this SQL statement because the length is limited, therefore, long SQL statements are not displayed completely, but an important basis for determining a problematic statement.
The most important part of this command is the State column. MySQL lists the following states:
Checking tableChecking the data table (this is automatic ).Closing tablesRefreshing the modi
State is only one of the states in the statement execution, an SQL statement that has been queried as an example, may need to go through copying to TMP table, Sorting result,sending data and other states can be completed, the info column, display this SQL statement, because the length is limited, so the long SQL statement is not complete, but a judgment question statement important basis.The most critical of this command is the State column, which is
cache, and the number of memory used for the file system page cache.8.sar-n DEV 1The SAR command can see the throughput of network devices here. When troubleshooting performance issues, you can determine whether the network device is saturated through the throughput of the network device.9,sar-n tcp,etcp 1The SAR command is used here to view the status of the TCP connection, which includes:ACTIVE/S: The nu
statuses can be completed. The Info column displays this SQL statement. Due to the limited length, the long SQL statement is not displayed, but an important basis for determining the problem statement.
The most important part of this command is the State column. MySQL lists the following states:
Checking tableChecking the data table (this is automatic ).Closing tablesRefreshing the modified data in the table to the disk and closing the used table.
was started.
If you do not start, you need to start the following command:
> Sqlplus/as SYSDBA
Sql> Startup
Sql> exit
Check if Oracle listening is started.
> Lsnrctl Status
Querying to listener information indicates that the listener has started.
If you do not start, you need to start the following command:
> Lsnrctl Start
complete the SQL statement. The info column displays this SQL statement because the length is limited, therefore, long SQL statements are not displayed completely, but an important basis for determining a problematic statement.The most important part of this command is the state column. mysql lists the following states:Checking tableChecking the data table (this is automatic ).Closing tablesRefreshing the modified data in the table to the disk and cl
When we use TFS Source control, we encounter this situation, source control will create a workspace on each client PC, and then this workspace map to the source folder on the server, when we check in, check out, our source code will be in the server to the client's workspace to operate, However, once a project team mem
Information error information is as follows:
Try to create a database named test7i24 with a password of 123456: The command is successfully executed. The command is successfully executed. Operation error, related information: [MySQL] [ODBC 3.51 driver] [mysqld-4.0.26-nt] You have an error in your SQL syntax. check the manual that corresponds to your MySQL
software, at this time, it is very likely that someone else opens a special service to you by intruding into your computer, such as the IIS information service, so that your anti-virus software cannot be found. But don't worry. You can use "net start" to check whether any service is enabled in the system. If you find that it is not your own service, we can disable this service in a targeted manner. You can directly enter "net start" to view the servi
software, at this time, it is very likely that someone else opens a special service to you by intruding into your computer, such as the IIS information service, so that your anti-virus software cannot be found. But don't worry. You can use "Net start" to check whether any service is enabled in the system. If you find that it is not your own service, we can disable this service in a targeted manner. You can directly enter "Net start" to view the servi
1.Check whether the tape library is running properlyCommand:Query drive, query path(Online or not)2.View1Backup of each node in daysStatusCommand:Query actlog begindate = today-1 search =Node name4.View1Servers within daysActivity LogCommand:Query actlog begindate = today-1 Note:ViewTSMWhen using activity logs, pay attention to the information format.Warning (Warning), Error(Error), Severe(Serious error) report to the Administrator as soon as possible
When the front-end time finds that the physical memory usage of the blog server is too high, it is to use the linuxfree command to check. this time, we will introduce this command in detail. Command
When the front-end time finds that the physical memory usage of the blog
, and the original Pb/master branch is now Paul/master. If you encounter a remote repository server migration, or if the original clone image is no longer in use, or if a participant no longer contributes code, you need to remove the remote repository and run the GIT remote RM command:$ git remote RM Paul $ GIT Remote originThree creating a remote warehouse
git clone--bare robbin_site robbin_site.gi
through the invasion of your computer to open a special service for you, such as IIS information Services, so that your anti-virus software is not to be found out. But don't worry, you can use "net start" to see what service is open in the system, if found not to open their own services, we can be targeted to disable this service.
The method is to directly enter "net start" to view the service, and then use "net stop server" to prohibit the service
| log_slow_statement | sql_parse.cc | 1461 | | Cleaning Up | 0.000018 | Dispatch_command | sql_parse.cc | 1417 |+--------------------------------+----------+-----------------------+--------------+-------------+8 rows in Set (0.00 sec) You can clearly see the cache in the hit, greatly saving the overhead of the background. Of course, the use of the cache also needs to be based on a variety of scenarios (table data size, update frequency, etc.) to investigate, not to enable caching will certainly
software, at this time, it is very likely that someone else opens a special service to you by intruding into your computer, such as the IIS information service, so that your anti-virus software cannot be found. But don't worry. You can use "net start" to check whether any service is enabled in the system. If you find that it is not your own service, we can disable this service in a targeted manner. You can directly enter "net start" to view the servi
please reload the TCP/IP protocol. Type the instructions to determine if the TCP/IP protocol is normal. If the above operation is successful, Ping, we can then enter Ipconfig to view the local IP address, and then ping the IP is its own IP, general instructions that the network card or modem work properly, is not the general rule is the network adapter failure.
Type the command to determine the network card or modem work ping own IP has an inverse v
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.