NAV: SLTechnology News&Howtos > Database >

• 

  Installation of pymysql in win Environment

  Installation of pymysql in win environment 1. First, download the corresponding pymysql file in https://github.com/PyMySQL/PyMySQL, extract it to the folder 2.cmd, and locate cd under the decompressed folder 3. In cm

  2022-06-01 14:36:26 Views: 291
• 

  [Oracle Database] Oracle RAC (1): shared storage

  [root@wallet03 ~] # yum install-y scsi-target-utils [root@wallet03 ~] # vi / etc/tgt/targets.conf

  2022-06-01 14:36:26 Views: 255
• 

  Use exp backup Times Export terminated successfully with warnings processing method

  When using exp to back up the database on the backup server, there is no problem when you use the / bin/sh call directly on oracle, but when you put it into the scheduled task call, you report "Export terminated successfully with war".

  2022-06-01 14:36:26 Views: 274
• 

  Creating and managing tables with DDL statements based on SQL (XIV)

  The database object Object describes the basic set of data stores in a table, consisting of rows and columns. Logically related data sets extracted by View from one or more tables generate regular numerical index indexes to improve query performance. Synonym aliases aliases for objects, table names and

  2022-06-01 14:36:04 Views: 263
• 

  Database ACID principles and transaction isolation levels

  Database ACID principle A: atomicity, AtomicityC: consistency, ConsistencyI: isolation, IsolationD: persistence, Durability innodb engine in mysql, atomicity, consistency, isolation

  2022-06-01 14:36:04 Views: 249
• 

  The use of oracle-BBED

  Bbed is a tool used within oracle to view and modify data files directly. It can directly modify the contents of Oracle data file blocks, which is useful in some special recovery scenarios. The CPU Power series corresponding to the byte order AIX is called the big-end Intel series.

  2022-06-01 14:36:01 Views: 264
• 

  50 commands commonly used in Linux

  1. Tar create a new tar file $tar cvf archive_name.tar dirname/ extract tar file $tar xvf archive_name.tar view tar file $tar tv

  2022-06-01 14:36:01 Views: 221
• 

  Springboot configuration jpa

  Configuration mode pom depends on org.springframework.bootspring-boot-starter-aopapplication.xml configuration # jpa configuration spring.jpa.properties

  2022-06-01 14:36:00 Views: 249
• 

  Oracle cannot connect through IP problem

  1. Installation directory: d:\ app\ Administrator\ product\ 11.2.0\ dbhome_1\ NETWORK\ ADMIN2.listener.ora (localhost or 127.0.0 inside

  2022-06-01 14:36:00 Views: 218
• 

  Oracle setting menu full path

  1. First, set the full_name (full path) update S_DEPARTMENT t set t.full_name ='XX Group 'where fid='-1';2 of the first level menu and the ful of the second level menu.

  2022-06-01 14:36:00 Views: 241
• 

  The length and number of digits of numeric

  When learning SQL: there is such a sentence: Score numeric (4jue 1), I wonder how many digits it is. After being perplexed by irresponsible notes in old books, I inquired about Baidu: numeric, where y is the decimal place, x is the integer number, and x is the total number of digits.

  2022-06-01 14:36:00 Views: 220
• 

  [MongoDB] 03, MongoDB Index and fragmentation basis

  1. The configuration items in the MongoDB configuration mongodb configuration file / etc/mongodb.conf are actually mongod startup options (same as memcached) [root@Node7 ~] # mongod-- he

  2022-06-01 14:35:53 Views: 286
• 

  Installation, configuration and startup of MongoDB

  Overview MongoDB is written by C++ language and is an open source database system based on distributed file storage. In the case of high load, adding more nodes can ensure server performance. MongoDB aims to provide scalable, high-performance data storage solutions for WEB applications

  2022-06-01 14:35:41 Views: 271
• 

  Oracle series: (16) pagination

  Review mysql pagination use the limit keyword to query the first two records in the users table select * from users limit 0Magne2 or select * from users limit 2 it0 represents the first record

  2022-06-01 14:35:35 Views: 273
• 

  Collation of database IO performance knowledge

  At the beginning of this year, in order to do the performance test of the all-in-one machine and the storage performance test of CRM3.0, we quickly did some knowledge about storage, and combined with Swingbench and fio, we did some testing work on database and storage performance. The whole IO stack is a complicated one.

  2022-06-01 14:35:29 Views: 277
• 

  Oracle Analysis tool dbms_profiler Analysis Code

  Before execution, you need to run $ORACLE_HOME/rdbms/admin/proftab.sql to create some key tables. BEGINDBMS _ PROFILER.START_PROFILER ('MY_APPLICATIO

  2022-06-01 14:35:28 Views: 257
• 

  Mysql-binlog

  1. Basics support text format and binary format logs in previous versions of mysql5.0, but only binary format logs are supported in post-mysql5.0 versions. Because binary log has more advantages in performance, information processing and so on. 2. Enable mysql binary days

  2022-06-01 14:34:58 Views: 277
• 

  SQL structured query language-- DML language

  DML:Data Manipulation Language data manipulation language, mainly used to achieve table insert add, delete delete, update change operation 1, insert add record 1. Add a record, that is, add a row. In-table words

  2022-06-01 14:34:52 Views: 259
• 

  ORA-32004: obsolete and/or deprecated parameter (s)

  [oracle@169_test bdump] $> alert_ TSH1.log [oracle @ 169_test bdump] $sqlplus / as sysdbaSQL*Plus: Releas

  2022-06-01 14:34:52 Views: 264
• 

  Basic knowledge of database

  First, create and view database 1. Create database CREATE DATABASE [IF NOT EXISTS] # optional content db_name [create_specification] # is defined as follows: [DEFAULT]

  2022-06-01 14:34:52 Views: 286