Database Administrator

SQL Server Technical Summary The default Instance name for ms SQL Server is SQLExpress and the default TCP/IP Port Number is 1433. When a new instance is created instead of the default instance, the default port number is dynamic, therefore, you

Select an appropriate backup method for MySQL Backing up a MySQL database is extremely important. If there is no backup, the system will go crazy in the following situations:UPDATE or DELETE whitout where... Table was DROPPed accidentally... INNODB

Data is extracted in minutes and averaged. Unit data is extracted. Q: There is now a table with the content of one entry every 10 seconds (6x60x24 = 8640 entries per day ), what I want to do now is to take data (12*24 = 288 records per day) at a

[MongoDB] MongoDB optimizer Profiler, mongodbprofiler In mysql databases, slow query logs are often used as the basis for database optimization. mongodb still has similar functions. The profiler provided by Mongodb allows you to easily record all

[Software Engineering] Chapter 1 and Chapter 2 Summary, Chapter 2 Summary I watched the video for a while. But I don't feel very focused. I don't know what the focus is. I asked a lot of people to reveal their questions. I wouldn't watch the video

Upgrade mysql in centOs and mysql in centOs Preface: A variety of problems occurred when I upgraded the mysql version from 5.1 to 5.7 On centOS today. However, after a step-by-step investigation, the problem is solved. The following is a record of

MySQL (I) and mysql (I)1. Start the MySQL service and log on to the MySQL database 1. Start the MySQL Service   1. Click the Start Menu of a single machine. In the displayed menu, select the run command to open the run dialog box. 2. Enter "services.

Earlier versions use dblink to connect to 11G versions reports error ora-02063/ora-01017, dblinkora-02063 A home, a carrier called to create dblink error ora-02063/ora-01017 This BUG was not encountered once. ORACLE described the BUG as follows: Bug

Introduction to py_innodb_page_info, innodbpagesizePy_innodb_page_infoThis tool is written by Jiang chengyao, author of MySQL technology insider InnoDB Storage engine, to analyze the types and information of each page in a tablespace and is written

I. mongodb sharding: add and remove shards on multiple simulated nodes in win7 environment. mongodbwin7 This article describes how to simulate mongo sharding on a win7 computer. If you have multiple servers, you can deploy each mongo on a single

SQLSTATE58030, sqlstate28000 An execution error occurred while optimizing an SQL statement. gtlions=# select t1.telnumber,t2.ua,t2.url,t1.apply_name,t2.apply_name from tb1 t1 gtlions-# left outer join tb2 t2 on t1.sid = t2.ipsid gtlions-# where t1.

Cannot connect to remote postgresql, connect to postgresql If postgresql is installed on a remote server, adding a server using pgAdmin will never work. Solution: Add host all 0.0.0.0/0 trust to pg_assist.conf on the remote postgresql database.

In the reverse engineering of the mysql database, hinernatemysql cannot generate the primary/foreign key relationship. (1) When we use the hibernate reverse engineering tool that comes with myeclipse for SSH development of large ※※project, it

Data Structure-stack and Data Structure Note: Yan Weimin's "data structure" (C language version) takes notes and records them for later viewing. As shown in, the base pointer and top pointer both point to the low stack. When the stack is pressed,

Haproxy + mysql cluster (MySQL cluster) configuration, haproxycluster I. Preparation 1. Prepare the server Establish a MySQL CLuster system with two nodes and build a Haproxy + mysql cluster (MySQL CLuster) system with six servers Node

[Stackoverflow good question] the SQL table name should use the plural or singular number, stackoverflowsqlProblemThe SQL table name should be in the plural or singular form of the resource object corresponding to the table. For example, if a user

[Stackoverflow good question] Remove duplicate rows in SQL, stackoverflowsqlProblemSuppose there is a table with a large data volume (for example, 300,000 + rows) with duplicate rows (except for the primary key, the data in other columns is the same)

Use dbms_service to manage oracle services (Single Instance) and dbms_serviceoracle ---- Create a new service. After the service is created, pmon automatically (dynamically) registers to tnslsnr. The service created is not permanent and will be

How does mysql make order by and mysqlorderby? Order by clsesIn general, the optimizer will skip the sort procedure for the order by clause if it sees that the rowsWill be in order anyway. But let's examine some predictional situations. For the

[Monogdb] MongoDB's top 10 application design skills: monogdbmongodbTip 1: a compromise between speed and integrity Data used in multiple documents can be embedded (Anti-paradigm) or referenced (paradigm. This strategy has no advantages or