dba books

DBA ranking first: Enterprise monitor simplifies MySQL database management. for database administrators, database monitoring plays an important role. Compared with commercial database products such as Oracle and SQL Server, open-source databases have consistently performed poorly in this regard, but after MySQL launched its Enterprise edition, It brings a good news to Enterprise database administrators who use this open-source database: MySQL Enterpr

Medical inquiry a website has the SQL Injection Vulnerability (DBA permission) I want to explain to you what is "Single Love". The so-called "Single Love" means that you have sentenced me to the final death penalty in your heart, and I have sentenced you to life imprisonment! Vulnerability address:Http://oa.xywy.com/ We will capture packets and modify the user name And then drop the ing sqlmap. sqlmap.py -r 4.txt --tamper space2comment.py,base64enco

Floating HOME hotel chain stores Multiple SQL injections on a station (DBA permission/nearly orders) Floating HOME hotel chain Http://www.piaohomeinn.com injection point: Http://www.piaohomeinn.com/hotelList? Shard id = 43 Http://www.piaohomeinn.com/hotelComments? Consumer id = 37 commentId = 4906 # commentSearch Http://www.piaohomeinn.com/ajaxResp? Type = orderDetail ordersign = 20151218124430 oz Ph_user is the user information tabl

An SQL injection tool (dba permission) for a system of China Eastern Airlines) This should be a homepage ....Leaked a large amount of information about the company's employees ..... Http://bus.satrip.com/login/login.aspx_ VIEWSTATE = % blank % 2FaFpHpi1Sy % 2 BBrWwIlz % 2 Bnxc % 3D __ EVENTVALIDATION = % blank USERNAME = 111 PASSWORD = 1 * buttonlogin = % E7 % 99% BB % e9 % 99% 86PASSWORD parameter Solution: Everyone knows...

online logs. 3: If a table is dropped at 10:30:00, how can we restore it with comprehensive archiving and backup?Manually copy back all backup data filesSQL> startup mount;SQL> alter database recover automatic until time '2017-08-04: 10: 30: 00 ';SQL> alter database open resetlogs; 4: What is rman and what are its characteristics?RMAN is an important DBA tool used to back up, restore, and restore oracle databases,RMAN can be used to back up and resto

Chapter 4 operation and maintenance-routine work of DBA (1) What are the four parts of a complete Oracle network environment? A: A Complete Oracle network environment should include database servers, [Management Servers], Oracle HTTP servers, and management clients. (4) What is a session? A: session is a means for Oracle database servers to record database-connected users. (8) What are the major differences between Oracle Database Upgrade a

Common Oracle DBA operations Modify language environment Change Chinese environment to English environment Alter session set als_language = 'American '; Change the English environment to a Chinese Environment Alter session set nls_language = 'simplified CHINESE '; Queries the tables owned by the user. Select table_name from user_tables; Query the name and purpose of a data dictionary table in oracle Select * from dictionary; Query the number

, and r are sorted by the number of records, time, query time, and number of returned records, ac, at, al, and ar indicate reverse descriptions;*-T indicates the top n, that is, the number of previous data records returned;*-G, followed by a regular expression matching mode, which is case insensitive; For example/Path/mysqldumpslow-s r-t 10/database/mysql/slow-logYou can obtain up to 10 queries from the returned record set./Path/mysqldumpslow-s t-t 10-g "left join"/database/mysql/slow-logObtain

User liuya9and10 Create View Create or replace view statsAs select 'stat... '| A. Name, B. ValueFrom v $ statname A, V $ mystat BWhere a. Statistic # = B. Statistic #Union allSelect 'latch. '| Name, getsFrom v $ LatchUnion allSelect 'stat... elapsed time', hsecs from V $ timer; Reported ORA-01031: insufficient privileges permissions are insufficient, strange that I have granted the user DBA permissions, Does the role not work when creating a view?

1. What is Oracle R12.2R12.2 DefinitionArchitectureAdvantages of R12.2Limitations of R12.2What the benefit business users would get from R12.2 2. Difference between R12.1 and R12.2 ArchitectureArchitectural difference between R12.1 and R12.2Advantages and disadvantages of R12.1 and R12.23. What's online patchingConcept of Online PatchingADV and disadvantage of Online pathing cycleLimitations of Online Patching4. Installation of R12.2Installation of R12.2Installation issues and fixes5. Upgrade of

