Database Administrator

The MySQL master-slave replication structure is based on the mysql bin-log. The slave database receives the bin-log incremental information of the master database by opening the IO process and saves it to the local relay log, then, the incremental

The last time Mysql5.6 was installed, an exception occurred after a period of time. The Mysql service could not start the process and ended: 1067. Many methods have been found on the internet, but this problem still could not be solved. I

Software environment: 1. Windows 2000 + ORACLE 8.1.7 2. ORACLE installation path: C: \ ORACLE Implementation Method: 1. Choose "start"> "Settings"> "Control Panel"> "Administrative Tools"> "services" to stop all Oracle services. 2.

When you work on a very large table, you may occasionally need to run many queries to obtain a small subset of a large amount of data, instead of running these queries on the entire table, instead, MySQL can find a few required records each time,

A single-line string function is used to manipulate string data. Most of them have one or more parameters, and most of them return the string ascii () C1 is a string and returns the ascii code of the first letter of c1. Its Inverse Function is chr ()

ORA-01650: unable to extend rollback segmentname by NUM intablespace NAME Cause: the preceding ORACLE error is caused by insufficient tablespace In the rollback segment, which is also the most common ORACLE error message of the ORACLE Data

Because group by actually performs sorting operations, and compared with order by, group by mainly only performs grouping operations after sorting. Of course, if other Aggregate functions are used during grouping, Some Aggregate functions are

A view is a logical table based on one or more tables or views. It does not contain data and allows you to query and modify the data in the table. A view-based table is called a base table. Oracle database objects are divided into five types: tables,

Each group is numbered from the beginning. For each row, the NTILE function returns the ID of the group to which the row belongs. If the number of rows in a partition cannot be divisible by integers, a Member may have two groups of different sizes.

Use Oracle Wrap tool to encrypt your code Oracle provides Wrap tools to encrypt your Package. However, the encrypted code cannot be decrypted. You need to keep your source code safe. The following is an example: 1. Source Code Create or replace

Oracle Enterprise Manager is a management framework that enables you to manage a Complete Oracle environment, including databases, iAS servers, applications, and services.Diagnose, modify, and optimize multiple databases. Tasks are scheduled at

Sometimes we encounter such a situation where the existing database needs to be transferred from one machine to another. Generally, we use export and import. However, if the database contains a large amount of data and the size of the data file is

Oracle databases are favored by more and more enterprises for their high reliability, security, and compatibility. Many database administrators are concerned about how to maintain excellent performance of Oracle databases. Based on my experience, we

Before executing an SQL statement, Oracle needs to analyze the statement execution plan and then execute it according to the execution plan. The execution plan of the Analysis Statement is completed by the Optimizer. In different cases, an SQL

"Data sharding" allows you to control data storage at the table level. "Table sharding" is a feature of the INFORMIX database. You can group records or indexes in a table and store the data in different locations. This allows you to store data on

When the sybase asa database is shut DOWN abnormally, it is prone to exceptions, such as table or index errors. The trouble is that the database will go DOWN when you delete a table using drop table t_name. Below are two common restoration methods:

How to execute a stored procedure when starting SQL SERVER? Create the stored procedure in the master database, and then find the stored procedure in the Enterprise Manager. Right-click the stored procedure and choose Properties. Select "execute

As I mentioned earlier, I am still familiar with Oracle databases. In fact, I started to contact Oracle 15 months ago. I initially thought it odd that Oracle does not have an identity type and you cannot create an auto-incrementing column. It turns

Q: How can I solve the SQL Server alarm problems? A:For specific solutions, refer to the following: ◆ Check whether you have used the latest SQL Server service pack. This is because many SQL Server warnings (Alerts) vulnerabilities have been fixed

Oracle and Microsoft are two major database products in the history of database development. This leaves little room for selection of databases, either Microsoft or Oracle. However, there is a big difference between them. Today, I will talk about