Database Administrator

In this article, we will introduce you in detail how to upgrade the dynamic InnoDB Plugin, how to upgrade the InnoDB Plugin with static compilation, and how to convert the compressed tables created in versions earlier than 1.0.2. I. Overview Thanks

Previously, we followed the author to review the query algorithm and partial Sorting Algorithm in the data structure. Now we continue to follow the author to learn some basic sorting algorithms. Select sort Usage conditions:A set of comparable sizes.

This article describes an efficient algorithm for generating non-repeated random series, which is much faster than commonly used hashtable deduplication methods. First, let's look at the proposition: Given a positive integer n, an array with a

Today, I used the attach function of SQL Server 2008 to attach a database. A problem occurred. The error message is: Unable to open physical file "D:\Documents\Dalt\XXXX.mdf" Operating system error 5: "5(error not found)" (Microsoft SQL Server: 

In project development, the core work of most developers is how to store and access data. To perform data operations, we must first solve several basic problems: 1. How to establish a connection with a database. 2. How to read data from the database.

I recently modified a paging storage process. As a newbie, I still benefited a lot from it. Now I will start my paging journey today.1. Start Restoration Next, let's take a look at the original paging stored procedure. Alter procedure [dbo].

◆ Introduction Before reading this article, I must clearly tell you that I am not a master in the database design field. The 11 points listed below are my personal opinions on my experience gained from project practice and reading. I personally

In fact, I have been preparing the basic materials for another blog post, but I chatted with my friends and asked me what I was doing recently. I said I was working on the System Log Module, after talking with him, this blog came into being. All

Greg Robidoux, a Microsoft SQL Server security expert, is also the chairman of the SQL Server database administrator Special Interest Group PASS DBA SIG. "It usually takes time to make the application run, and security issues are not even discussed,"

Web development involves two aspects: layout and content.On the layout, the CGI Module of PERL is powerful and easy to use. In just a few lines, HTML webpages can be dynamically generated. To be fair, you must use a database to manage the content.

Concept The server first sorts the data in the memory area specified by sort_area_size. If the required space exceeds sort_area_size, the sorting is performed in the temporary tablespace. In dedicated server mode, the sorting space is in PGA, and in

I. MySQL: indexes are saved in B-tree format. The Memory storage engine can select Hash or BTree indexes. Hash indexes can only be used for Equality comparison of = or . 1. Common index: create index On Tablename (column list) Alter table

Basic Concepts Nested loop join: Each row in the Outer table joins the corresponding records in the inner table, similar to a nested loop. Sort merge join: Sort the two tables and then join them. Hash join: Create a Hash table in the memory to scan

Database performance optimization Oracle features: Partitioning technology Partition Index More record tables and indexes. Create an index or partition. Partition Index Basic principle: the physical location of the created table must be different

There are two very small processes in the Oracle database, but their role is very huge. Because it is relatively small, it is often ignored by the database administrator. This time I will remind you not to ignore the role of these two processes. If

I recently focused on database security and roughly studied the independent access control (DAC) and Mandatory Access Control (MAC) of databases ), now I have written my understanding of the DAC in Oracle and shared it with you. All the above

Guidance:Setting a single database for each instance or server enablesDatabase ManagementMore convenient. However, this will soon increase the cost of your database solution because you need to purchase a new server or a new SQL server license for

I used to mix dba and sysdba. Today I am discussing the differences between them in the Forum. The special record is as follows:   SYSDBA is not a permission. When a user logs on to the database as SYSDBA, the user will become SYS. You can log on

With the development of enterprise business, there are more and more large data warehouses, and their scale is also expanding rapidly, increasing by three times every two years on average. Large Data Warehouses require scanning dozens, hundreds, or

1. MongoDB shell MangoDB is actually a database shell. It is generally assumed that it runs on the same machine as mongod and that mongod is bound to the default port. If this is not the case, you can specify these parameters at startup to connect