NAV: SLTechnology News&Howtos > Database >

• 

  Oracle_071_lesson_p6

  The grouping function Group functionsavg calculates the average count quantity max evaluates numbers, dates, characters min evaluates numbers, dates, characters sum summation and listaggstddevvariancecou

  2022-06-01 21:01:35 Views: 264
• 

  MySQL password expiration problem

  Sometimes when you log in to MySQL, you will be prompted for password expiration, as shown in the following figure: the client window at this time cannot log in to the MySQL database server, but through command line operation, you can log in to the MySQL database server, but log in to the MysQL database server through the command line

  2022-06-01 21:01:35 Views: 265
• 

  MGR CLONE ERROR 3869 (HY000)

  1. Describe the problems encountered in the process of clone when a node is abnormal after an abnormal restart of a three-node cluster in MGR 8.0.17. The error message is as follows: mysql > CLONE INSTANCE FROM 'donor_clone_us

  2022-06-01 21:01:34 Views: 236
• 

  04 data type 1:string

  # introduction to string string type is the most basic data type of redis. A key corresponds to a value, and a key can store a maximum 512Mb. String is binary secure. # Common commands: > set mykey

  2022-06-01 21:01:34 Views: 235
• 

  About the mysql composite index

  Compound index principle: leftmost prefix principle: index (ab,ac,abc) 1, every query must have a, such as ab,ac,abc, if there is no a, only bc query will fail 2, query with or, query failure 3, query with% *, query invalid. 4 、 wherea=*

  2022-06-01 21:01:34 Views: 232
• 

  Basic application of Redis

  Redis basic applications (1) = Overview: Redis's

  2022-06-01 21:01:34 Views: 274
• 

  Summary of data types about the date represented by MySQL

  This article mainly introduces the summary of data types on the date represented by MySQL, which has certain reference value and can be used for reference by friends who need it. Let's take a look at the simple ways to hide files under Linux. Data type name of the date represented by MySQL date format date

  2022-06-01 21:01:31 Views: 294
• 

  Introduction to the method of integrating redis with Spring-data-redis

  What the editor shares with you today is the introduction of the method of integrating redis with Spring-data-redis. Many people don't know much about it. Today, in order to let you know more about the method of integrating redis with Spring-data-redis, I will give you a summary.

  2022-06-01 21:01:25 Views: 216
• 

  Master the rule processing methods and steps of distributed cache load balancing

  The following brings you to master the rule processing methods and steps of distributed cache load balancing, hoping to bring some help to you in practical application. Load balancing involves many things, there are not many theories, and there are many books on the Internet. today, we will use the accumulated experience in the industry to do an answer. In

  2022-06-01 21:01:22 Views: 288
• 

  A new IT staff member of 51

  I am flying feather broken soul, today I intend to start writing a blog to share some of the problems encountered at work and solutions to you. Let me introduce myself first. I did the training in Beijing last year. The training content is big data, mainly the bravery of oracle,mysql database and hadoop.

  2022-06-01 21:01:22 Views: 263
• 

  Sharing of common interface implementation methods in redis

  Today, the editor tells you about the common interface implementation methods of redis, which many people don't know very well. today, in order to let you know more about the common interface implementation methods of redis, the editor summarizes the following contents, let's look down together. I'm sure you'll get something. In practice, red

  2022-06-01 21:01:17 Views: 254
• 

  Construction and setup of lvs-nat load balance

  The following brings you the construction and setup of lvs-nat load balancer, hoping to give you some help in practical application. Load balancing involves many things, and there are not many theories. There are many books on the Internet. Today, we will use the accumulated experience in the industry to do an answer. Build a network environment

  2022-06-01 21:00:57 Views: 260
• 

  What are the characteristics of mysql? Summary of mysql characteristics

  What are the characteristics of mysql? Many people do not understand, today, in order to let you know more about the characteristics of mysql, so give you a summary of the following content, let's look down together. MySQL is a relational database management system developed by MySQL AB, Sweden, and belongs to

  2022-06-01 21:00:54 Views: 263
• 

  An introduction to Relational query in redis

  Today's editor to share with you is about the introduction of the relationship query in redis, many people do not know much about it, in order to let you know more about the relationship query in redis, so to summarize the following content, let's look down together. I'm sure you'll get something. This article describes how to save Redis

  2022-06-01 21:00:48 Views: 247
• 

  Initialize common errors using backup restore when creating transactional replication

  When creating transactional replication, use backup restore to initialize common error problems 1: error: 14151, severity: 18, status: 1. Replication- replication distribution subsystem: agent test-DB-TDB1-tdb1-test-

  2022-06-01 21:00:18 Views: 267
• 

  Yearning and inception build MySQL Audit platform

  The preface uses open source Yearning and inception open source software to build an audit platform for MYSQL audit and online MYSQL statement update. Function description Yearning: a complete set of mysql-sql Review based on Vue.js and Django

  2022-06-01 21:00:18 Views: 230
• 

  Experimental keepalived+nginx+apache+mysql how to achieve High availability load balancing part 2

  The following is an experiment on how to achieve high-availability load balancing with keepalived+nginx+apache+mysql. I hope it can give you some help in practical application. Load balancing involves a lot of things, not many theories, and there are many books on the Internet.

  2022-06-01 21:00:00 Views: 207
• 

  Linux-Centos6.5-Oracle database installation-DNS installation

  Oracle database can be said to be the best and safest database in the world, but the price is a bit high, generally large enterprises, banks, bonds, government departments. However, with the economic growth, the use of Oracle databases by ordinary enterprises is also gradually increasing, which may be mentioned in terms of operation and maintenance.

  2022-06-01 20:59:09 Views: 278
• 

  Installation of pt software and usage of pt-kill

  1. Used when modifying table structure: pt_online-schema-change2.percona-toolkit toolset wget https://percona.com/downloads/percona-too

  2022-06-01 20:59:08 Views: 233
• 

  The monitoring log is too large. How to deal with it?

  The Oracle listener log file (usually called listener.log) is a plain text file whose size is growing all the time. On a production Oracle server, DBA will check the file daily to see if the listener has stopped abnormally and maliciously.

  2022-06-01 20:59:08 Views: 228