emachine recovery management

Temporary Oracle tablespace is an important part of Oracle databases. Although this part is not presented in the cont architecture, its importance cannot be ignored. EspeciallyFrequent large operations, such as index creation and sorting, must be completed in the temporary tablespace to reduce memory overhead. Of course, you should try to avoid high query performance requirements on disks.. This article mainly describes the management and damage

structure are emptied.mysql > drop database db1; Delete DB1 LibraryThird, MySQL database backup recovery#mysqldump-uroot-p123456 mysql >/tmp/mysql.sql//backup MySQL library to/tmp directory#mysql-uroot-p123456 MySQL #mysqldump-uroot-p123456 mysql user >/tmp/user.sql//Back up the user table inside the MySQL library with a space between the library name and the surface#mysql-uroot-p123456 MySQL #mysqldump-uroot-p123456-a >/tmp/mysql_all.sql//Back Up al

Tags: Common SQL Grant default 127.0.0.1 change IP command to specify the modification of IP13.4 MySQL User management Create a user and authorize [[emailprotected] ~]# mysql -uroot -p‘taoyuan‘ //登录 mysql> grant all on *.* to ‘user1‘@‘172.0.0.1‘ identified by ‘123456‘; #创建user用户并授予其所有权限“*.*”（通配符） #第一个*表示db_name；第二个*表示tb_name #同时指定其来源IP127.0.0.1（即，只可通过此IP登录） #此处可以使用通配符%，代表所有IP（一般不使用） #identified by ：设定密码 #quit 退出 [[emailprotected] ~]#

Tags: Use Data Io management time re1. Parameters for automatic management of Oracle restored data:1. Some programs before Oracle 9i contain statements that manually specify rollback segments. This statement does not affect the final result, but reports an error on the console. Therefore, dynamic parameters are introduced.Undo_suppress_errors: manually specifying or setting a restore segment in the mode of

backup first, and compress and update the backup time cat/etc/dumpdates #查看备份时间文件 CP Install.log/boot/#复制日志文件到/boot partition Dump-1uj-f/root/boot.bak1.bz2/boot/#增量备份/boot partition, and compress dump–w #查询分区的备份时间及备份级别的备份文件或目录 dump-0j-f/root/etc.dump.bz2/etc/#完全备份/etc/directory, can only use 0 levels for full backups, and no longer supports incremental backups2, restore command [[email protected]~]# Restore [mode options] [options] mode options: The RESTORE command has the following four modes,

Tags: pass where grants Ike backup recovery instructions root no ROPOne: MySQL user managementGrant all on . to ' user1 ' identified by ' passwd ';Grant Select,update,insert on DB1. To ' user2 ' @ ' 192.168.133.1 ' identified by ' passwd ';Grant all on DB1. To ' user3 ' @ '% ' of ' identified by ' passwd ';Show grants;Show grants for [email protected];Two: Common SQL statementsSelect COUNT () from Mysql.user;Select from Mysql.db;Select db from Mysql.d

-a636.jpg "/>650) this.width=650; "src=" https://s1.51cto.com/wyfs02/M00/97/E0/wKiom1k0tXvyMYA9AACokOXMPqM571.jpg "style=" float : none; "title=" MySQL permissions list 2.jpg "alt=" Wkiom1k0txvymya9aacokoxmpqm571.jpg "/>650) this.width=650; "src=" https://s1.51cto.com/wyfs02/M02/97/E1/wKioL1k0tXvCjaNBAAFonmpuUXU519.jpg "style=" float : none; "title=" MySQL permissions list 3.jpg "alt=" Wkiol1k0txvcjanbaafonmpuuxu519.jpg "/>MySQL root password recovery

Dalvik heap memory management and recovery The Heap used by the Dalvik Virtual Machine to allocate objects is divided into two parts: Active Heap and Zygote Heap. The following describes how to allocate these two parts and manage the heap memory based on the management mechanism. Let's start with the Android system. After the Android system is started, a Zygote p

where host like ' 192.168.% ';INSERT into DB1.T1 values (1, ' abc '); InsertUpdate db1.t1 set name= ' AAA ' where id=1; Change a row of a tableDelete dataDelete from db1.t1 where id=1;TRUNCATE TABLE db1.t1; Clear the data table, the table is stilldrop table db1.t1; Delete the table, all the table data is deletedDrop database db1; Deleting a databaseThird, MySQL database backup recoveryCreate a new database Mysql2/USR/LOCAL/MYSQL/BIN/MYSQL-UROOT-E "CREATE Database Mysql2"Backup library mysqldump

