NAV: SLTechnology News&Howtos > Database >

• 

  Use indexes to sort query results

  Use indexes to sort query results in MongoDB, sorting operations can ensure the order of the results by getting documents from the index in the order of the index. If the query planner (planner) cannot get the sort order from the index, it will need to sort the results in memory.

  2022-06-01 13:57:09 Views: 301
• 

  Mysql database repair

  When the database abnormal down drops or the system restarts abnormally, you need to start the database before starting the business, check the err log, check whether the database is damaged, and start the business after repair. The inspection and repair here is only for MyISAM. The related operations are as follows: check whether the table in the database is damaged: M

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

  Cacti Node Database automatic synchronization script

  Because the company has many CA platforms, each addition or modification of data needs to be operated on several CA, and because there is an automatic export script deployed on each CA of the company, if you manually add or modify data to each CA server, the graphics ID will be inconsistent, resulting in different automatically exported graphics.

  2022-06-01 13:57:08 Views: 261
• 

  RMAN backup, no backup of copy of datafile

  In the process of RMAN off-machine recovery, I first made an incomplete recovery, and then prompted an error when I recovered: Starting restore at 29-DEC-15using channel ORA_DISK_1RMAN

  2022-06-01 13:57:08 Views: 246
• 

  SHELL script Monitoring oracle alert Log

  The idea of monitoring alert logs: compare the current last line with the last scanned line according to the alert log line number, which is greater than or equal to the last scanned line, then scan from the last scanned line to the last line #! / bin/bashscriptHome= `dirna

  2022-06-01 13:57:08 Views: 208
• 

  Using flashback to view historical moment data of oracle table

  1. View the historical moment data of the table select * from tab_test AS OF TIMESTAMP to_timestamp ('20140917 10 hh34:mi 0012 012 012 012 015 015 009) hh34:mi

  2022-06-01 13:57:08 Views: 255
• 

  Upgrade MongoDB to 2.6

  Upgrade MongoDB to 2.6. upgrade ready 1. Connect 2. 6 mongo shell to 2. 4 replica set auxiliary members, and execute db.upgradeCheckAllDBs () in the admin library. two。 Evaluate applications upgraded to 2.6 and

  2022-06-01 13:57:07 Views: 221
• 

  Architecture Design of Android App: from VM, MVC, MVP to MVVM

  With the expansion of Android application development scale, the client-side business logic is becoming more and more complex, which is no longer a simple data display. Like the component split idea adopted when the back-end development encounters a bottleneck, the client also needs to design the architecture, split the view and data, uncouple the modules, and improve the modules.

  2022-06-01 13:56:54 Views: 296
• 

  The method of finding the day of the next week in net_day in plsql cannot be used with Chinese characters.

  First of all, solve the problem of displaying Chinese characters in plsql. If the 2017 select sysdate from daul; / / display is this, it can be used normally if it is not 1, http://10788133.blog..

  2022-06-01 13:56:47 Views: 295
• 

  Oracle 10g RAC with ASM installed on RHEL5 (simplified version)

  1. Prepare three nodes, one for SAN equipment and two for ORACLE RAC nodes, 2 network cards for each node, and assign IP address saneth0 10.0.0.1c1eth0 192.168.33.101 eth0:1 192.168

  2022-06-01 13:56:47 Views: 269
• 

  Mud: zabbix3.0 installation and configuration

  This month is almost over again, and recently I am so busy that I have no time to write an article. Today, I squeeze some time to write down the article on zabbix3.0 installation and configuration. In fact, the installation of zabbix3.0 is very simple, but due to personal laziness, I do not like to use source code to install it.

  2022-06-01 13:56:17 Views: 275
• 

  Mysql master-slave database replication

  Mysql's built-in replication function is the basis for building large, high-performance applications. The mechanism of distributing the data of Mysql to multiple systems is to copy the data from one host of Mysql to another host (slaves) and execute it again.

  2022-06-01 13:56:14 Views: 245
• 

  MySQL master master synchronization

  MySQL master master synchronization master master synchronization principle is the same as master slave, but it is only two-way. Modify the configuration file vim / etc/my.cnf# to start binlog and relay loglog-bin=mysql-binbinlog_for at the same time

  2022-06-01 13:56:11 Views: 282
• 

  Oracle add redundant control file for RAC On Linux

  Adding redundant control files naturally adds a layer of protection to the security of the database. After all, single-link control files are a little dangerous, after all, they are the hub of library files. Needless to say, entering today's topic, for RAC can also be used as a stand-alone for. If there is a need for this aspect, the main building will be in the later stage.

  2022-06-01 13:55:59 Views: 275
• 

  Systematic Study of Sql Server knowledge points

  Part one: basic knowledge of SQL Server 2008 (chapters 1 and 2). First of all, this paper introduces the principle knowledge of database, such as the structure of relational database and the normal form theory to standardize database and Emurr model, and then introduces the new functions and features of SQL Server2008.

  2022-06-01 13:55:59 Views: 235
• 

  RHEL ORACLE environment variable

  Export TMP=/tmpexport TMPDIR=$TMPexport ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/p

  2022-06-01 13:55:58 Views: 259
• 

  The solution of errno:111 Connection refused error when MongoDB is started

  MongoDB launch Times the following error [root@MongoDB ~] # mongoMongoDB shell version: 2.6.1connecting to: test2014-05-25T18:4

  2022-06-01 13:55:55 Views: 207
• 

  Import the excel file into the database

  Reference: http://blog.csdn.net/jayxujia123/article/details/13684313 reference: http://kevin850115.iteye.com/blog/578

  2022-06-01 13:55:51 Views: 222
• 

  [MongoDB Learning Note 10] startup and shutdown of MongoDB

  1. MongoDB start MongoDB starts with the mongod command. It is not recommended to use service mongod start or chkconfig mongod on to start MongoDB, because mongod needs to start each time.

  2022-06-01 13:55:48 Views: 277
• 

  Cacti backup migration

  The company has 1 cacti monitor, but in order to prevent the failure of a single cacti, we are going to add another cacti as a backup monitor. The monitor currently used is 115.231.xx.xx, which I call cacti-A. The newly installed monitor is 59.63.xx.xx.

  2022-06-01 13:55:48 Views: 261