NAV: SLTechnology News&Howtos > Database >

• 

  3.2-MongoDB connection and user Management

  * to connect to MongoDB, you can run the command mongo directly to enter mongodb shell. If the mongodb listening port is not 27017 by default, you need to add-- port option when connecting, such as mongo-- p.

  2022-06-01 14:44:38 Views: 251
• 

  MySQL database and basic data types

  Day01 MySQL database and data type 1, MySQL overview: MySQL database is a relational database, is a popular open source code database, is a completely networked cross-platform relational database system, MySQL database is also available on the market.

  2022-06-01 14:44:23 Views: 242
• 

  When Case:MySQL uses in tape queries, it is best not to use union or union all for subqueries

  When MySQL uses in subquery, do not use union or union all for subquery, especially when the external table is large, never use in and union, because once union is used in subquery, depende will appear in the execution plan.

  2022-06-01 14:44:23 Views: 224
• 

  Install Oracle 12c database under Linux

  (1) Note before installing Oracle under Linux: 1. Ensure that there is a record of the system hostname in / etc/hosts 2, Linux system installation graphical interface 3, OFA (the best flexible architecture): / alphanumeric / standard name / user name, such as / u01 /

  2022-06-01 14:44:22 Views: 235
• 

  MySQLdump backup and send email

  Overview: the document uses the smtp protocol, using QQ Mail to send mail, in which the client authorization code is opened QQ Mail smtp service is officially given, so keep in mind! 1. Configure smtp#Linuxyum install-y mailx# modification

  2022-06-01 14:44:22 Views: 225
• 

  Three methods of MariaDB installation and Multi-instance implementation

  This chapter contains three installation methods of Mariadb: 1, package managed by package manager 2, package in binary format: expand to a specific path, and after simple configuration, you can use 3. Source code: compile and install multiple instances of MariaDB on one machine to realize the native environment system.

  2022-06-01 14:43:55 Views: 214
• 

  Installation of mariadb 5.5Database binary package on centos6.5

  1 extract the binary package to / usr/local/, and rename it to mysql (the mariadb directory must be / usr/local/Mysql) tar-xf / var/ftp/pub/mariadb-5.5.56-linu

  2022-06-01 14:43:55 Views: 216
• 

  SequoiaDB reports a solution to a thread creation failure

  1. Problem background for distributed databases and distributed environments, thread creation failures and other problems are also very common under the pressure of high concurrency and high performance. at this time, the experience of database administrators is very considered. need to be able to quickly locate the problem and bottleneck, quickly solve. This article is also written

  2022-06-01 14:43:18 Views: 225
• 

  Redis failover

  1. Environment description stand-alone redis- 3.2.1 2. Operation screenshot Note: if you are deployed on different servers, please remember that the firewall opens the corresponding port and add the following protected mode=no to the configuration of the Sentinel. Remember, Sentinel is a special Red.

  2022-06-01 14:42:54 Views: 274
• 

  Linux package managers rpm and yum

  In our operation and maintenance work, we can't avoid installing some software, or compiling and installing some software. we know that all programs in the operating system are developed by programmers through development tools. plain text documents written directly by programmers are called source code, but our computers can only recognize binaries.

  2022-06-01 14:42:51 Views: 296
• 

  SQL Server 2016 Failover + AlwaysOn add database to availability group

  SQL Server Failover + AlwaysOn add database to availability group previous articles have introduced the configuration of SQL Server Failover + AlwaysOn in detail. Today we will mainly introduce SQL.

  2022-06-01 14:42:21 Views: 204
• 

  MongoDB Overview and Storage structure

  Http://wenku.baidu.com/link?url=8jZTpplgg9HTsILAnWU1Q7xQfP8rOsEg1rHz7W0d2p2U_pcZO03EEDzZaDQ_TGUrVxvn

  2022-06-01 14:42:20 Views: 254
• 

  Oracle partition table check-with max or default partitions

  / * query the partition table with 'default','MAXVALUE' *. The partition table contains default or max partition / selectallparttab.datestr,allparttab.table_owner,a

  2022-06-01 14:42:20 Views: 240
• 

  Redis5 cluster expansion-adding master and slave nodes

  Review the cluster node b3363a81c3c59d57143cd3323481259c044e66d2 192.168.196VR 5006 "15006" sl that has been built in the previous section of redis cluster Cluster introduction.

  2022-06-01 14:42:20 Views: 256
• 

  Database Tips

  Detailed comparison between ACID and CAP ranking of four types of databases in NoSQL (non-relational databases): DB-Engines Ranking will report compatibility if you install a 64-bit access driver on a machine with 32-bit access

  2022-06-01 14:42:20 Views: 255
• 

  MySQL Database Management 2

  Te database db102; create table db102.t1 (namechar (6), age int (3)); insert into db102.t1 values ("jerry"

  2022-06-01 14:42:19 Views: 287
• 

  Zabbix_Server installation

  Zabbix_Server installation environment: LNMP preparation: 1. Database operation mysql > CREATE DATABASE zabbix CHARACTER SET utf8 COLLATE utf8_bin

  2022-06-01 14:42:08 Views: 213
• 

  Model creation Table based on Django

  First, create a single table models. Python engine, usr python#, bind, Env, python#-*-coding:utf-8-*-from _ _ future__ import unicode_literalsfro

  2022-06-01 14:41:38 Views: 221
• 

  I am just a fireman (DBA Rescue)

  Just about to get off work and drive back to my hometown, suddenly a customer called and said that the business could not be used, and it was suspected that it was an oracle database problem, which must be solved immediately. I had no choice but to settle down to deal with the failure. As a DBA, the first is to deal with everything calmly, and the second is to be careful. I use remote

  2022-06-01 14:41:35 Views: 204
• 

  Oracle creates tablespaces, users, assignments (paperback)

  First, 1.Oracle creates tablespaces, users, assignments (plain) C:\ Documents and Settings\ Administrator > sqlplus / nologSQL > conn / as sysdba

  2022-06-01 14:41:34 Views: 223