NAV: SLTechnology News&Howtos > Database >

• 

  Crsd on node 2 cannot be started, and databases and listeners cannot start automatically, such as ocrconfig, ocrcheck, and srvct

  The change of CRSD process in 11g is 11.2.The CRSD process is no longer one of the most critical processes in RAC. If you are familiar with 10g RAC, you should be aware of the importance of the CRSD process. After the operating system starts, Oracle starts this process and then

  2022-06-01 16:45:41 Views: 213
• 

  The difference between InnoDB and MyISAM storage engine

  The difference between InnoDB and MyISAM storage engine: InnoDB storage engine: the mainstream of current MySQL storage engine. InnoDB storage engine supports transactions, row locks, unlocked reads and foreign keys. MyISAM storage engine: MyISAM is out of support

  2022-06-01 16:45:40 Views: 265
• 

  Database log system decomposition

  Title index log classification log operation log decomposition log classification in the database system logs are mainly divided into six categories, specifically as follows: 1, query log: mainly record daily query records; 2. Slow query log: mainly record statements with query time longer than the set numerical time, which is convenient for DBA operation and maintenance personnel to carry out.

  2022-06-01 16:45:37 Views: 297
• 

  How to send subscription messages to WebSocket clients in Redis

  PHP's redis extension is a blocking IO, and when using the subscription / publish mode, it will cause the entire process to enter blocking. Therefore, it must be implemented using the Swoole\ Redis asynchronous client. Example code $server = new swoole_webs

  2022-06-01 16:45:37 Views: 231
• 

  Introduction to Mysql Partition (9)-- Partition Management

  First, partition operation 1. Change the unpartitioned table to the partition table ALTER TABLE trb3 PARTITION BY KEY (id) PARTITIONS 2. Delete Partition # Delete all partitions while data is lost ALTER

  2022-06-01 16:45:34 Views: 222
• 

  [MySQL] Database Middleware-- ProxySQL+MGR

  [root@wallet01 ~] # mysql-uroot-p < addition_to_sys.sql Enter password: [root@wallet01 ~] # mysql-ur

  2022-06-01 16:45:33 Views: 277
• 

  Installation and configuration tutorial for mysql8

  There are many online installation tutorials, which are more or less the same. during the installation process, the installation may fail because of very small details. I also referred to a lot of installation tutorials before the installation was successful. There will be a variety of problems in the installation process. We will look for answers according to these questions and improve our solution at the same time.

  2022-06-01 16:45:16 Views: 208
• 

  How to uninstall mysql database

  How to uninstall mysql1) stop the MySQL service for window. Find Control Panel-> Administrative tools-> Services, stop the MySQL background service 2) Uninstall the MySQL installer. Find Control Panel-> programs and Features, and uninstall M.

  2022-06-01 16:45:03 Views: 301
• 

  Mysql newspaper Can't create/write to file & # 39 Trans TMP Universe ib0n3frLigment 39; (Errcode: 13-Permission denied)

  Initial database reported an error [root@Master mysql-5.6.24] # / usr/local/mysql/scripts/mysql_install_db-- user=mysql-- basedir

  2022-06-01 16:45:02 Views: 213
• 

  An overview of the database system for reviewing database knowledge

  Database is the latest technology of data management and an important branch of computer science. From online transaction processing (On-Line Transaction Processing,OLTP) to online Feixi processing (On-Line Analysis Proce)

  2022-06-01 16:45:02 Views: 218
• 

  The method of finding the intersection in oracle and java

  ) = t.protocol_start_time AND # {protocolStartTime} < = t.resume _

  2022-06-01 16:45:01 Views: 300
• 

  Different display problems of List Bakcup in catalog

  Environment: Oracle database 10.2.0.5Primary RAC+ASMStandby Single Instance+Non-ASMCatalogOS Oracle Linux 61. Near

  2022-06-01 16:44:52 Views: 208
• 

  LAMP builds zabbix to monitor Oracle database for Linux

  The function you want to achieve is to add an orabbix plug-in on the zabbix server side to access the oracle database for monitoring operations. The environment introduces CentOS 7 zabbix 2.4.2. Yum said that because the company's computer could not

  2022-06-01 16:44:52 Views: 269
• 

  Use stored procedures to update data in batches

  Use stored procedures to update data in batches, and merge-update can also be used in Oracle, but using the following stored procedures will make DECLARE MAX_ROWS NUMBER DE faster

  2022-06-01 16:44:52 Views: 225
• 

  CentOS7 install MySQL5.6

  = = preparation = = step 1, first, create the virtual machine

  2022-06-01 16:44:22 Views: 239
• 

  Creation, deletion, modification, deletion, view and index of MySQL tables

  Create database create database | schema [if not exists] db_name [character set=] [collate=] Note: schema can be understood as scheme or data

  2022-06-01 16:44:21 Views: 228
• 

  Introduction of xtrabackup and related operation flow

  Xtrabackup detailed explanation xtrabackup is an online hot backup tool based on InnoDB developed by CTO Vadim of Percona company, which has the characteristics of open source, free, supporting online hot backup, fast backup recovery, small disk space, and so on.

  2022-06-01 16:44:21 Views: 285
• 

  Mycat sub-library routing rules

  1. Mycat sub-library routing is divided into continuous routing and discrete routing. 1. Continuous routing: (1) commonly used routing methods: auto-sharding-long, sharding-by-date, sharding-by-month (2), excellent

  2022-06-01 16:44:12 Views: 259
• 

  Oracle11g rac listener offline

  The oracle 11g rac listener appears the listening process offline after adjusting the network, and frequently switches between the two nodes. Check the log / var/log/message and find that there are frequent registration revocation actions. Monitoring log / u01/app

  2022-06-01 16:44:11 Views: 220
• 

  Ansible to build MariaDB Galera Clus

  1. Environment. This article only introduces the configuration of mxc. I will download and connect to https://down.51cto.com/data/2467920192.168.56.21 ansible192.1 for other configurations (all configurations).

  2022-06-01 16:44:11 Views: 271