NAV: SLTechnology News&Howtos > Database >

• 

  MySQL logical Architecture (1)

  MySQL logical system architecture: can be divided into connector, connection pool, Sql interface, interpreter, optimization library, buffer, cache, engine MySQL logical structure is deliberately regarded as a two-tier architecture, the first layer is usually called SQL Layer in the database system to deal with the underlying data package rights.

  2022-06-01 13:29:23 Views: 216
• 

  VB6 program and Ora-06413 solution letter

  Reason: Win7 x64 platform, Vb6 program started, directly can not be enabled; Vb6 is relatively old, should be the product of the Stone Age; this error should be related to oracle environment variables, and friends confirmed the installation of oracle 9i client 32-bit. Pass through

  2022-06-01 13:29:11 Views: 276
• 

  MongoDB Replica Set deployment

  MongoDB is used in production for data security and access stability. Copy sets are often used. Since the last book, the MongoDB copy set has been installed many times. But every time to go to Baidu specific order details. I had to organize my own notes and write them down.

  2022-06-01 13:28:43 Views: 281
• 

  ORA-00328 ORA-00334 MRP0: Background Media Recovery terminated with error 328

  Environment introduction: a set of linux+oracle11.2.0.3+dataguard maximize availability environment of two-node single instance was built a few days ago. Failure phenomenon: found that it can not be synchronized today, in trace

  2022-06-01 13:28:30 Views: 290
• 

  Introduction to the use of Logdump tools in GoldenGate

  The Logdump tool is a tool provided by GoldenGate for querying, analyzing, filtering, viewing and saving data stored in trail files or extract files. 1. Start the Logdump tool [oracle@rhel6 ~] $

  2022-06-01 13:28:27 Views: 200
• 

  Compile and install MySQL 5.7on CentOS 7

  1. System environment [root@szlinux02 ~] # uname-r3.10.0-514.el7.x86_64 [root@szlinux02 ~] # cat / etc/redhat-releaseCe

  2022-06-01 13:28:27 Views: 263
• 

  Hot standby of Oracle

  Hot backup when the database is running, the backup behavior is called hot backup; the backup object needs to be set to the hot backup state; the backup method is also using the system command (cp,scp)

  2022-06-01 13:28:27 Views: 251
• 

  [Oracle Database] Database performance testing tool: BenchmarkSQL

  [oracle@king01 ~] $sqlplus / as sysdbaSQL > create tablespace tpccdatafile'/ u01/app/oracle/oradata/k

  2022-06-01 13:28:27 Views: 273
• 

  Damaged recovery of OCR of ORACLE11gR2-RAC without backup

  Scenario description: do OCR backup and restore experiment, OCR has 4 automatic backups. After replacing the OCR disk from + DATA to + OCR2 (/ dev/raw/raw4), manually back up OCR using ocrconfig-manualbackup after completion

  2022-06-01 13:28:26 Views: 277
• 

  [Oracle Database] flashback (FlashBack)

  Flashback version query SQL > set line 200SQL > col starttime for a30SQL > col endtime for a30SQL > col operation for a30S

  2022-06-01 13:28:26 Views: 296
• 

  Mongodb master-slave configuration

  1. Mongodb master and slave configuration master and slave are all on the same server, the master is the default port, and the master is 99991) master/usr/local/mongodb/bin/mongod-- master-- dbpath /

  2022-06-01 13:28:26 Views: 290
• 

  ERROR 1017 (HY000): Can't find file: & # 39 Tablenametrics 39; (errno: 2)

  The system always fails to query mysql data because of a sudden power outage. Report the error of ERROR 1017 (HY000): Can't find file: 'tablename' (errno: 2). Using the normal repair table

  2022-06-01 13:28:26 Views: 228
• 

  NoSQL--Redis profile

  1. Redis conf parameter configuration: 1. Whether # runs as a daemon: as a background process. If daemonize yes# runs as a background process, you need to specify a pid. The default is / var/run/redis.pidpidf.

  2022-06-01 13:28:22 Views: 273
• 

  The database instance to be deleted cannot be found in dbca

  When you delete a database or configure the database option using dbca, you will encounter that you cannot find or cannot find a database instance that is not currently started, as follows: [oracle@prodb-s ~] $ps-ef | grep pmonoracle 20

  2022-06-01 13:28:22 Views: 277
• 

  Detailed explanation of ASMCMD command

  Instance management command: dsget returns discovery diskstringdsset to set discovery diskstringlsct to display the client of the current oracle ASM

  2022-06-01 13:28:22 Views: 294
• 

  Zabbix 3.2.6 installation process

  Take the 3.2.6 version of Zabbix as an example to explain 1. Prepare the Lnmp environment. The environment for this preparation: Linux:2.6.32-642.el6.x86_64Nginx:1.12.0Mariadb:10.2.6PHP:7.1

  2022-06-01 13:28:22 Views: 269
• 

  Database backup and recovery of Oracle

  Oracle database backup and recovery here are some simple examples to understand: various physical backup methods of Oracle database. Use RMAN tools to backup and restore the database. Data export and import operations. (1) close the BOOKSALES database and enter

  2022-06-01 13:28:21 Views: 279
• 

  Cannot use the command / usr/bin/xdpyinfo to automatically check the monitor color.

  A virtual machine is installed on the laptop, and oracle11g is installed in the virtual machine. When I use xshell5, log in with my oracle account and execute. / runInstaller, I issue the following error: > cannot use the command / usr/bin

  2022-06-01 13:28:21 Views: 293
• 

  Oracle pivot & unpivot

  Pivot & unpivot 11g new feature 1 pivot appears in the form of column-value pairs, a typical row-to-column report function. Create table test_demo (id int,name varchar (20), nu

  2022-06-01 13:28:21 Views: 277
• 

  MySQL modify data table name and table field command line

  Sometimes we need to change the data table name and table field, then through what command line to change the data table name, table field change, add, delete, the following details on the operation of the data table method 1, modify the table name command line ALTER TABLE tab

  2022-06-01 13:28:21 Views: 225