NAV: SLTechnology News&Howtos > Database >

• 

  6.mongo Command prompt help

  The 6.mongo command prompt to help the latest content will be updated at the origin server. To reprint, please keep the original link: http://dashidan.com/article/mongodb/index.html ① mongo command line parameters to help you pass--

  2022-06-01 21:40:38 Views: 253
• 

  Oracle create trigger

  Create or replace trigger DATA_SYNC_@TABLE@ before insert or update or delete on @ TABLE@ REFERENCI

  2022-06-01 21:40:38 Views: 227
• 

  Mysqldump+binlog backup script

  # # pay attention to various directory creation and related parameter settings # # set / root/dba/binlog_control.txt, record binlog file time, get time command: stat-c% y mysql_mmm_01-bi

  2022-06-01 21:40:38 Views: 276
• 

  Using tab key to complete in mysql

  The tab key cannot be used for automatic completion by default in mysql. The automatic settings are as follows: the completion here is the table name, column name, and database name. Not commands, variables, etc., in the database. On the mysql command line, use\ # to temporarily enable tab completion. Configuration file in mysql

  2022-06-01 21:40:38 Views: 232
• 

  MySQL Index principle and slow query Optimization

  With its excellent performance, low cost and rich resources, MySQL has become the first choice of relational database for most Internet companies. Although the performance is excellent, the so-called "good horse with good saddle", how to make better use of it, has become a compulsory course for development engineers, and we often go to work.

  2022-06-01 21:40:32 Views: 305
• 

  Similarities and differences between oracle Media recovery and instance recovery

  1. Conceptual REDO LOG is a mechanism established by Oracle to ensure that committed transactions are not lost. In fact, REDO LOG exists for two scenarios: instance recovery (INSTANCE RECOVERY) and media recovery (MEDIA).

  2022-06-01 21:40:31 Views: 245
• 

  MySQL Database Development Learning course

  MySQL Database Development Learning course I, Database Design Database Design (1)-- Database Design https://blog.51cto.com/9291927/2087925 II, basic course of MySQL Database Development MySQL Database Development

  2022-06-01 21:40:31 Views: 222
• 

  Quickly solve the ORA-00959 in IMP

  Quickly solve the problem that the ORA-00959 table space does not exist when ORA-00959 in IMP imports DMP into the test library with IMP. General solution: 1. Create the table first, and add the parameters of ignore=y when importing dmp. two。 Create a new corresponding table empty

  2022-06-01 21:40:31 Views: 228
• 

  Select statement of Oracle

  First, the function of select statement: projection (projection): get a column or multi-column data selection in a table (selection): obtain a row or multi-row data association in a table (join): multi-table federated query II, SQL statement writing standard 1.

  2022-06-01 21:40:31 Views: 266
• 

  Linux7 installation oracle11g error Error in invoking target 'agen

  An error was reported when installing Oracle 11.2.0.4 in Linux7. The screenshot is as follows: after querying the official documents, we found that this is the bug of oracle. Select continue directly and patch it when the installation is complete. The official explanation is as follows: choose to continue and the installation is complete

  2022-06-01 21:40:25 Views: 233
• 

  MongoDB monitoring items-- how to use commands to get

  1. View server thread running status $mongo-host=-port=-u mongo_monitor-p ""-authenticationDatabase admin payDB-eva

  2022-06-01 21:40:25 Views: 217
• 

  Oracle rman data backup

  * * [RMAN backup] * * less / etc/crontab## performs a level 0 backup on 6 days a week

  2022-06-01 21:40:24 Views: 244
• 

  Install SOLR in the production library

  The article mainly comes from the translation of official documents: there is an install_solr_service.sh script in the bin directory of the archive to help you install solr as a service. CentOS, Debian, Red Hat and SUS are currently supported.

  2022-06-01 21:40:24 Views: 261
• 

  High performance Extensible MySQL Database Design and Architecture Optimization E-commerce Project 1

  A database design specification 1 naming specification all database object names must be separated with lowercase letters and underscores prohibit the use of MySQL reserved keyword naming to achieve name recognition, no more than 32 byte temporary tables must be tmp prefix date suffix backup database table bak prefix date

  2022-06-01 21:40:13 Views: 290
• 

  MySQL binary log

  The binary log consists of files that contain "events" that describe changes to the contents of the database. The server writes these files in binary format. 1. View the binlog file name list show binary logs;2. View the contents of the binlog file

  2022-06-01 21:40:13 Views: 252
• 

  Performance Optimization of Oracle Learning (10) Lock

  Lock is a mechanism used to prevent harmful interactions (save, fetch) between transactions when accessing the same resources (including user objects, system objects, memory, shared data structures in Oralce data dictionaries, and most commonly database table Table objects). Not the same kind

  2022-06-01 21:40:06 Views: 254
• 

  Introduction to Redis Cluster structure (Theory)

  First of all, let's take a look at the redis cluster topology redis cluster introduction: 1. Redis cluster is an acentric structure in which each node stores data and the state of the entire cluster. 2. Each node will save the information of other nodes, and will know the hash slot (

  2022-06-01 21:40:03 Views: 210
• 

  What are the installation steps for the second version of Oracle 12c

  The server not only has high stability and high-speed access, but also is easy to manage, secure and easy to use, in order to reduce the energy and time cost of users in server maintenance, and focus on the development and promotion of their own business. Hundreds of millions of cloud servers are committed to providing users with the most cost-effective server! Oracl

  2022-06-01 21:39:59 Views: 235
• 

  How to check the key_len in explain to determine which index is used

  How do I look at the key_len in explain to determine which index is used? Many people don't know much about it. Today, in order to make you understand better, the editor summarizes the following contents. Let's look down together. I'm sure you'll get something. There are multiple indexes in a table, we w

  2022-06-01 21:39:56 Views: 233
• 

  Summary of problems related to locking in MySQL

  What the editor shares today is a summary of MySQL's issues related to locking. Maybe you are no stranger to MySQL, or you have never known MySQL. But don't worry, today the editor will use the simplest description to explain the problem of locking in MySQL. Let's take a look. How to concurrency

  2022-06-01 21:39:44 Views: 251