NAV: SLTechnology News&Howtos > Database >

• 

  MySQL5.5 upgrade to 5.7

  Prepare to work on a new server (10.12.21.184) as a binary package hostrole10.12.21.120master10.12.21.1 for downloading the latest stable version of MySQL5.6 on 21.184 from the library.

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

  Mysql5.7 logical backup tool mysqlpump

  Mysqlpump is a unique logical backup tool after the mysql5.7.8 version. It has more features than mysqldump and mysqldumper,mysqlpump. The official document describes it as follows: mysqlpump featur

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

  It takes a long time for a database to query a statement.

  Today, July 8, 2016, the developer provides a statement to delete data from the table, the delete statement. After being executed in plsql, it is found that the execution has not finished for half an hour. At this time, the developer still has scripts to execute. I wanted to create a new session to execute the statements provided by the developer.

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

  Oracle changes the size of sga+pga

  The day before yesterday, I need to change the memory parameters of Oracle. The size of sga and pga was already configured when oracle was installed, but there are a lot of problems with it. Linux uses 16 gigabytes of memory, and sga memory uses 12 gigabytes of PGA 4G, so li

  2022-06-01 17:16:11 Views: 218
• 

  Index optimization of MYSQL performance failure optimization sharp weapon

  Index optimization of MYSQL performance failure optimization from a performance point of view, 80% of the performance problems are designed. From the statistical probability of performance test problems, 80% of the performance problems come from problems caused by data processing, of which SQL syntax problems account for a high specific price, and most of these problems are

  2022-06-01 17:16:05 Views: 281
• 

  Mysql Master-Slave replication Architecture and its implementation

  Mysql Master-Slave replication Architecture and mysql Master-Slave replication configuration Master Node: start the binary log to set a globally unique ID number (server-id) for the current node to create a user account (replication slave,repli) with replication permission

  2022-06-01 17:15:56 Views: 299
• 

  High concurrency and Rapid causes of Redis

  This article shares with you the reasons for the high concurrency and speed of Redis. The editor thought it was very practical, so I shared it with you to learn. The following information is about the high concurrency and rapid causes of Redis. 1.redis is based on memory, memory read and write speed is very fast; 2.red

  2022-06-01 17:15:56 Views: 207
• 

  Oracle database access tool SQL Plus uses

  Scenario Oracle comes with a database query tool to check which tables are in the database select * from tab; query table structure desc pas_alarm_info; format date type fields, string output select to_cha

  2022-06-01 17:15:56 Views: 233
• 

  Mysql command learning notes (1)

  Install / uninstall Mysql database # install Mysql database D:\ mysql\ bin > mysqld-- install# start Mysql service D:\ mysql\ bin > net start mysql# stop Mysq

  2022-06-01 17:15:55 Views: 297
• 

  If-then-else Logic in decode of oracle Rookie Learning

  If-then-else logic decode in decode for oracle rookie learning is similar to if-then-else syntax: decode (values,if1,then1,if2,then2,...e)

  2022-06-01 17:15:55 Views: 242
• 

  Mssql sqlserver validates integer function sharing

  Abstract: below, we will make an isnumber function to verify the integer type for numerical judgment in the sql script, as follows: example: implementation principle: to determine whether it contains special characters and whether all natural numbers of 0-9 constitute CREATE FUNCTION db.

  2022-06-01 17:15:55 Views: 285
• 

  What does it mean that no database selected appears in the database?

  Today, what the editor shares with you is what it means to appear no database selected in the database. Many people don't quite understand it. Today, in order to make you understand better, the editor summarizes the following contents. Let's look down together. I'm sure you'll get something. No d

  2022-06-01 17:15:54 Views: 267
• 

  OEL 5.8 install EBS 12.1.1

  Yum install gcc\ glibc\ glibc-common\ glibc-devel\ glibc-devel\ libgcc\ libgcc\ libstdc++\ libstdc++

  2022-06-01 17:15:37 Views: 294
• 

  Detailed description of oracle database installation

  Introduction: oracle12c Overview oracle12c database is a relational database, using Cramp S mode, supporting SQL language, stability, high performance, security is better than other official websites: https://www.oracle.com/cnora

  2022-06-01 17:15:37 Views: 251
• 

  Why should the database be indexed?

  Today, what the editor shares with you is the reason why the database needs to be indexed. I believe most people don't know much about it. In order to make you understand better, the editor summarized the following content for you. Without saying much, let's move on. The main function of establishing an index in the database is to improve the query speed. Indexing can speed up the

  2022-06-01 17:15:37 Views: 225
• 

  Application scenarios of redis

  This article mainly discusses the application scenario of redis, which has certain reference value and can be used for reference by friends who need it. The following information is about the application scenario of redis. One: cache-Hot data hotspot data (data that is often queried but not often modified or deleted), preferred

  2022-06-01 17:15:37 Views: 287
• 

  Oracle memory Architecture (3)

  Shared pools cache various types of program data. For example, shared pools store parsing SQL, PL/SQL code, system parameters, and data dictionary information. The shared pool involves almost all the operations that occur in the database. For example, if the user executes the SQL statement, the oracle database accesses

  2022-06-01 17:15:28 Views: 253
• 

  How to use having in SQL

  How to use having in SQL? To solve this problem, the editor summarizes this article on having today, hoping to help more friends who want to solve this problem to find a more simple and easy way. "having" is the statistical screening after "group by".

  2022-06-01 17:15:28 Views: 291
• 

  Common structured sql statements for practical Advanced Database skills (Ⅱ)

  In the last article, we introduced the sorting processing of query results by order by in the query, and then we will introduce some other operations. 10. Limit limits the number of query results in the mysql database. We want to display the first 10 rows, or lines x to n.

  2022-06-01 17:15:27 Views: 267
• 

  TNS-12555 TNS-12560 error

  Environment: suse Linux 12 oracle11.2.0.4 changed the uid of the operating system oracle user using vi / etc/passwd this morning, the monitoring cannot be started, but sqlplus can enter and startu

  2022-06-01 17:15:27 Views: 253