Database Administrator

Efficient data migration using the table space technology that can be transferred This article demonstrates the Oracle tablespace migration process and many precautions. Tutorial objective: to migrate the tablespace TBS_SEC_D on the oracle 10g

Install the database Oracle client in Ubuntu 16.04 Install the Oracle database client in Ubuntu 16.04 to connect the Django project to a remote Oracle database. 1. Download the oracle client installation package: Go to

Principle and Practice of MySQL master-slave Replication MySQL master-slave ReplicationMySQL master-slave replication copies the SQL command set originally created and modified databases to the slave database, and re-executes these SQL commands

Oracle cold Backup Recovery Process memoI. Fault approaching At noon one day, the mains supply was accidentally interrupted, and the UPS Power Supply in the IDC did not take over the power supply due to heavy load. All servers were restarted

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

The simplest MySQL tutorial in history () "transactions (below )」, Tip: This series of blog posts have been synchronized to GitHub. The address is "mysql-tutorial". Thank you for your interest.Star,Fork, Error correction. Tip: In transaction

Dry Goods | Spark SQL metadata dual-master high availability solution secrets, spark metadata Click "ZTE developer community" at the top to follow us Read an original article by a front-line developer every day Source | ZTE Big Data " Open-source

See you on Thursday | from 50 to 0.59 seconds, making SQL optimization impossible by Songhua, IT Jianghu baixiaosheng SpeakerGuest: Zheng Songhua Zhishutang "SQL optimization and Development" course instructor No.: qidan3500 Daniel

Dbcp2 data source configuration details, dbcp2 details DBCP2 detailed configuration table common link configuration Parameters Description Username User name passed to the JDBC driver for connection Establishment

Detailed description of Database Server construction and deployment check list, detailed description of Database Preface We may often install and deploy database servers, but we may suddenly forget a certain setting, which poses a risk for future O &

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

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

In many cases, we will set a field in the database table: ID, which is an IDENTITY, that is, an auto-increment ID. When the concurrency is large and this field is not the primary key, it may repeat this value; or in some cases, for example, an error

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

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

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

Summary What is client data storage? Simply put, data is stored on a specific client, reducing the number of requests to the server. Why is client data storage required? In the response time, the time taken by the http request response cannot be

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