NAV: SLTechnology News&Howtos > Database >

• 

  Oracle 11g RAC with ASM installed on RHEL5 (simplified version)

  1. Clear task: prepare a RHEL5 PC to act as SAN device, san (as both DNS and timing system) prepare two RHEL5 PCs to act as RAC nodes, R1 and R2 install RAC on ASM disk, including OCR, VOTING, library 2,

  2022-06-01 05:17:02 Views: 268
• 

  Relationship Database Design

  ContentConceptual model-ERDLogical model-schema, data dictionary, attributes mapping,... Physica

  2022-06-01 05:17:02 Views: 239
• 

  Detailed explanation of windowing function over () of Oracle Analysis function

  What is the analysis function? The analysis function is a powerful function specially used by Oracle to solve the statistical needs of complex reports. It can be grouped in the data and then calculate some group-based statistics, and each row of each group can return a statistical value. Analytical function and aggregation function

  2022-06-01 05:17:02 Views: 207
• 

  Practice of mysql under debian

  Problem: the original java program running ok, the architecture is client- > soap- > server- > mysql. After reinstalling debian and tomcat,mysql, server unexpectedly threw sql sta when running the java program.

  2022-06-01 05:16:56 Views: 254
• 

  Turn to: summary of Mysql partition and sub-table

  Citing the needs of the project some time ago, I have been studying mysql sharding, read some materials in this respect, and tested some data in person. Here, take a general note to facilitate the review of knowledge in the future. In fact, most of them learn from the predecessors on the Internet, and then take a learning attitude.

  2022-06-01 05:16:56 Views: 296
• 

  [Enmo College] learn more about Oracle technology from database creation: Plugin operations secretly performed by mkplug in those years

  Learn more about Oracle technology from database creation: the Plugin operations secretly performed by mkplug in those years, in many Oracle documents, you may have noticed a tablespace that Oracle uses for testing, which has a series of preset users and numbers.

  2022-06-01 05:16:56 Views: 257
• 

  Oracle 11g RAC views ASM logs, grid logs, and DB logs

  View the ASM log [root@ATFDB1 ~] # su-grid [grid@ATFDB1 ~] $sqlplus / as sysasmSQL*Plus: Release 11.2.0.3.0 Pr

  2022-06-01 05:16:55 Views: 230
• 

  SQL Tuning Sets

  VpSBt5Ub8LbpWX1tnzHFOV6ejwzov/VliqLXau21e6vTPdfl/McOz4ckw62Dr771gAgG+BhGy37x8dfzflXwGf7Vjt7Hcxvw1365

  2022-06-01 05:16:55 Views: 234
• 

  Innobackuppex complete and recovery

  1), download https://www.percona.com/downloads/XtraBackup/Percona-XtraBackup-2.4.7/binary/tarball/percona-x

  2022-06-01 05:16:55 Views: 271
• 

  PostgreSQL Source Code interpretation (123)-MVCC#8 (commit transaction-actual commit process)

  This section introduces the specific implementation logic of the PostgreSQL commit transaction, mainly parsing the implementation logic of the function CommitTransaction- > RecordTransactionCommit. 1. Data structure TransactionS

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

  Explain and optimizer_trace execution Plan of mysql

  Explainmysql > explain select host,user,plugin from user; +-+-

  2022-06-01 05:16:45 Views: 251
• 

  Data query of MongoDB (array)

  First of all, array preservation is supported in MongoDB, and once array preservation is supported, you need to match the array data. Example: save part of the array contents db.emp.insert ({"name": "Liu A", "sex": "male", "age"

  2022-06-01 05:16:45 Views: 309
• 

  Foobar2000 for mac (Classic Music player)

  Which mac music player works well? Macdown today recommends a classic audio player software-foobar2000 mac, which has been logged into Windows, Mac, Android and IOS. Users commented that the interface under mac is so beautiful. Do you want it?

  2022-06-01 05:16:45 Views: 263
• 

  Resolve invalid mysqld_multi stop command

  2022-06-01 05:16:44 Views: 224
• 

  Oracle event-driven scheduling job

  The most common use of Oracle scheduling jobs is time-based scheduling, setting specific time scheduling rules, according to the rules to trigger job execution at a specific point in time, most jobs are of this type. In addition, you can also build event-based scheduling jobs, which are based on specific events.

  2022-06-01 05:16:44 Views: 296
• 

  2011-10-26 Autonomous affairs

  Http://www.itpub.net/thread-1499223-9-1.html85 Building Autonomous transaction (autonomous transaction) is an independent transaction that is invoked by other transactions (called master transactions). The following

  2022-06-01 05:16:42 Views: 276
• 

  Read-only things in MYSQL innodb and the allocation of id for things

  The level of originality is limited, if there is a mistake, please point out one, read-only things some people may want to ask whether a select is a thing. In fact, in innodb, the select of an innodb is a thing. It has a trx_t structure and puts it into the mysql_trx_l.

  2022-06-01 05:16:42 Views: 281
• 

  Mysqldump backup, mysql restore, compressed backup, restore compressed files

  -- backup the database to opt cd / optmysqldump-h localhost-u root-p zxlh > zxlh_bak.sql will prompt for the database password-- transfer the database to the standby 24 machine

  2022-06-01 05:16:41 Views: 268
• 

  [MySQL] Monitoring item-- innodb_buffer_pool hit rate calculation

  Calculation of Innodb buffer Hit Ratios: innodb_buffer_read_hits= (1-Innodb_buffer_pool_reads/Innodb_buffer_pool_r

  2022-06-01 05:16:37 Views: 206
• 

  MongoDB in quantity limit

  1. The query statement itself is actually a document, with a maximum of 16MB (3.4 in' 4.0 limit, official documents). 2. The query statement itself, that is, {': {'$query: []}}, with a size of 22 bytes 3, with each additional word

  2022-06-01 05:16:36 Views: 225