Database Administrator

Source: http://blog.csdn.net/dba_huangzj/article/details/26951563 What is an image? To put it bluntly, it's a mirror (no mirror? Do you always need to urinate without a mirror? Joke .. ). Here, the mirror has two meanings: 1. They are identical. The

I believe that the visitor here has read a lot of configuration file setting methods. But the problem persists. This article will record in detail my solution. My environment: mysql5.6 + python2.7.3 + MySQLdb1.2.4 1. Right-click the computer on

Run SELECT dbms_sqltune.report_tuning_task (: tuning_task) FROM dual. The error message is as follows:ORA-00600: internal error code, arguments: [kesqsMakeBindValue: obj], [], [],[], [], [], [], []ORA-06512: at "SYS. PRVT_ADVISOR", line 1624ORA-06512

The relationships in relational databases must meet certain requirements, that is, they must meet different paradigms. Currently, relational databases have six paradigms: 1NF, 2NF, 3NF, 4NF, and 5NF) and the sixth paradigm (6NF ). The first paradigm

The CHARINDEX function is often used to search for characters or strings in a string.If the searched characters contain the characters to be searched, this function returns a non-zero integer.This integer is the number of digits at the beginning of

I. Common Operations 1. Copy the table structure create table t2 like t1Copy table data insert into t2 select * from t1 2. mysql Index Alter table is used to create a common index, unique index, or primary key index. Alter table t add index

When my colleague called the master node yesterday, the slave database reported the following error: Got fatal error 1236 from master when reading data from binary log: 'Misconfigured master - server id was not set' The rough look is like the

After the oracle database is started normally, it can be accessed locally, but sqldevelop cannot be accessed remotely. The system prompts ORA 12505 Listener does not currently know of SID given in connection descriptor. Before this problem is solved,

For mongoDB, there are not many ways to learn from relational databases. At the beginning, we learned how to insert, find, update, and remove, and then paging, sorting, and indexing, followed by master-slave replication, replica set, and

MongoDB logs are growing rapidly, and the space of/var is immediately full. Even if you switch to another disk partition to save the logs, the logs are still growing rapidly, and the disk is about to be closed. There is a good way to use rotating

1 For LoopSyntax: beginFor I in reverse 1 .. 10 loopInsert into users values (I, 'Obama ');End loop;End;Note: The Circular Variable I is implicitly added, so it cannot be seen2 goto statementsThe goto statement is used to jump to a specific position

Today, I used MySQL's ON DUPLICATE KEY UPDATE to determine whether to insert data. Now Mark the following! If you want to insert or UPDATE data without data in the database, you can choose on duplicate key update. On duplicate key update can be used

In PostgreSQL, all storage function requirements can be implemented using PLPGSQL. At the same time, it also supports writing in a third-party language. This depends on your skills.Note that PLPGSQL is more efficient than other third-party languages.

The CNT option makes the Oracle client attempt to use your current Windows domain credentials to authenticate you with the Oracle server. This cocould fail for a couple of reasons:-The Oracle server is not configured to support Windows

OverviewOracle Outline is used to maintainSQLAn execution plan tool. We can use the outline tool to prevent SQL Execution plans fromDatabaseEnvironment Changes (such as statistical information and some parameters.Outline is mainly used in the

Symptom:Today, it is found that website Access to the database is slow. After investigation, it is very fast to query the database and it is time-consuming to connect to the database.Solution:In the mysql configuration file my. cnf, add this

This article uses the official C # Driver to store and query spatial data (vectors) in MongoDB) Storage of Spatial DataIn this example, the vector element space information and Attribute Table are read from a Vector file (shapefile format) and

Once the installation is complete, the MySQL server should be started automatically. Sudo start mysql # start it manually Sudo stop mysql # manually stop After you modify the configuration file, you need to restart mysqld to make these changes take

In the project database design process, because the data volume of a single table is very large, you need to partition the table. Because the data in the table is a historical transaction, it is partitioned by month to improve query and management.

LZ has recently studied java web. Today, I just saw hibernate and found that the information on the Internet was too long when I configured the data source in hibernate. Generally, most of the configurations in tomcat version 5 are used. The