Database Administrator

 2. How do you accelerate the patching process?Answer:2.1 you can merge multiple patches.2.2 you can create a response file for a non-interactive patch.2.3 you can apply patches with the option and run them once after all patches are applied. 3. An

I recently heard that mongodb is very popular, so I downloaded and learned something about mongodb. I will discuss it later. My machine system is ubuntu13.04. There are two ways to install mongodb: 1. Download the tar-gz package, decompress it, and

Public class TransactionTest {public static void main (String [] args) throws Exception {Connection conn = ConnectionFactory. getInstance (). getLocalConnection (); int money = 0; ResultSet rt = null; try {conn. setAutoCommit (false); Statement st =

I. Query Optimization 1. Use Indexes When there is too much data in the table, creating an index can significantly increase the query speed. Create an index SQL> CREATE INDEX name ON table (Field 1 [ASC, DESC], Field 2 [ASC, DESC]...) Delete

In addition to relying on DBA's personal experience, database optimization also requires the help of some small tools. Recently, the database server is a little slow. Let's see which aspects of the pressure is relatively high! In fact, this Lucky28

All those who have been in contact with SQL Server should now know that transaction log is an important part of any SQL Server database. Talking about logs is one of my favorite topics. Some common misunderstandings about logs may be a long article.

Instances with performance impact of the cursor type. The following two cursor scripts create and execute two types of cursor: dynamic and fast forward only. Knowledge supplement: Operations in a relational database work for the entire row set. The

Guidance:InAccess DatabaseIs embedded into a very strong database operating language-Visual Basic language, so you can use Visual Basic to write programs to implement some complex functions. The following describes how to implement encryption in the

Recently, when I first moved to a new company, I suddenly experienced a large volume of interruptions in the production database at night and lasted for nearly an hour. In the event of an accident, I was not at the scene, I missed the opportunity to

Editor's note: many friends may not know where to start when getting started with MySQL's dual-machine synchronization requirements. In fact, this is one of the functions supported by MySQL itself. This article provides a preliminary idea about

Last year, I used DiscuzNT3.0 for secondary development and performance optimization, but I have never had the chance to write down the time relationship. Let's take a long 5.1 vacation and write an article about disruptive things. I have read the

What is Cartesian product? The implementation of cartesian products in SQL is not only Cross Join ). All join methods are converted into temporary Cartesian Product tables. Cartesian product is a concept in relational algebra, the number of rows in

Yesterday, a colleague suddenly asked me, saying that when he created the following table in the SQL 2000 database, he suddenly encountered the following warning message. The SQL script and warning information are as follows: IF OBJECT_ID (N

Situation: multiple database servers with multiple databases on each server. The database structure is consistent and provided to different customers) 1. Manual Operation 1. Few Databases Select different databases from the drop-down list and

Skip the theory. I have introduced automatic sharding on the internet... directly go to the configuration. Please leave a message if you have any questions. Or test with million data Insert million pieces of data to a database without sharding. Data

I often hear that the most difficult part of SQL Server is performance optimization, which makes people feel mysterious. This kind of thing can only be done by experts. A long time ago, I saw a highly-handwritten blog on the Internet and introduced

People tend to fall into a misunderstanding when using SQL, that is, they are too concerned about whether the obtained results are correct, while ignoring the possible performance differences between different implementation methods, this

The topics in this article are as follows: Query plan Overview Query resolution Query Optimizer Query execution Reuse of query plans Query plan Overview Most of the time, when we are using SQL server, it is very simple to do: enter an SQL

Since the last article was published, I have received a lot of attention from my friends. Many friends require more practices than pure theories. Indeed, I started to work out this series based on practical ideas! At the same time, in order to make

MySQL 5.5.19 is released. Improvements to this version include: New Feature ◆ By creating a cache for the metadata lock object, the performance of the metadata Lock operation in Windows XP is improved, which allows the server to avoid high-cost