NAV: SLTechnology News&Howtos > Database >

• 

  HBase research

  The relationship between hbase region, store, storefile and column clusters an in-depth study on the read operation of hbase the region-to-storefile process

  2022-06-01 11:30:39 Views: 230
• 

  Add a column according to the field condition

  There is a table student with the following structure: sid sname ssex = = 1 Zhang San

  2022-06-01 11:30:39 Views: 260
• 

  Can the mysql function pass fewer parameters (not in person)

  # Test whether the mysql function can pass fewer arguments DELIMITER / / DROP FUNCTION test//CREATE FUNCTION test (a char (20), b char (20)) RETURNS c

  2022-06-01 11:30:38 Views: 230
• 

  12c rman optimization optimization settings fail?

  Experimental procedure RMAN > show all;RMAN configuration parameters for database with db_unique_name ORCL are:CONFIGURE

  2022-06-01 11:30:38 Views: 274
• 

  Installation and configuration of mysql5.7.13 based on rhel7.2

  Installation and configuration of mysql5.7.13 based on rhel7.2 1. Experimental environment: (1) Virtual machine: vmware workstation 12 (2) operating system: rhel7.2 X86 databases 64 (3) Database: mysql5.7.

  2022-06-01 11:30:15 Views: 246
• 

  Oracle- permission

  -| permission definition explanation-| level 1 permission | Authorization level permission for other users | level 2 permission | oracle internal file management level permission | level 3 permission |

  2022-06-01 11:30:14 Views: 207
• 

  Enterprise LAMP environment application-mysql

  Chapter 1 Enterprise LAMP Environment Application 1.1 LNMP Application Environment before 2010, the classic web service environment combination most commonly used by Internet companies is LAMP (that is, Linux,apache,mysql,PHP). In recent years, with Nginx

  2022-06-01 11:30:08 Views: 295
• 

  How to set the sql text content before opening PL/SQL preloading

  Joke: I remember that when I first used PL/SQL, the complainer gave me a sql text. What I did was to open it with a text document, ctrl + a, ctrl + cMagneCtrl + v, or create a new "SQL window" in PL/SQL, right.

  2022-06-01 11:30:08 Views: 201
• 

  SQL basic regular expressions (23)

  Using regular expression function names to describe REGEXP_LIKE in SQL and PL/SQL is similar to the LIKE operator, but performs regular expression matching instead of simple fuzzy matching (conditional) REGEXP_REPLACE searches and replaces with regular expressions

  2022-06-01 11:30:08 Views: 295
• 

  Final recommendation for mysql version selection

  1. Stable version: choose the open source community version of the stable version of GA. 2. Select the GA version of the mysql database that is more than 6 months after it is released. 3. Choose a version that does not have a large BUG fix in the following months, rather than a centralized version that fixes a large number of BUG. 4. It is better to be longer backward.

  2022-06-01 11:30:07 Views: 211
• 

  View and modify Oracle database character set

  1. Query oracle server's character set SQL > select userenv ('language') from dual;USERENV (' LANGUAGE')-

  2022-06-01 11:30:07 Views: 246
• 

  Mysql basic commands (3)-data types and operators

  First, numerical type 1, data types are: numerical type, daily I type, string type. 2. Int (20), int refers to the range of values of the integer, in which the parameter 20 only indicates the width of the data display. The display width is independent of the range of values of the data type. The display width only refers to

  2022-06-01 11:30:07 Views: 209
• 

  Cacti backup and migration

  Original cacti host IP:222.65.193.176 backup cacti host IP:222.65.194.81, backup mysql and rrd data backup database on the original cacti monitoring host: mysqldump-p cact

  2022-06-01 11:30:00 Views: 268
• 

  SqlServer is not installed, the method of opening .MDF file

  Problem raised: this machine does not install SQLServer database software, existing addressDB.mdf, addressDB_log.ldf files. How to view the data in addressDB.mdf? Solution: you can use Visua

  2022-06-01 11:30:00 Views: 278
• 

  Introduction and configuration of catalog recovery catalog

  Nocatalog introduces that nocatalog uses control file as catalog. Every backup has to write a lot of backup information to the control file, and there will be more and more backup information in the control file. Therefore, when using rm

  2022-06-01 11:30:00 Views: 209
• 

  Brief introduction of oracle lob

  What is LOB? Lob is a large object data type of oracle database, which can store more than 4000bytes strings, binary data, OS files and other large object information. The version of the root oracle of the maximum storable capacity is related to the oracle block size. Yes

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

  [ELK] 03, ES Cluster and ES query

  The previous article mainly studied the installation of ES and its plug-ins. This article focuses on ES cluster and its node management. 1. ES Cluster Overview 1. Introduction to ES Cluster ES is created for high availability and scalability, and servers can be extended by purchasing more powerful servers (vertical or upward scaling, V).

  2022-06-01 11:29:59 Views: 239
• 

  How to realize binlog Optimization in MYSQL

  This article mainly explains how to achieve binlog optimization in MYSQL, the content is clear, interested friends can learn, I believe it will be helpful after reading. Problem 1: how to solve the performance damage caused by flush redo log when a transaction is committed

  2022-06-01 11:29:57 Views: 221
• 

  Mysql concat usage

  Multiple fields are spliced into one field to query SELECTCONCAT (area.name,house.block,' building', house.unit,' unit', house.room_number,' room', room.apa)

  2022-06-01 11:29:57 Views: 281
• 

  Confluence installation

  Prepare to install package 1, download confluence installation package (installed by my trial binary package, non-source package) download address: https://www.atlassian.com/software/confluence/downl

  2022-06-01 11:29:53 Views: 293