Database Administrator

Reverse Engineering of MyBatis and reverse engineering of MyBatis The so-called reverse engineering is automatically generated using code. pojo and mapper corresponding to tables in the database. the xml and mapper interfaces can save writing pojo

How can I use multi-thread LRU refresh to break through the MySQL bottleneck ?, Lrumysql Guide Translation Team:Zhishutang Zang Jingge project-tianyge Team members:Tianyi Ge-Leng Feng, Tianyi Ge-JACK, Tianyi Ge-Oracle School draft:Ye Shifu

[MongoDB] 3. Basic MongoDB operations (Summary), mongodb3.mongodb Official Reference documents:Https://docs.mongodb.com/manual/reference/method/db.collection.find/ Summary: // The left side is the mongodb query statement, and the right side is the

PL/SQL Program unit: /** Insert a data record to tab_stu In the first Stored procedure **/create or replace procedure firstPro -- is equivalent to the preceding declare statement variable is

LOAD statement: Use the xp_mongoshell function in MSSQL to generate the mysql LOAD statement for the specified file in the specified folder. Declare @ SQL varchar (4000), @ dirpath varchar (1024), @ file_type varchar (16), @ target_table

Cause: 1. incomplete documentation 2. Years of forgetting 3. Employee resignation Result: A table (XZF_CASE_DISCUSS) does not know what the table is used in the view. Is it a waste table? You cannot view the view one by one! Method: Of course not

SQL SERVER XML learning Summary The latest project task is to implement a data synchronization function, and technical preparations are being made these days, mainly using Microsoft's Service Broker technology. While familiarizing yourself with this

Add one field to the tables in the production database. The field type is INT type, and the table data contains tens of millions. alter table table_name add xxoo number (4) default 0; Therefore, you must not only modify the dictionary, but also

Mongodb is deployed on a single node. I found an 8-core, 48 GB RAM server before the National Day and ran for a week under the pressure of more than 100 concurrent servers. No data loss or excessive server load was found. However, there are still

After writing the previous blog "how to design a database (iii)", I deeply felt that I was not clearly written. It took a lot of space to describe the problem, however, the solution to the problem and its advantages and disadvantages were taken over

7. Cluster Replication 7.1. Brief Description Since MySQL 5.1, cluster + replication is supported, which is undoubtedly a surprise for users who want to build a high-availability solution. In this mode, both real-time master-slave backup and cluster-

To reduce IT complexity and improve data quality, enterprises always want to integrate their businesses to fewer database platforms. However, experts believe that before the database standardization project, pay attention to cultural and technical

BKJIA exclusive Article]The company's website traffic is getting bigger and bigger, and the pressure on MySQL is getting bigger and bigger. The first step is to naturally consider the optimization of MySQL system parameters, we cannot expect the

I. Purpose When maintaining the SQL Server database, when the boss asks us to move dozens of GB of data files to other servers and requires the minimum downtime, do we have any solutions to meet these requirements? Here we assume that these two

Some Data conversion tasks in Data Flow are listed in the previous article. Here, the remaining conversion tasks are continued. Data Mining request Data Mining is a very important task in SSIS. Its idea comes from some algorithms. The data mining

I remember that it was one afternoon in. I was visiting the Internet and suddenly saw a piece of code, similar to the code above the landlord. The code was paged through DataReader. At that time, I was shocked. Is such code useless for a slightly

Modify an earlier project today. After running the project and select a query page, the system prompts "constraints cannot be enabled. One or more rows contain values that violate non-null, unique, or foreign key constraints ." . Cause analysis:

Have you ever thought about a problem? Excel is the most commonly used tool to store data. However, when the number of data items is too large, it may be inconvenient to query. Can you connect Excel with a database to facilitate data use? This

Database Table A has 100,000 records, and the query speed is normal. However, after importing one thousand data records, the problem occurs. When the selected data is between the original 100,000 records, the speed is still quite fast; but when the

This article analyzes the traditional distributed Cache system and points out that it will put a great deal of pressure on the database during Cache reconstruction. It also analyzes how the MongoDB mmap solution avoids this problem. For example, in