NAV: SLTechnology News&Howtos > Database >

• 

  Common errors in mysql

  Lock wait timeout exceeded; try restarting transaction some information 1, lock wait timeout. This is caused by the current transaction waiting for other transactions to release lock resources. We can find out the tables and words of lock resource competition.

  2022-06-01 13:43:20 Views: 261
• 

  Risk reminder of Oracle excessive memory consumption

  Preface time flies really fast, the story of the technical life series of me and the data center has come to the sixth issue, Xiao y has met with you again! What Xiao y wants to share with you today is the process of analyzing and solving a comprehensive problem. To solve this kind of problems, it is not enough to only understand the database, but also need to master more solid.

  2022-06-01 13:43:16 Views: 240
• 

  Total disconnection of oracle11g monitoring network card (1)

  Host: HP-UX essaop1 B.11.31 U ia64 1945507590 unlimited-user license Database: Oracle Database 11g Enterprise

  2022-06-01 13:43:15 Views: 268
• 

  Number of Oracle user login errors modified

  Oracle allows users to enter incorrect passwords 10 times by default. After more than 10 times, the account will be locked sys@ORCL > select * from dba_profiles where profile='DEFAULT' and r.

  2022-06-01 13:43:15 Views: 235
• 

  Windows install mongodb

  Data: http://docs.mongodb.org/manual/core/introduction/ download: http://docs.mongodb.org/manual/tutorial/insta

  2022-06-01 13:43:15 Views: 271
• 

  Oracle manually cleans up the temporary period.

  Today, the developer said that the table space in a test library is full and needs to be cleaned. When connected to the test library, 99.98% has indeed been used. TABLESPACE_NAME SIZE_G FREE_G

  2022-06-01 13:43:15 Views: 219
• 

  On the right to correct errors in Oracle

  Some time ago, when I was disabled and used exp for data migration, because the oracle user did not have the permission to write to the directory, I modified under linux when I used the chown-R oracle:oinstall command to modify the permissions of the subdirectories under the U01 directory.

  2022-06-01 13:43:14 Views: 237
• 

  AWR report Export

  Generate a single instance AWR report: (@ execution means @? / rdbms/admin/awrrpt.sql? Represents $ORACLE_HOME) @ $ORACLE_HOME/rdbms/admin/awrrpt.sql

  2022-06-01 13:43:14 Views: 247
• 

  MySQL-5.6.34 uses show global status like to view the execution of sql statements.

  Demand boss: zain, how many query statements are there in our database today? Me: uh, wait a minute, let me see. I thought, {Nima, how do I know how many select statements there are} so the problem is how to check how many query statements there are on the production server of the MySQL database.

  2022-06-01 13:43:13 Views: 236
• 

  Import TXT data of python into database

  In order to import the data, you can first do some processing to make it easier to import the database #! / usr/bin/python#coding=utf-8import _ mysql,sys,time# to read the data function def add_data (

  2022-06-01 13:43:13 Views: 279
• 

  [record] misunderstandings about the use of wildcards when mysql uses like to match data

  -- "_" in this sql is a wildcard character that matches any single character, so the filtered data contains the data starting with test: select * from live_class where title like 'test_%'; solution:

  2022-06-01 13:43:13 Views: 272
• 

  Independent installation of mysql database built in lamp or lnmp environment

  Lamp or lnmp environment is built, if mysql is installed independently, authorization is required: a separate server is installed independently, and the server is optimized after mysql installation. Authorization example 1: # create user demo with password demo123mysql > crea

  2022-06-01 13:43:13 Views: 230
• 

  Redhat6.4 64-bit installation Oracle 10.2.0.564-bit database

  Experimental environment: operating system: Redhat6.4 64-bit database: Oracle10.2.0.1 64-bit installation package + Oracle10.2.0.5 64-bit upgrade package 1, pre-installation environment preparation 1, install Redhat6.4 operating system fuck

  2022-06-01 13:42:52 Views: 213
• 

  In-depth Analysis of RMAN-- BlockRecover recovery of bad blocks

  In-depth analysis of RMAN-- BlockRecover recovery of bad blocks case environment: operating system: RedHat EL5Oracle: Oracle 11gR2 case description: recovery through block media (Block Media Recover:

  2022-06-01 13:42:49 Views: 222
• 

  The purpose of mysql

  On what occasions is mysql used? Let's take a look at the mysql database. The essence of a database is a means of managing a list of information. For example, if you want to manage a store with a lot of sales staff responsible for selling different types of products, you want to know how to provide decisions? Database.

  2022-06-01 13:42:48 Views: 273
• 

  MongoDB sharding cluster deployment

  1. Environment description 1. The cluster architecture of our prod environment MongoDB is the deployment of sharding clusters, but at present, we do not have sharding, that is, all the data are on one shard. If the quantity is large and needs to be allocated, the cluster can be sharded at any time, transparent to the business side. 2. Deployment of various roles

  2022-06-01 13:42:48 Views: 215
• 

  Obtain the actual physical storage address of the data row through rowid

  Obtain the actual physical storage address of the data row through rowid: select dbms_rowid.rowid_relative_fno (rowid) | |'_'| | dbms_rowid.rowid_block_numbe

  2022-06-01 13:42:48 Views: 241
• 

  The use of query parameters in Oracle 11g expdp

  The query parameter is provided in expdp, which can be used when you need to export part of the data in the table conditionally, just like the where condition in the select statement. Database version zx@ORCL > select * from v$vers

  2022-06-01 13:42:48 Views: 273
• 

  Batch clear a table of data, TB-level data.

  There is a need to clean up 8TB data and keep only one month's data, and the existing amount of data needs to be cleared from 2010 to the end of 2018, so a general clean-up script is written. The table is a large unpartitioned table with BLOB, which consists of three columns, file_no,BLOB

  2022-06-01 13:42:44 Views: 300
• 

  Mycat Series-Overview

  Database segmentation Overview of OLTP and OLAP in the Internet era, the storage and access of massive data has become a bottleneck in system design and use. For massive data processing, according to the use scenario, it is mainly divided into two types: online transaction processing (OLTP) and online Analytical processing (OLAP). United

  2022-06-01 13:42:39 Views: 261