NAV: SLTechnology News&Howtos > Database >

• 

  RHEL5 installation Oracle 10g

  General installation 1. Install the necessary rpmyum install compat-db compat-libstdc++ control-center gcc gcc-c++ glibc glibc-common g

  2022-06-01 17:12:21 Views: 224
• 

  Mysql deadlock record

  Test environment: mysql 5.7.18 RR isolation level creates a table, inserts part of the test data CREATE TABLE yhtest (an INT (11) NOT NULL AUTO_INCREMENT,b INT

  2022-06-01 17:12:21 Views: 235
• 

  Solution to control file loss

  Control file loss solution: 1 alter database backup controlfile to trace;2 pastes this section of vi / home/oracle/control.sql in the trace file

  2022-06-01 17:12:21 Views: 238
• 

  Rac has,crsd startup tracking-- erroneous deletion of RAC logs on linux platform

  Delete all log files and directories under $CRS_HOME/log/$HOSTNAME/, so has cannot be started. Step through: sh-x / etc/init/ohasdstrace-p ohasd pid View / var

  2022-06-01 17:12:19 Views: 277
• 

  Some thoughts on High concurrency Optimization configuration of mysql

  Some thoughts on the high concurrency optimization configuration of mysql there are many high concurrency optimization configuration schemes of mysql, but there are few ones that adapt to yourself. Our optimization of the database is nothing more than to deal with the high concurrency of mysql. With the arrival of big data's era and Internet users

  2022-06-01 17:12:19 Views: 277
• 

  Nodejs combined with MongoDB

  Var http = require ("http"), mongo = require ("mongodb"), events = require ("events"); http.createServer (f)

  2022-06-01 17:12:19 Views: 215
• 

  Use python to operate mysql database (data query results return dictionary type)

  #! / usr/bin/env python#-*-coding: utf-8-*-import MySQLdb# establish a connection conn = MySQLdb.connect (host='127.0.0.

  2022-06-01 17:12:19 Views: 257
• 

  Mysql create new users and databases and authorize

  First, create a new user / / login MYSQLroot@log:~# mysql-uroot-pEnter password: password Welcome to the MySQL monitor. Commands e

  2022-06-01 17:12:18 Views: 208
• 

  How to turn on oracle flashback

  First, check whether flashback is enabled: SQL > select flashback_on from video database on-No2 if flashback has been enabled, there is no need to execute

  2022-06-01 17:12:18 Views: 261
• 

  View Mysql lock table statement

  Early in the morning to brush the data, a large number of table structure alter statements, the table will be locked. Locking tables may be encountered in the use of the database, resulting in timeouts when other processes access the same table. If it is production, you will see a large number of pool kneeling. If you are browsing sql, you should

  2022-06-01 17:12:16 Views: 262
• 

  Deployment of Mysql master-slave replication and read-write separation on CentOS7

  In the actual production environment, if the database is read and written in the same database server, no matter in terms of security, high availability, or high concurrency, it can not meet the actual needs at all, so generally speaking, it is through master-slave replication (Master-Slave).

  2022-06-01 17:12:11 Views: 271
• 

  Python operates oracle and mysql

  1. Install related package yum install python-devel mysql-devel zlib-devel openssl-devel2, install setup, mysql-python package wget http

  2022-06-01 17:12:10 Views: 274
• 

  The mysql service is not up due to port problems

  Today, a colleague said that his mysql database could not work, and he was very depressed. The error was as follows: # / etc/init.d/mysql startStarting MySQL.... ERROR! The server quit wit

  2022-06-01 17:12:10 Views: 298
• 

  Installation and configuration of Mycat

  What is Mycat? as to what is Mycat, there may be different understandings under different roles. If you have any knowledge of MySQL architecture, you all know that MySQL is actually made up of Server layer and storage engine layer. So for DBA, Mycat is M.

  2022-06-01 17:12:09 Views: 219
• 

  Multi-instance MySQL startup script

  Develop mysql multi-instance startup script: known mysql multi-instance startup command is: mysqld_safe-defaults-file=/data/3306/my.cnf & stop command is: mysqladmin-u root

  2022-06-01 17:12:09 Views: 257
• 

  Basic Management of MySQL Database

  MySQL is an open source relational database management system (RDBMS), which uses the most commonly used database management language-structured query language (SQL) for database management. MySQL is open source, so anyone can use General P.

  2022-06-01 17:11:08 Views: 231
• 

  Mongodb sharding configuration under centos7

  Server architecture: serial number role ip address Note 1 Server 1

  2022-06-01 17:10:55 Views: 225
• 

  How to configure the parent-child process of Java

  A brief introduction to the concept of parent-child process: in management activities, the common part, the common part, the process management activity that can be repeated, we separate it into a sub-process, which can be invoked by the management activities of other processes. The person who invokes the child process is called the parent process, and a process can

  2022-06-01 17:10:54 Views: 215
• 

  Source code installation mongoDB

  Installation steps: 1. Prepare 1.1 display system version [root@centos ~] # cat / etc/redhat-releaseCentOS Linux release 6.4.1406 (Core) 1.2A

  2022-06-01 17:10:54 Views: 204
• 

  ORACLE JET Basic Table Infinite Scrolling

  Basic Table example: Basic Table

  2022-06-01 17:10:48 Views: 219