MySQL replication. As shown in the following examples: MySQL Replication The entire process is reflected from the server, corresponding to three sets of log information, can be viewed from the server with the following command: mysql> SHOW SLAVE STATUS; Master_log_file Read_master_log_pos: Primary log information for the next transfer. Relay_master_log_file Exec_master_log_pos: The main log information f
14. Create a new directory under version control
SVN mkdir: Create a new directory under version control.Usage: 1, mkdir PATH ...2, mkdir URL ...Create a directory for version control.1. Each directory specified in the working copy PATH will be created on the local side and addedSchedule to be submitted for the next time.2. Each directory specified as a URL will be created by submitting it immediately to the warehouse.In both cases, all intermediate directories must exist beforehand.
15. Rest
State management commands are divided into LNMP State management commands and Lnmpa State management commands, Lnmpa represents Linux under Nginx, MySQL, PHP, Apache, such as the Web server architecture, is the combination of lamp and lnmp the advantages of the new Web server architecture.LNMP Status Management command:LNMP State Management:/ROOT/LNMP {start|stop|reload|restart|kill|status}Nginx State Manag
disk.Max_used_connections the maximum number of connections that are used at the same time.Not_flushed_key_blocks a key block that has been changed in the key cache but has not been emptied to disk.Not_flushed_delayed_rows the number of rows waiting to be written in the Insert delay queue.Open_tables the number of open tables.Open_files the number of open files.Open_streams Number of open streams (primarily for log records)Opened_tables the number of tables that have been opened.Questions the n
Statistical information Area
The first line: task queue information, with the execution results of the uptime command, the parameters are described as follows:
20:54:06: Current system time
Up 525 Day, 4:57: The system has been running for 525 days, 4 hours, 57 minutes.
8 Users: Currently logged in user has 8
Load average:2.68, 2
The SS command is used to display the socket information in the active state. The SS command can be used to get socket statistics, which can display and netstat similar content. But the advantage of the SS is that it can show more and more detailed information about TCP and connection status, and is faster and more efficient than netstat.When the number of socket
the contents in order of "amount of swap area", "total used area of interaction", "Total idle swap area", "buffered intersection The total number of swap zones.
The top command line 5th "PID USER PR NI VIRT RES SHR S%cpu%MEM time+ COMMAND" is displayed in order "process ID", "Process owner", "Priority", "nice value", negative indicates high priority, positive Values represent low priority, total virtual m
[Windows] netstate command status Parsing
1. Listening status
After the FTP service is started, it is in the listening status.
When the State is displayed as listening, it indicates that the port is in the listening state, that is, it is open and waiting for connection, but it is not connected yet. Just as the door of
tree structure with ASCII characters, expressing the relationship between the programs.7) ps-h shows the tree structure, indicating the relationship between the programs.8) Ps-n shows all the programs except the program under the PS Command Terminal.9) PS s uses the program signal format to display the program status.PS S when listing programs, including interrupted sub-program data.ps-tPS U Displays the status
MySQL Performance command:List the current connections for all users:> Show processlist; (only the first 100 lines are shown)> Show full processlist; (Show all connections)View all MySQL information:> Show status;To view the number of processor threads that are using deferred inserts:> Show status like '%delayed_insert_threads% ';Maximum number of connections used at the same time:> Show
The command line to view the running status of the Memcache is primarily a stats command, as follows:
(1) First through the Telnet command to connect to the Memcache, command: Telnet 127.0.0.1 11211
(2) Direct input stats can get the current memcache state.
For the memcac
Router configuration basics-set the dialog process
1. router>
The vro is in the USER command status. You can view the connection status of the vro and access other networks and hosts, but cannot view and change the vro settings.
2. router #
Enter enable at the router> prompt, and the vrouter enters the privileged command
The status command is used to view MySQL state informationMysql>Status--------------/usr/local/mysql/bin/mysql Ver14.14Distrib5.5. +, forLinux (x86_64)usingReadLine5.1Connection ID: theCurrent database:current User: [Email protected]ssl:notinchusecurrent pager:stdoutusing outfile:"'Using delimiter:; Server version:5.5. +Source distributionprotocol Version:TenConn
Command for viewing system status in Linux
Iostat
The iostat command details the storage subsystem. You usually use iostat to monitor the running status of the storage subsystem, and detect the slow input/output before the user notices that the server is running slowly. Believe me, you should discover these problems be
the conflicting condition. But it won't recover.Directories that were deleted16. Code Base URL ChangeSVN switch (SW): updates the working copy to a different URL.Usage: 1, switch URL [PATH]2. Switch--relocate from to [PATH ...]1, update your working copy, map to a new URL, its behavior is similar to "SVN update", will alsoThe files on the server are merged with the local files. This is the one where the working copy corresponds to a branch or tag in the same warehouse.Method.2, rewrite the work
Pstree: displays the Process status tree.
Purpose: run the pstree command to list the current processes and their tree structure.
Usage: pstree [Option] [pid | user]
The main options are as follows.
--A: displays the command and complete parameters of the execution program.
--C: cancel the program with the same name and merge and display the program.
--H: process
. This field is zero when this thread is caught by a subordinate server I/O thread and goes into an idle state, waiting for more events from the I/O thread. In summary, this field measures the time gap between the subordinate server SQL thread and the subordinate server I/O thread , in seconds. If the network connection between the primary and secondary servers is faster, the subordinate server I/O threads are very close to the primary server, so this field can indicate very closely how much of
table14.check_timeCheck the last time of a table using the Check table or Myisamchk tool15.CollationDefault character set and character collation for tables16.ChecksumIf enabled, the checksum is computed for the contents of the entire table17.create_optionsAll other options when the table is created18.CommentContains additional information for the MyISAM engine, which contains the comment Xu Peoni, if the table uses the InnoDB engine, the remaining space of the actual table. If it is a view, th
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.