NAV: SLTechnology News&Howtos > Database >

• 

  [AlwaysOn2017] DMV-Sys.dm_hadr_availability_replica_cluster_states of AlwaysOn

  12 、 Sys. Dm_hadr_availability_replica_cluster_states is all AlwaysOn availability groups (regardless of secondary) in a Windows Server failover cluster (WSFC) cluster

  2022-06-01 05:07:07 Views: 261
• 

  Different performance of the same update statement in MySQL,Oracle (R12 note 30 day)

  Today, a friend asked me a SQL question, which is basically a update statement. There seems to be nothing wrong with the logic, but it always reports an error when it is executed. Statement and error message are: UPDATE payment_data rrSET rr.penalty_d

  2022-06-01 05:07:07 Views: 234
• 

  A brief introduction to MyCAT (1) of MySQL distributed Cluster (revised)

  It took me a long time to think of updating my blog. Recently, the database has been changed from Oracle to MySQL. After studying it for a period of time, I feel that the community version of MySQL is inferior to Oracle,Oracle in all aspects. All right, cut the crap. I'm going to record some this time.

  2022-06-01 05:07:07 Views: 287
• 

  Oracle wait event (Wait Event): Sync ASM rebalance parsing

  Summary: in the Oracle database, you can often see a special wait event: Sync ASM rebalance. The basic meaning of this wait event is to synchronize ASM rebalance changes in the cluster to make ASM changes in the set.

  2022-06-01 05:07:07 Views: 271
• 

  MySQL database stress test report

  MySQL database stress test report 1 stress test environment 1.1 server configuration category name OS virtual machine CentOS release 6.5 (Final) DISK765GBMySQLlv5.6.27Sysbenchv0.

  2022-06-01 05:07:01 Views: 298
• 

  In the use of login database! Sql

  Use it when logging in to the database today! Sql login [oracle@p520b ~] $! sqlsqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production

  2022-06-01 05:06:53 Views: 276
• 

  Coherence Part IV: Merging Data And Processing

  Coherence Part IV: Merging Data And ProcessingA lot of people start using Oracle Coherence as a dist

  2022-06-01 05:06:53 Views: 218
• 

  Wait_time in session view

  V$SESSIONWAIT_TIMENUMBERIf the session is currently waiting, then the value is 0. If the session is

  2022-06-01 05:06:42 Views: 235
• 

  Implementation of Mysql data slicing with Mycat Middleware (part two)

  9. Data is fragmented by node (DataNode) [root@k8s01 conf] # vim schema.xml [root@k8s01 conf] # vim rule.xmlid: indicates field name count: represents

  2022-06-01 05:06:42 Views: 234
• 

  Oracle11g network configuration

  Network connection: after installation, both the client and the server need to make network configuration before they can connect to the network. The server should configure the listener and the client should configure the network service name. Server startup program: if the client and the server are not on the same host, it is required to start the listener and database services.

  2022-06-01 05:06:31 Views: 243
• 

  Mysql Master-Slave Building switch

  Environment: 172.30.249.156 percona5.6.27 hostname: tr-mysql virtual machine for applications in production environment 192.168.129.153 percona5.6.27 hostname: trcloud-

  2022-06-01 05:06:31 Views: 266
• 

  [learning] Architecture-001-examples and databases

  First of all, understand the following two pictures: 1. Generally speaking, the Oracle server generally contains an instance + a database. two。 Instances generally refer to memory and processes, which are dynamic; databases refer to files stored in the operating system, which are static. Example 1. Process: ps-ef |

  2022-06-01 05:06:31 Views: 297
• 

  Oracle11g cannot back up empty table solution (06550)

  After oracle11g is established, execute the following statement to prevent the problem that empty tables cannot be backed up (previously established tables need to be dealt with in the following way) alter system set deferred_segment_creation=fa

  2022-06-01 05:06:30 Views: 252
• 

  Zeppelin: a meta-information node of a distributed KV storage platform

  From the introduction of Zeppelin: an overview of a distributed KV storage platform, we know that the meta-information node Meta provides meta-information maintenance and provision services to the entire Zeppelin in the form of clusters. It can be said that the Meta cluster is the brain of Zeppelin and is all the meta-information.

  2022-06-01 05:06:26 Views: 287
• 

  Oracle11g7 installation media description

  Oracle11g7 installation media description: file name description p102025301120--Linux-x86-64_1of7.zip database installation media p102025301120--Linux-x86

  2022-06-01 05:06:25 Views: 300
• 

  Configure two MySQL instances on the same machine

  Abstract: in the real environment, in order to make full use of hardware resources, multiple mysql instances may run on the same machine. This paper shares an implementation method. Original link: https://www.modb.pro/db/22741?cyn1. Virtual machine ready 1.1.

  2022-06-01 05:06:25 Views: 288
• 

  How to modify the data file path in the database open state (can be used to rename and change the path)

  Under database open, migrate the data under users tablespace to / home/oracle/dsk1 (which can be used as renaming) col name for a50SQL > select file#,name,checkpoint

  2022-06-01 05:06:25 Views: 253
• 

  Oracle OCM Job running error ORA-29280

  1. Oracle OCM Job run error report ORA-29280 A minor malfunction occurred in a colleague's system. The author helps to check it out. Because the overall load of the system is very low and there is no obvious functional influence point, the author does not have an intuitive way of thinking. Generally speaking, from alert log I

  2022-06-01 05:06:25 Views: 227
• 

  Oracle 11.2 result_cache description

  1 related parameter RESULT_CACHE_MAX_RESULT: specify the maximum amount of cache that can be used by any result. The default value is 5%, but any 100-point ratio between 1 and 100 can be specified. This parameter can be implemented at the system and session level; result_c

  2022-06-01 05:06:24 Views: 254
• 

  Oracle listens to the file listener.ora for 10g/11g

  -- oracle 11g--SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_

  2022-06-01 05:06:24 Views: 267