NAV: SLTechnology News&Howtos > Database >

• 

  NetEase deploys operation and maintenance in OpenStack

  About OpenStack OpenStack is an open source IaaS implementation that consists of a number of interrelated subprojects, including computing, storage, and networking. As a result of the release under the Apache agreement, since the establishment of the project in 2010, more than 20.

  2022-06-01 09:13:36 Views: 270
• 

  Estimation and actual implementation Plan of SQL Server Insider

  Estimated vs. Actual query plans We can have SQL server output whether the plan (for any display plan option-graphics, text, or XML) contains the actual running query. A query generated without executing the query

  2022-06-01 09:13:33 Views: 211
• 

  MySQL 5.7.17 Group Replication

  The powerful function based on group replication was implemented as a plug-in after MySQL 5.7.17. This paper describes how to build a test environment for group replication on the basis of single machine and multiple instances. Description: operating system: CentOS Linux release 7.3.1611 (Cor)

  2022-06-01 09:13:33 Views: 294
• 

  Unzipped PostgreSQL startup script

  The postgresql.cmd@echo offtitle PostgreSQLrem variable sets if not defined PGSQL set PGSQL=%~dp0if not defined PG

  2022-06-01 09:13:33 Views: 284
• 

  Oralce recursive query

  1. The basic syntax is: select... From where start with connect by; / /: filter condition, which is used to filter all returned records. / /: the qualification for re-starting the root node of the query result. / /: connect

  2022-06-01 09:13:32 Views: 290
• 

  Batch processing to automatically back up and clear database files every day

  Explain how to use the task schedule to execute batch files at a specified time every day; 1. Realize automatic Copy database backup files to another host 2, automatically delete backup files for specified days 1, batch file code CopyDB2Lan (factory). Bat****

  2022-06-01 09:13:32 Views: 225
• 

  Oracle configure multi-network interface and multi-port listener

  Environment: oracle 11.2.0.4 two database instances: orcl test hostname resolution: 192.168.1.30 orcl.lineqi.com orcl [oracle@orcladmin] $ifconf

  2022-06-01 09:13:32 Views: 293
• 

  Ora_01810: format codes appear twice

  The reason for reporting this error is that it is indicated by mm in minutes when converting the date; the to_date ('2016-06-30 16-21-15-51) oracle format is case-insensitive.

  2022-06-01 09:13:32 Views: 289
• 

  The principle of starting and shutting down oracle-transaction commit or rollback

  Transaction 4.1 the concept of a transaction starts with the first DML statement and ends with rollback or commit. All previous DML operations (insert,update,delete) fall within the scope of this transaction. 4.2 things

  2022-06-01 09:13:31 Views: 218
• 

  Mysql concurrency ensures data consistency-- an example

  1. Background when a recent project encountered a problem and updated a document, the update failed. For example: @ Transactional (rollbackFor = Exception.class) public void

  2022-06-01 09:13:31 Views: 268
• 

  MySQL database sub-table partition

  Blogger QQ:819594300 blog address: http://zpf666.blog.51cto.com/ friends who have any questions can contact the blogger, the blogger will help you answer, thank you for your support! First, why do you want a sub-meter? Our database data is getting bigger and bigger.

  2022-06-01 09:13:05 Views: 302
• 

  Daily use of pt-query-digest

  Pt-query-digest is a tool for analyzing mysql slow queries. It can analyze binlog, General log, slowlog, or crawl through SHOWPROCESSLIST or tcpdump

  2022-06-01 09:13:04 Views: 288
• 

  The first part of the road to Mongodb dba

  I have added the finished document to the attachment, so nothing will be written here. Please download the attachment directly and check it. If any technical problems in the document are incorrect, you are welcome to point them out. Thank you for your support! Attachment: http://down.51cto.com/data/23

  2022-06-01 09:13:04 Views: 205
• 

  Still building your own Redis cache? Then you are out.

  What is Redis? To put it simply, Redis is an open source in-memory database that supports a variety of data structures such as Key-Value, which can be used in scenarios such as caching, event publishing or subscription, high-speed queuing, and so on. Redis is written in ANSI C language, supports network, and provides strings.

  2022-06-01 09:12:58 Views: 301
• 

  Kafka node fake death

  First, when I woke up in the morning, I opened Wechat, and my colleagues reported that the kafka cluster had failed frequently since the early hours of yesterday morning. I quickly turned on the computer to check the machine monitoring and log information of the kafka cluster, and found that the cluster load of one of the nodes suddenly fell from yesterday morning, and the feedback from my colleagues was too long.

  2022-06-01 09:12:55 Views: 213
• 

  [book Review: Oracle query Optimization rewriting] Chapter 14 concluding Chapter

  [book Review: Oracle query Optimization rewriting] Chapter 14 ends Chapter 1. 1 related reference articles links to previous 13 chapters refer to related links: [book Review: Oracle query Optimization rewriting] Chapter 1 http://blog.itpub.net/267361

  2022-06-01 09:12:55 Views: 256
• 

  Mysql maximum number of connections settin

  Problem description: very often encounter "MySQL: ERROR 1040: Too many connections" abnormal situation problem analysis: one of the reasons for this situation is that the traffic is too high, the MySQL server can not resist, this time

  2022-06-01 09:12:55 Views: 269
• 

  Win8 installation 11gR2 [ins-13001] environment does not meet the minimum requirements

  Win8.1 x64 reported this error when installing Oracle Database 11g R2 [INS-13001] because win8.1 was not released when the R2 version was officially released, so it cannot be well supported. Click Yes to continue the installation without any shadow.

  2022-06-01 09:12:52 Views: 216
• 

  Database 5.5.32 compilation and installation and simple preliminary optimization

  . Database 5.5.32 compilation and installation and simple preliminary optimization 1. Environment: [root@mysql-master01 sbin] # cat/etc/redhat-releaseCentOS release 6.6 (Fin

  2022-06-01 09:12:51 Views: 235
• 

  How to use MySQL transactions

  This article mainly shows you how to use MySQL transactions, the content is easy to understand, I hope you can learn, after learning, there will be a harvest, the following let the editor to take a look at it. The concept of a transaction MySQL a transaction is one or more database operations, or all

  2022-06-01 09:12:48 Views: 215