Database Administrator

Binlog Processing Method for MySQL DATA Recently, the disk has grown very fast and it is found that binlog logs occupy a large amount of disk resources. We use manual cleanup, and set Automatic cleanup later. View the specified deletion log Mysql>

The Oracle 11g empty table cannot be exported. The deferred_segment_creation parameter is added to the Oracle 11g. The default value is true when the database is created. This parameter means delayed loading. When no data exists in the table, no

Oracle implements mysql update limit and oraclemysql Oracle seems to be lagging behind and inconvenient to use. The Toad software is stupid and slow, and pl/SQL is even more. The interface style in 1990s is slow. Oracle does not support limit. By

Oracle implements find_in_set sorting for mysql !, Oraclefind_in_set Oracle implements sorting similar to MYSQL find_in_set, function decode: select * from tb_info_game where gameid in(23,20,19,26,18) order by decode(gameid,23,1,20,2,18,3,26,4,1009,

Atitit. Concurrency test solution (2), atitit Solution Atitit. Concurrent Test Solution (2) ----- obtain random database records and randomly extract data for random sorting   1. Application Scenario 1 2. Principles of random data extraction 1 3.

[Rman, 1] Typical Incremental Backup case and rman Incremental Backup caseI. Backup policy:1. sunday evening-level 0 backup completed MED (full backup) 2. monday evening-level 2 backup interval med3. Tuesday evening-level 2 backup interval med4.

Oracle clears the high waterline of the table, and oracle clears the waterlineWhen a new record is added, HWM moves up slowly, but HWM does not move down after the record is deleted. Therefore, when you use the delete from command to delete a large

Mutual conversion between the ORACLE database SCN and time, and the oracle database scn SCN (System Change Number (SCN) isOracleDatabaseAfter the update, the DBMS automatically maintains a progressively increasing number, which can be understood as

Use PRODUCT_USER_PROFILE To Limit User, productprofileThe PRODUCT_USER_PROFILE (PUP) table provides product-level security that supplements the user-level security provided by the SQL GRANT and REVOKE commands and user roles. to create the PUP table,

Data center charging system-Report (2), data center charging system report Ii. Code Compared with the previous excel, I think the report is a bit the same. The general idea is as follows: First. (Report: Dim Withevents object variable As

Database learning experience and learning experienceDatabase learning experience is a new concept for us. Of course, the premise is that before we learn it, the first impression of this course is very abstract, it should be difficult and tiring to

High aggregation, low coupling, and low coupling This is a concept in software engineering. First, you must know that a software is composed of multiple subprograms, and a program is composed of multiple modules (methods! Cohesion refers to the

Oracle flexibly inserts data through query insert into... select..., oracle... select. Insert into reg_user (id, name, password, area_code, reg_time, first_pswd, record_type) select l. reg_user_id, l. entry_person, '4qrcoum6wau + VuBX8g + IPg =

SQL Server is the storage process for code reduction, and SQL reduction The stored procedure can be used to improve the database query efficiency because it has been compiled in advance and stored in the memory. It is very efficient because it does

Summary of SQL video and summary of SQL I still like short videos in English for 7 to 8 minutes. The VB videos of Mr Chen Wei and the SQL videos of Mr Yan jianling are all between 30 and 40 minutes. One tomato is not enough and two tomatoes are not

Swingbench for oracleRAC usage illustration, swingbenchSwingbench for oracleRAC usage illustration 1 Swingbench1.1 OverviewThis isOracleAn employee of UK developed on the basis of a abandoned project. The current stable version is 2.2, the latest

In oracle db, the calculation formula of a data dictionary pct miss is oraclepct. This article is an original article. For more information, see the source: Http://blog.csdn.net/msdnchina/article/details/38766801   The data dictionary mentioned

SQL Server, sqlserver A trigger is an addition, deletion, and modification operation on a table, which causes or triggers the addition, deletion, and modification operation on another table. Therefore, the trigger has three types: deleted trigger,

Oracle Performance Analysis 3: TKPROF introduction, oracletkprof Tkprof is a command line tool that comes with Oracle. It is mainly used to convert the original trace file to a formatted text file. The simplest way to use it is as follows: tkprof ly_

Zero Point download. The first version of the autumn version of the xinxing mysql tutorial in 2014 has been completed. We look forward to your support. After a period of unremitting efforts, in the end, the first version of the autumn version of