NAV: SLTechnology News&Howtos > Database >

• 

  Compilation, installation and configuration of MariaDB Galera Cluster Cluster Enterprise Edition

  Installation environment system: CentOS 6.8 x86x64 software: MariaDB 10.1.16 node 1: 192.168.11.132 4C 8GB node 2: 192.168.11.133 4C 8GB software access Ma

  2022-06-01 14:33:30 Views: 280
• 

  The solution to the failure to start the service after CentOS installs MongoDB

  Today, according to the download wizard of the MongoDB official website to install MongoDB, the service of starting MongoDB was found to be unable to start. After a whole night of hard work, I finally got it. I hope I can help comrades who have the same difficulties. First of all, Google and du Niang have searched countless articles and made countless attempts.

  2022-06-01 14:33:22 Views: 212
• 

  Oracle Study-AMD CPU installation Oracle 11gR2 RAC error

  Oracle Study-- AMD CPU installation Oracle 11gR2 RAC error system environment: operating system: RedHat EL55Oracle: Oracle 11gR2 Grid + Oracle1

  2022-06-01 14:33:22 Views: 209
• 

  Migrate the mailbox of the specified OU to the specified database

  Get-Mailbox-OrganizationalUnit 'domian/ou' | New-MoveRequest-TargetDatabase db1-BatchName' bjzhy'

  2022-06-01 14:33:12 Views: 227
• 

  DateAdd () function in Sqlserver

  In the Sqlserver database, the DATEADD () function adds or subtracts the specified time interval from the date. For example, calculating the time of the day after the current time and the time of the previous day can be operated by using the DateAdd () function and the DateAdd () function.

  2022-06-01 14:33:09 Views: 252
• 

  Handwritten database connection pool

  1. I believe many people already know what connection pooling is used for after reading this article. Yes, database connection pool is to establish a "buffer pool" for database connections, put a certain number of connections in the "buffer pool" in advance, and take one out of the "buffer pool" when you need to establish a database connection.

  2022-06-01 14:33:00 Views: 288
• 

  Oracle database reported ORA-01033 error

  Oracle login ORA-01033: solution that ORACLE is initializing or shutting down 2015-03-16 01:20 | 160511 people read | Source Oracle login ORA-01033: ORACLE is initializing or

  2022-06-01 14:33:00 Views: 207
• 

  ORACLE has no permission to tablespace ICITY

  When imp imports a table, it prompts that there is no permission for the tablespace 'ICITY'. After Baidu, you can see that users who log in with DBA can be authorized by writing SQL statements. Alert user dg_bagsh quota unlimited on icit

  2022-06-01 14:33:00 Views: 227
• 

  Move oracle data file locations online

  Online mobile oracle data files Oracle data files can be renamed or moved when the database OPEN, but at this time the tablespace must be read-only, which will allow users to query from the table, but prohibit them from doing so insert, update and delete when the tablespace is read-only

  2022-06-01 14:32:59 Views: 227
• 

  Knowledge summary of Spring and related frameworks

  An introduction to Spring related knowledge to put it simply, Spring is a hierarchical JavaSE/EE one-stop lightweight open source framework. Spring is committed to providing a way to manage your business objects. Spring is committed to all layers of solutions for J2EE applications.

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

  Oracle function-one-line function-character one-line function

  Classification of functions = = one-line function: one input corresponds to one output,input and one output exists

  2022-06-01 14:32:56 Views: 280
• 

  Oracle--redo+undo summary

  "Oracle-redo" redo log files (redo log file) are very important to the database, they are the transaction logs of the database; the Oracle database maintains two types of redo log files: online redo log files (redo) and return

  2022-06-01 14:32:56 Views: 235
• 

  Elasticsearch Scale Out

  Current situation: the company's PRD environment ES cluster consists of 5 machines, 4 DATA nodes and 1 ingest node. The cluster uses the search-guard plug-in for permission control, and the cluster node uses certificates for mutual trust. Problem: if there is a development response, the query is a little slow, and the leader gives it to the ES cluster again.

  2022-06-01 14:32:55 Views: 270
• 

  The performance of rewriting in to join in Case:update is improved several times.

  (1) before optimization, the following SQL increases the salary of pre-employment employees from 1985-05-21 to about 20.70s. From the implementation plan, we can see that the table salaries is a full index scan, and the number of scanning rows is about 260W rows. Mysql >

  2022-06-01 14:32:55 Views: 237
• 

  Introduction to Linux's package management tools

  Summary: the content of this chapter: software running environment, software package foundation, rpm package management, yum management, customized yum repository, compilation and installation 1. Software running environment 1.API:Application Programming Interface (application program

  2022-06-01 14:32:55 Views: 308
• 

  MYSQL (1) Database index types, index advantages

  An index, also known as a key in mysql, is a data structure used by the storage engine to quickly find records. Index structure types (there are two common types): 1.B-Tree indexes are supported by most mysql engines; 1.B-Tree usually means all values

  2022-06-01 14:32:55 Views: 288
• 

  The Environment Construction of Zabbix Monitoring Series-- LAMP

  I haven't published a blog post for a long time. I feel a little sorry for 51CTO and myself. Recently, the company is going to install a monitoring server. I just take this opportunity to sort out the process system, make a document and share it with everyone! I think this thing is beneficial to others and self-interest, and it is also convenient for me to review and use it later! Server version Information:

  2022-06-01 14:32:54 Views: 204
• 

  The size of the database remains unchanged after the mysql delete deletes the record.

  This problem occurs when DELETE is followed by a condition. After the delete from table_name where condition deletes the data, the size of the space occupied by the data table does not change. When you delete directly without following the conditions. Delete f

  2022-06-01 14:32:54 Views: 288
• 

  12cR2 RAC+RAC+ADG ORA-16854

  Recently in a bank production set up a set of RAC+RAC+ADG+BROKER production system, encountered a lot of holes, and then make a record. If you have any questions, you can leave me a message and discuss study together. 1. Environment description Oralce 12cR2 RAC+RAC A

  2022-06-01 14:32:54 Views: 300
• 

  Install mysqld_exporter

  Download address: https://github.com/prometheus/mysqld_exporter/releases Select linux-amd64.tar.gz to extract sudo tar xvf mysq

  2022-06-01 14:32:54 Views: 248