NAV: SLTechnology News&Howtos > Database >

• 

  User and Rights Management of MySQL

  MySQL rights management rights category: management class, program class, database level, table level, field level, MySQL user and rights management class: CREATE TEMPORARY TABLESCREATE USERFILESUPERSHOW DATA

  2022-06-01 22:22:09 Views: 285
• 

  Oracle update to 19c using DBU

  Upgrade key point 1. It can be upgraded directly from 11.2.0.4, 12.1.0.2, 12.2.0.1 and 18c to 19c. two。 The compatibility parameter should be at least 11.2.03. After the upgrade, the Oracle default account (whose password was not reset prior to the upgrade) will be locked and

  2022-06-01 22:21:39 Views: 210
• 

  Insufficient memory for ORA-30009:CONNECTBY operation

  ORA-30009: insufficient memory for CONNECT BY operation. XML is supported from 10g, which can be changed to xmltableSQL > drop table t_range purge;SQL > create table t

  2022-06-01 22:21:31 Views: 277
• 

  How to use mongodb Visualization tool robomongo

  Installation strategy. Everyone can do it. The following is the connection configuration. This paper mainly introduces how to create set guide data through robomongo to realize that the data of two machines can be migrated quickly without tapping slowly with shell command. The main purpose is to simplify the process of migration when a single table or a small amount of data. 1.

  2022-06-01 22:21:31 Views: 202
• 

  NoSQL-php applications redis, mongodb

  Php-redis install the expansion module wget https://codeload.github.com/phpredis/phpredis/zip/developmv develop phpredis.z

  2022-06-01 22:21:30 Views: 235
• 

  MySQL 8.0 Query Rewrite supports DML

  MySQL 8.0 Query Rewrite supports SELECT INSERT UPDETE DELETE REPLACE statement rewriting this function needs to be liked. For example, when the developer is online, a SQL query field index is forgotten to be added, so the line is directly added.

  2022-06-01 22:21:27 Views: 262
• 

  Monitoring items commonly used in MySQL from the perspective of operation and maintenance

  There are many metrics for the performance and load of MySQL, and the metrics for each version are also different, but the core indicators that can be quickly located by operation and maintenance are only a few commonly used indicators. To make a monitoring system, especially a monitoring system with massive database instances, for each additional monitoring index, the requirements for the monitoring system will

  2022-06-01 22:21:27 Views: 230
• 

  MMM High availability Cluster for MySQL Databa

  MMM Cluster Architecture Overview MMM (Master-Master replication managerfor Mysql,Mysql Master Master replication Manager) is a flexible set of scripts based on perl implementation for mysql re

  2022-06-01 22:21:26 Views: 262
• 

  Detailed tutorial on MySQL containerization

  The last article introduces the installation of Docker tools and the use of common commands. In this article, we will show you how to run an MySQL instance in Docker, and some friends may ask: why run MySQL in Docker? Because in the Dockeri department

  2022-06-01 22:21:26 Views: 268
• 

  A mongo database c caused by regular expression matching ($regex)

  One day, it was monitored that the utilization rate of cpu in mongo database was much higher. After checking it, it was found that it was caused by the following statement: db.example_collection.find ({"idField": {"$regex": "1").

  2022-06-01 22:20:56 Views: 301
• 

  MongoDB replication set (that is, master-slave replication)

  MongoDB replication set MongoDB replication is the process of synchronizing data to multiple servers; replication sets provide redundant backups of data and improve data availability, usually ensuring data security; replication sets also allow you to recover data from hardware failures and service disruptions. What is reply?

  2022-06-01 22:20:56 Views: 200
• 

  Mongodb performance optimization

  Mongodb linux performance optimization: official documentation: https://docs.mongodb.com/manual/administration/production-notes/#allocate-su

  2022-06-01 22:20:55 Views: 206
• 

  Oracle self-startup configuration and startup script 12c test pass under linux

  Reference: http://www.jb51.net/article/32214.htm1. Some basic parameters of Oracle [oracle@localhost ~] $echo $ORACLE_SIDadela [

  2022-06-01 22:20:25 Views: 296
• 

  MyEclipse tutorial: JPA Development (Database)

  1. Configuring the JPA project JPA is a persistence specification similar to Hibernate and has become part of the Java EE 5 specification. JPA uses Java 5 annotations to control the mapping of normal Java classes (POJO) to database tables. You can create any recipient by creating

  2022-06-01 22:20:25 Views: 278
• 

  Summary of MongoDB daily operation and maintenance operation commands

  It is well known that MongoDB is a NoSQL non-database system, that is, a database can contain multiple sets (Collection), each of which corresponds to tables in a relational database; and each collection can store a set of records identified by columns, which can be freely defined.

  2022-06-01 22:20:24 Views: 209
• 

  Modify MySQL password

  Modify the configuration: vim / etc/ my.cnf [mysqld] basedir=/home/mysqldatadir=/home/mysql/dataport = 3306user = mysqlcharac

  2022-06-01 22:20:24 Views: 218
• 

  Giant Sequoia Talk | data fragmentation is rejected, and the native distributed database can cope with the number flexibly.

  On July 19-20, 2019, the DAMS China data Intelligent Management Summit with the theme of "planning strategies for the future" was successfully held in Qingpu District, Shanghai. At the DAMS Summit, Giant Sequoia Database brought you a theme sharing entitled "Design and practice of distributed Database under Cloud Architecture"

  2022-06-01 22:20:24 Views: 209
• 

  Failed to start Hbase Shell

  Recently, a new gateway is deployed. Users connect to hbase by executing hbase shell and report an error [testuser@ip-192-168133-238lib] $hbase shellSLF4J: C

  2022-06-01 22:20:23 Views: 210
• 

  Summary of Redis Learning

  First, the underlying data structure 1, simple dynamic string (simple dynamic string,SDS) in the Redis database, containing strings worth key-value pairs at the bottom are implemented by SDS. For example, 127.0.0.1 6379 > set

  2022-06-01 22:19:53 Views: 258
• 

  About reset master and reset sla of MySQL

  Related article: https://blog.csdn.net/yabingshi_tech/article/details/50736735 description: in fact, as long as the database in the replication relationship is synchronized, then binlog does not need

  2022-06-01 22:19:53 Views: 227