Database Administrator

Mysql trigger, mysql trigger instanceCreate a trigger Delimiter $ change the end symbol of mysql to $ Create trigger the trigger contains the SQL statement to be triggered: The statement here can be any legal statement, including compound

In awr, "PHYSICAL_MEMORY_BYTES" indicates the available physical memory and physical memory. Environment: Microsoft Windows x86 64-bit, Oracle Database 11.2.0.1.0, single-host   In awr, the memory displayed by "PHYSICAL_MEMORY_BYTES" is the

Oracle uses parallel pitfalls, and Oracle uses parallel How can we quickly delete tens of millions of data records from tables with 10 million data records? You cannot directly delete the file. The best method is: 1. Use create table 2. Concurrent

Apsaradb for MongoDB basic knowledge1. Introduction: MongoDB is a distributed file storage-based database. Written in C ++. It is designed to provide scalable, high-performance data storage solutions for WEB applications.MongoDB is a product between

MongoDB usage Summary (C ),Introduction MongoDB is a non-relational and document-type database, which facilitates direct access to the class type ...... The official website provides Free courses on a regular basis. MongoDB is used in the

Mybatis exception: the element content must contain correctly formatted character data or tags ., Mybatis character When my colleague wrote a query interface today, an error occurred: the element content must consist of correctly formatted

Connect jdbc to mysql and jdbcmysql Test.java Import java. SQL. driverManager; import java. SQL. resultSet; import java. SQL. SQLException; import java. SQL. connection; import java. SQL. statement; public class Test {static Connection con; //

Make a little progress every day ---- optimize MySQL SERVER (1) and make a little progress every day1. Optimize MySQL Server 7 background processes Masterthread: refreshes dirty cache pages to data files, performs purge operations, triggers

C ++ cyclically ordered queues and cyclically ordered queues As the name implies: a queue stored in an ordered structure is called an ordered queue.Cyclic ordered queues can avoid false overflow of queues. As shown in the following special cases.

Oracle (iii) --> other database objects (Summary series), oracle --Opening section ·_·In addition to views, other database objects include sequences, synonyms, and indexes. The most important part is the sequence (associated with the trigger).

MySql master-slave replication configuration example A recent study of mysql, from the oracle official website of the latest 5.6 mysql, compressed version. Today, it took me a long time to try the Mysql replication function and share my experiences

[Oracle] RAC shared storage udev, oracleracudevThe core lies in the following two statements. The redhat 5 and redhat 6 are tested. The B c d in the statement represents sdb sdc sdd, which should be modified according to the actual situation.Redhat 5

JDBC database connection pool and jdbc database connection pool Necessary text description: Necessity of JDBC database connection pool:When developing database-based web programs, the traditional mode is basically as follows: Create a database

Install MongoDb in Windows and mongodb in windows Installing MongoDb in windows is quite comfortable. The specific steps are as follows:1; MongoDb official website, https://www.mongodb.org, according to the corresponding operating system download

Favorite common SQL statements and SQL statementsCreate Table below Create table dbo. class_bak (Name nvarchar (25) not null default 'abc' primary key, studentnumber int DEFAULT 0); insert. class_bak (studentnumber) values (23): the default value

Redis Topic 1: Data Structure and redis topic Data StructureSimple Dynamic string Redis does not directly use the traditional string representation in the C language, but builds a dynamic string SDS. When redis requires more than a string literal,

Debug stored procedures and oracle debug stored proceduresProblem background N lines of code are written in the stored procedure. As soon as the result is run, an error is reported in the database. So how can we immediately test the village crude

Enable SSD storage in MySQL, and enable ssd in mysqlAuthor of enabling SSD storage in MySQL: chszs. All Rights Reserved. It cannot be reproduced without consent. Blogger home: http://blog.csdn.net/chszs Sometimes the read/write speed of the OS

EF performance optimization, ef PerformanceOverview In the project, it took me about 1 hour and 20 minutes to use EF to store 2 W pieces of data. Then I had to worry about Optimization ......Test sketch The test sketch is for reference only. I will

Analysis of Forum database design and analysis, analysis of Forum Databases1. Database Design The Database Design of the Forum is quite interesting. The database design is split according to the business logic.First, a blog can be used as a post