NAV: SLTechnology News&Howtos > Database >

• 

  Extents in oracle

  Extents feature in oracle: 1: an extent consists of multiple connected blocks, and multiple extents form a segment,2:oracle. When allocating space for segment, it is in extent units.

  2022-06-01 14:21:56 Views: 283
• 

  Php mysql APP interface mobile interface API M-API open source code

  Open source protocol: Apache License 2.0Source address: https://github.com/movie0312/M-API.gitM-API Overview. 1. Interface document structure. 3. Interface environment setting.

  2022-06-01 14:21:56 Views: 276
• 

  DG implementation scheme (the main library is dual-node rac)-- rman duplicate mode

  Environment information: operating system version: AIX6.1 database version: ORACLE 11.2.0.3 (psu5) the main library is dual-node rac1. Check whether the database supports Data Guard (DG is only supported by the enterprise version) SQL > select

  2022-06-01 14:21:56 Views: 232
• 

  New features introduced in 8.0

  Mysql > set persist innodb_buffer_pool_size=2048*1024*1024;Query OK, 0 rows affected (0.01 sec) mysql >

  2022-06-01 14:21:56 Views: 289
• 

  ORA-00603\ ORA-27504\ ORA-27300\

  Sat Jul 27 02:06:59 2019skgxpvfynet: mtype: 61 process 155678 failed because of a resource problem i

  2022-06-01 14:21:40 Views: 246
• 

  SQL SERVER cross-server query

  Exec sp_addlinkedserver 'alias','', 'SQLOLEDB',' server address' exec sp_addlinkedsrvlogin 'alias', 'false',null,' user name'

  2022-06-01 14:21:40 Views: 245
• 

  Technical terms in MYSQL database

  Before you start to learn the MySQL database, understand the technical terms in the MYSQL database to show that you know and use the data well enough. Database: a database is a collection of associated tables. Data table: a table is a matrix of data. A table in a database looks like a simple spreadsheet

  2022-06-01 14:21:40 Views: 284
• 

  Is database performance evaluation really important?

  During the National Day, the most lively news is the news that a database product in our country won the first performance in the TPC-C test. The spread of the news was controversial and sparked a big discussion about the database. In fact, database, as one of the most important basic software, has in the whole IT ecosystem.

  2022-06-01 14:21:40 Views: 202
• 

  The execution flow of SQL statement in mysql

  Today, I will talk to you about the execution process of SQL statements in mysql. Many people may not know much about it. In order to make you understand better, the editor has summarized the following contents for you. I hope you can get something according to this article. What parts does MySQL have? Connectors: managing connection

  2022-06-01 14:21:36 Views: 233
• 

  Does mysql need to upgrade to version 8?

  Does mysql need to upgrade to version 8? Many novices are not very clear about this. In order to help you solve this problem, the following editor will explain it in detail. People with this need can come and learn. I hope you can gain something. It is necessary for mysql to upgrade to version 8, compared to the previous version

  2022-06-01 14:21:36 Views: 246
• 

  CentOS 6.4install and configure MairaDB 10.3Galera Cluster

  one。 Installation environment different versions of the operating system (CentOS 6 and 7), different versions of the database (around MariaDB 10.1) related installation configuration commands are not the same. 1. Operating system: CentOS 6.42. Database: Maria

  2022-06-01 14:21:33 Views: 257
• 

  Mongodb optimized pre-reading

  1. Optimize pre-reading by using LINUX's BLOCKDEV command to set the pre-read size smaller to reduce the occupation of useless data in memory, so as to optimize IO performance. RA represents the pre-read size (sector). The recommended value is 16 to 32. If the document is small, the pre-read value can be smaller, and the modified m

  2022-06-01 14:21:33 Views: 277
• 

  Use udev to configure the corresponding relationship with ASM

  1. Requirements indicate that customers want to use udev service to solve RAC ASM storage device names under Oracle Linux5.8, and want to achieve the following corresponding relationship / dev/sdc1 <-- > / dev/asm-disk1/dev/sdd1 <--

  2022-06-01 14:21:23 Views: 233
• 

  Database operation code of conduct

  (create a new table that is the same as the original table, and modify the table structure, then copy the data from the original table to the new table, add triggers to the original table, copy the new data to the new table, and after all the data in the row is completed, add a short time lock on the original table and name the new table as the original table

  2022-06-01 14:21:23 Views: 246
• 

  Root.sh Fails on the First Node for 11gR2 Grid Infrastructure Installation

  Execute the following error on the second node, and it is still useless to fix it according to the official prompt. Because the test environment uses a virtual machine to build a shared disk, it is finally found that the following error is caused by the shared disk problem, which is solved after the shared disk is replaced. Node2:/u01/app/11.2

  2022-06-01 14:20:53 Views: 239
• 

  Compile and install MySQL (Percona Server) 5.6 under Linux

  System environment: CentOS 6.57.0x86x64 introduction Percona Server is a derivative of MySQL, focusing on MySQL database server under Linux/BSD

  2022-06-01 14:20:53 Views: 224
• 

  Essence distributed, micro-service, cloud architecture dubbo+zookeeper+springmvc+mybatis+shiro+redis distributed large-scale Internet enterprise architecture

  About the platform Jeesz is a distributed framework that provides project modularization, service-oriented, hot-swappable ideas, and a rapid Java EE development platform with high encapsulation security. Jeesz itself integrates Dubbo service management, Zookeeper registry, Redis distribution

  2022-06-01 14:20:53 Views: 208
• 

  MySQL patrol inspection

  Query table select TABLE_NAME,TABLE_SCHEMA,engine from information_schema.tables where engine='MyIS that is not an innodb engine

  2022-06-01 14:20:52 Views: 239
• 

  SQL statement of Oracle

  Password-less login: sqlplus / as sysdba view all current databases: select name from vault database; view current database connection user: show user view current user all tables: selec

  2022-06-01 14:20:52 Views: 203
• 

  Heap tuple structure of PostgreSQL Storage engine

  Struct HeapTupleHeaderData {union {HeapTupleFields tweeheap; DatumTupleFields tweed

  2022-06-01 14:20:49 Views: 271