NAV: SLTechnology News&Howtos > Database >

• 

  Introduction to Oracle18C RPM installation

  I have been very busy at the end of the year. I was busy today to install Oracle18C's RPM package installation method. The overall feeling is relatively convenient, greatly simplifying the installation of oracle, so that non-professional DBA also has a better installation experience. Here is one of my installation process.

  2022-06-01 12:14:05 Views: 296
• 

  Oracle 11g manually collects user statistics

  Daily manual collection of statistics, commonly used parameters are as follows. The user name is ROIDBAexec dbms_stats.gather_schema_stats ('ROIDBA',estimate_percent= > 20recoverinv

  2022-06-01 12:14:05 Views: 265
• 

  Monitor oracle database and oracle monitor shell script

  Text format: #! / bin/bash#Author:wangergui Email:291131893@qq.com Date:2016-10-10#Release 1.0#Function: check

  2022-06-01 12:14:00 Views: 267
• 

  CentOS7 installs LNMP+Mongodb environment

  CentOS 7 MySQL 5.7.10 Mongo 3.2.1 Nginx 1.8.0 PHP 5.5.31 Redis 3.0.6

  2022-06-01 12:14:00 Views: 223
• 

  MySQL 5.6.35 Master-Slave synchronous configuration case

  MySQL 5.6master-slave synchronous configuration case sharing this article environment master library: Redhat 6.5x64 192.168.1.180 mysql-5.6.35 standby library: Redhat 6.5x64 192.168.1.181m

  2022-06-01 12:14:00 Views: 299
• 

  Redis persistence schemes RDB and AOF (Theory)

  What is the difference between redis and memcache? To put it simply, if there is no persistent redis, it is the same as memcache, which is equivalent to a cache database. How does redis solve data persistence? Redis has two persistence schemes: RDB (

  2022-06-01 12:13:59 Views: 208
• 

  Partition by day and delete historical partition through stored procedure

  -- create a partition table on a daily basis, and periodically delete the partition before the specified number of days through the stored procedure / / create a daily partition table * / / * /-order order asset snapshot table drop table DTSDATA.tyebasset_befor

  2022-06-01 12:13:59 Views: 229
• 

  MySQL Database Advanced (7)-transactions and locks

  MySQL Database Advanced (7)-transaction and Lock 1, transaction introduction 1, transaction introduction transaction (Transaction) refers to a series of operations performed as a single logical unit of work. 2. The characteristics of a transaction A, atomicity (Atomicity) denote the

  2022-06-01 12:13:59 Views: 223
• 

  MySQL 8.0 MGR (Group replication) highly available VIP switch script

  MySQL 8.0 MGR (group replication) highly available VIP switchover script introduction: MGR (group replication) officially recommends using MySQL router middleware to do MGR high availability failover, but it has more than one layer of network, performance will degrade, and requires additional maintenance of a set of intermediate

  2022-06-01 12:13:58 Views: 278
• 

  Sybase installation MDA table

  Sybase does not install the mda table by default, so you need to use installmontables in the $SYBASE/ASE-12_5/scripts directory (for NT,% SYBASE%\ ASE-12_5\ scripts)

  2022-06-01 12:13:50 Views: 292
• 

  Zabbix3.2 monitors MYSQL status

  First, summarize the MySQL plug-in that comes with zabbix to monitor the mysql database, but it is too crude, for us dba, it is basically useless, so we need to do more detailed monitoring, and percona has this detailed monitoring template and script, just to bring it over.

  2022-06-01 12:13:50 Views: 280
• 

  Table operation of oracle rookie learning

  First: http://www.arppinging.com/wordpress/?p=96oracle rookie learning table operation 1. Create tables in oracle, create tables using create table to implement SQL > cr

  2022-06-01 12:13:49 Views: 278
• 

  Account and privilege management of MongoDB and login in Python and Java

  This article mainly introduces MongoDB account creation, rights management (simple), and login in Python,Java and default clients. By default, MongoDB does not have account permission management, that is, you can log in without a password to have read and write permissions.

  2022-06-01 12:13:49 Views: 245
• 

  Installation of MySQL-5.7.19 under CentOs6.5 system

  It has not been updated for a long time. Today, I would like to share with you a wave of simple documents. The beginner spirit of a rookie is to keep learning and seek help from God! Today, I would like to recommend a blog address: http://sumongodb.blog.51cto.com.

  2022-06-01 12:13:48 Views: 217
• 

  MySQL DML operation-the best way to achieve pivot row transfer function

  1. Background * because MySQL does not support column-column conversion between the pivot feature of type Oracle and SQL Server. two。 Table and data mysql > select * from tweets

  2022-06-01 12:13:46 Views: 228
• 

  Databases: triggers for

  The concept of trigger: a special kind of event-driven process defined by the user on the relational table. Once defined, any addition, deletion and modification of the table will have the corresponding trigger automatically activated by the server to carry out centralized integrity control in the DBMS core layer. Similar to constraints, but more flexible than constraints. Flip-flop score

  2022-06-01 12:13:45 Views: 243
• 

  Holer implements external network access to local PostgreSQL database

  The external network accesses the internal network PostgreSQL database. The PostgreSQL database is installed on the internal network host, which can only be accessed in the local area network. How can the local PostgreSQL database be accessed from the public network? This article describes the specific steps to implement using holer. 1. Quasi

  2022-06-01 12:13:45 Views: 232
• 

  SQL server 2012 installation steps

  Click "install" on the left, and select "New …" on the right. " The detection is all completed by inputting the product serial number and adding the current user installation in mixed mode.

  2022-06-01 12:13:22 Views: 268
• 

  Mongodb usage

  Mongodb uses 1) to connect mongodbmongo-- port 10001 / / specify port. The default port is 27017, so the local mongodb is connected. Mongo-- host 192.168.0

  2022-06-01 12:13:21 Views: 233
• 

  MYSQL opens a remote connection

  Host 'xxx' is not allowed to connect to this MySQL server.mysql opens remote connection Today mysql is installed on the server, ready to use mysqlguitools

  2022-06-01 12:13:21 Views: 289