specified library:[Email protected] ~]# mysqldump-uroot-p123456 Test >/tmp/testbak.sqlBack Up all libraries:[Email protected] ~]# mysqldump-uroot-p123456-a >/tmp/mysql_all.sqlTo restore the specified library:[Email protected] ~]# mysql-uroot-p123456 MySQL Restore all libraries:[Email protected] ~]# mysql-uroot-p123456 Backup table:[[email protected] ~]# mysql-uroot-p123456 mysql user >/tmp/user.sqlTo back up the table structure only:mysqldump-uroot-p123456-d mysql >/tmp/mysql_tb.sqlRecovery tab

protected];+-------------------------------------------------------------------------------------------------------------- -----+| Grants for [email protected] |+-------------------------------------------------------------------------------------------------------------- -----+| GRANT USAGE on . To ' user2 ' @ ' 192.168.15.132 ' identified by PASSWORD '59c70da2f3e3a5bdf46b68f5c8b8f25762bccef0 ' || GRANT SELECT, INSERT, UPDATE on db1 . To ' user2 ' @ ' 192.168.15.132 ' |+-----------------------

Add a new virtual hard disk to the virtual machine with the format selected as SCSISometimes you may need to restart your system to take effect!You can use the Partprobe command to re-read the partition table!The following format is to feed him partition file typeThe last is to create a mount point, the partition mounted on it!This is a mount, but there is a problem, after the restart is all invalid, need to re-mount!Description of available mount points:OK, rewrite the file that you just edited

Docker Data Management There are two main ways of managing data in a container: data volume and data volume container To mount a local directory or file in a data volume within a container A data volume is a special directory that provides a container to use, bypassing the file system and providing a variety of features Data volumes can be shared and reused directly in a containerChanges to the data volume will take effect immediatelyData updates

database open read only;Database altered.SQL> select count(1) from test; COUNT(1)---------- 23Restore data to the main library using Dblink or DataPump:Create Public database link System_snewtest connect to sys identified by "Oracle" Using ' snewtest ';INSERT INTO Test select * from [email protected]_snewtest;SQL> select count(1) from test; COUNT(1)---------- 23Re-open the MRP on the standby librarySQL> alter database recover managed standby database using current logfile disc

, void *addr) {unsigned long i = (12, again see KMEM_CACHE_REAP, traverse the Cache_chain list to find the appropriate buffer, and only released the selected buffer up to 80% of the completely idle slab block, the code is as follows:void kmem_cache_reap (int gfp_mask) {slab_t *slabp;kmem_cache_t *searchp;kmem_cache_t *best_cachep;unsigned int Best_ pages;unsigned int best_len;unsigned int scan;if (Gfp_mask __gfp_wait) down (cache_chain_sem); ElseIf (Down_ Trylock (cache_chain_sem)) Return;scan

master nodesMongoDB Backup and RecoveryBackup LibraryMongodump-h ip-d dbname-o dir//-h back with service ip-p port-d database name, do not add backup all databases,-o backup directoryBack up the specified collectionmongodump-d mydb-c testc-o/tmp/test//-c The name of the specified collectionExport Collection as JSON filemongoexport-d mydb-c testc-o/tmp/testc.json//-O followed by the name of the fileRecover all the librariesMongorestore--drop/tmp/123//--drop Delete the original library and then r

First, Sys landing Instance: $ sqlplus/as SYSDBA Sql*plus:release 10.2.0.4.0-production on Wed Nov 3 07:35:34 2010 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. Connected to a idle instance. ----------------------------------------------------- Second, prepare the library to boot to the management recovery mode Sql>startup Nomount; Sql>alter database mount standby database; Sql>alter data

Tags: backup table mysql backup and restore common SQL statements create MySQL users and authorizeMySQL User managementA new user who creates a specified IP can access some of the MySQL library's tables. All tables for all libraries, if you want to specify access to certain tables of a library, you only need to modify the nameUser1 specified user name br/>@ the IP that follows is the specified ip,% represents all IPVerify login with User user1You can also specify localhost,You can access it with

Oracle-full recovery of user management (iv) I. the role of resetlogs 1. reset the current log serial number to 1, discard all previous log information, you can delete them on the operating system; 2. in non-archive mode, if online redo logs are lost, you can create it 3. update the information in the control file. 4. update all current data files, redo log files online, and archive log files with the new S

active queue ?The answers are in, Page_launder and Reclaim_page.Page_launder:if (pagetestandclearreferenced (page) | | | page->age > 0 | | At this point the reference count is greater than 1 (!page->buffers page_count (page) > 1) | | Page_ramdisk (page)) { del_page_from_inactive_dirty_list (page); Add_page_to_active_list (page); Continue Reclaim_page:if (pagetestandclearreferenced (page) | | | page->age > 0 | |