(2) test data synchronization of the standby nodeFirst insert data in the Master node's DRBD file system, we insert 20 files[[emailprotected] data]# touch ‘seq 10‘[[emailprotected] data]# ls1 10 2 3 4 5 6 7 8 9 lost+found[[emailprotected] data]# touch `seq 10 20`To view the data synchronization of the standby node, we need to mount the DRBD storage device first, and we see that the data has been synchronized.[[emailprotected] ~]# mount/dev/sdb1/mntmount:you must specify the filesystem

establishes enough database connections when it starts and makes these connections a pool of connections that are dynamically applied, used, and released by the program to the connection in the pool.5. Introduction to Storage Engine1. View the storage engine for the table: Show table status like ' table name '.2.innoDB Engine: MySQL5.5 later version, InnoDB is the default engine.Pros: 1. Disaster recovery Good 2. Support for all 4 levels of transactions. 3. Use row-level locks. 4. Implementing

. Also known as the action query language. Specific statements such as:Mysql> Delete from mysql.user where host= ' localhost ';Query OK, 2 rows affected (0.10 sec)Iii. Transaction Processing Language (TRL)Its statement ensures that all rows of the table affected by the DML statement are updated in a timely manner, and the TPL statements include Begin,transaction,commit and rollback. The main understanding of the latter two.Iv. Data Control Language (DCL)DCL Full Name (Data Control Language) It a

Recovery24.2 cold and recovery in non-archive modeSteps to 24.2.1 ColdRecovery of 24.2.2 Cold prepared24.2.3 Missing Redo log File recovery method24.3 Archive mode and non-archive mode24.3.1 Setting the archive mode of the database24.3.2 Setting the archive process parameters24.3.3 Managing archive files and archive directories24.4 steps to manually hot-standby a database24.5 How to deal with database crashes during hot standby24.6 Principle of hot preparation24.7 Backup Control files24.8 Princ

of data is too general to have a problem. Mysqldump > linzhongniao.sql Sed –e ‘s#MyISAM#Innodb#g’linzhongniao.sql > linzhongniao2.sql Mysql (3) Method 3, modify with the mysql_convert_table_format command [[emailprotected] bin]# mysql_convert_table_format --user=root --password=123456 --socket=/data/3306/mysql.sock --engin student [[emailprotected] ~]# mysql -uroot -p123456 -S /data/3306/mysql.sock -e "use linzhongniao;show create table student\G" *************************** 1. row **********

maintain the data dictionary of the database?16. Do you have development specifications, if any, how to execute the17, the table has a large paragraph x (for example: Text type), and the field X will not be updated frequently, to read as the main, please(1), you choose to split into a sub-table, or continue to put together;(2), write your reasons for such a choice.18, MySQL in the InnoDB engine is the row lock by adding on what to complete (or called implementation)? Why is that so?19. How to r

row in Set (0.00 sec)MySQL [linuxview]> DescriptionIf you do not want the field to be empty, you can add not null after the field property, and when the data is inserted, a null error will be added.Engine Set Search EnginesCharSet Setting the encoding Second, PHP Build library table Grammar:Mysqli_query (Connection,query,resultmode); {Die (' Create DATABASE failed: '. Mysqli_query ($conn));}echo "Create data table successfully \ n";Mysqli_close ($conn);?>[Email prote

asking questions, and the other is rd with no problem. However, most of the people who ask questions are important people in the company. Ask questions that represent a strong learning mind and good presentation skills.PG (Programmer) yards FarmBasically you have to have a few basic information skills to be able to do most of the information jobs 1. You must have at least one programming language C,c++,java. 2. You must be familiar with the Linux operating system (Management Management Server).

regarded as a bedroom, the entire server is a house, server hardware resources can be regarded as the house of the bathroom, kitchen is the public resources of the house. It's like being in a house in the north, so be sure to share the resources. In fact, many services can be many instances such as Nginx,apache,redias.5.1.2 MySQL multiple instances of the role and problems.5.1.2.1 Efficient use of server resourcesWhen a single server resource is left, you can take advantage of the remaining res

experience and test, in order to more comprehensive test software deficiencies or existing problems.(3) RC versionRC version belongs to a production environment before the release of a small version or a candidate, is the beta version of the test results collected by the bug or defect of the collected information, to repair and improve the product after.(4) GA version:GA version belongs to the release of software products, also known as production version of the product, in general, the product