mp2 maintenance

In recent years, domestic and foreign CMDB failure cases abound, few successes, some questioned the CMDB is dead? but a variety of business scenarios show that the current data center operations, the CMDB is still an indispensable part, it carries the foundation of operation and maintenance, mastering the lifeblood of operations.Analysis of past failure cases, quietly think about, failure is nothing more than two points:First, The CMDB itself is not b

------------------------- ------------------------- -------- ---------- -----------P_andy idx_pandy_id unusable 0 1--Rebuilding the indexsql> ALTER index IDX_PANDY_ID rebuild;Index altered.--View index statusSql> Select Table_name,index_name,status,blevel,leaf_blocks from user_indexes where index_name = ' IDX_PANDY_ID ';table_name index_name STATUS Blevel leaf_blocks------------------------- ------------------------- -------- ---------- -----------P_andy idx_pandy_id VALID 0 1--Truncate multiple

Background The release is dense and the project manager decides to publish and launch a version every week to meet customer and leadership requirements. The function changes frequently, the corresponding table structure, the table data change is also more frequent. Products meet two deployment scenarios, one is the headquarters deployment, the project team directly to maintain, for internal customers to use, and second, Customer Self-installation, upgrade and

operations. This is called the reaching. But note that some additions and deletions with a where condition, in these cases, some indexes can improve performance, such as the millions of the table to delete a row of data, if there is no index (assuming that even the clustered index does not), then only scan the entire table delete, in the formal environment to try to know, the speed is simply unacceptable. Too many indexes also cause the database to "volume" to become larger. In essence, the p

When a vro or vswitch is added to the network, how does the existing network device automatically discover this "new neighbor? For Cisco, the CDP Discovery protocol works. In short, CDP discovery protocols are used to obtain information about neighboring devices. The information includes the type (vswitch or vro) of the connected device, the interface of the connected vro, the interface of the local connection, and the number of devices. In this article, I mainly want to introduce the

Server Security Maintenance Tips 1: Start from basics When we talk about network server security, the best advice I can give you is not to be a layman. When a hacker starts to launch an attack on your network, the hacker first checks whether there are common security vulnerabilities before considering more difficult means to break through the security system. Therefore, for example, when the data on your server is stored in a FAT disk partition, even

How much do you know about server maintenance? Here, I will show you some things I know. First, I hope to give you a basic reference, and second, I hope it will arouse your awareness of server maintenance. 1. Power Control Although a server is not as fierce as an Induction Cooker, It is weaker than an ordinary PC, and it is also a heavyweight power user. The most basic point of server hardware application i

Related Articles: how to conduct MySQL database table Fault Detection how to fix MySQL database tables how to lock MySQL database tables how to maintain MySQL Database Log Files create a database table maintenance specification on a regular basis instead it is a good idea to check the database table only when the problem occurs. A precaution should be taken into account Related Articles: how to conduct MySQL database table Fault Detection how to fix M

Part-time website maintenance management Business Scope: (1) network maintenance (including Intranet lines-Internet Web servers) (2) website content Update (data page) (3) Signing Agreement --------- number of monthly update pages, such as: 40 page updates per month/at least 4 images (4) Intranet computer system maintenance (450 yuan service/limited