NAV: SLTechnology News&Howtos > Database >

• 

  What is the difference between MySQL general query log and slow query log and their respective functions

  This article mainly introduces the differences and their respective functions between the MySQL general query log and the slow query log. The contents of the article are carefully selected and edited by the author, which has a certain pertinence and is of great significance to everyone's reference. The following is to understand the MySQL general query log and slow with the author.

  2022-06-01 17:40:33 Views: 277
• 

  The principle and function of MySQL aggregate function

  Let me tell you a little bit about the principle and function of MySQL aggregate function. Have you known about similar topics before? If you are interested, let's take a look at this article. I believe it will be of some help to you after reading the principle and function of MySQL aggregation function. Here's what we often do.

  2022-06-01 17:40:32 Views: 211
• 

  The specific operation method of deploying MySQL Galera Cluster

  The following brings you specific methods of operation on the deployment of MySQL Galera Cluster, if you are interested, let's take a look at this article. I believe it will be more or less helpful to you after reading the specific methods of operation of deployment MySQL Galera Cluster.

  2022-06-01 17:40:32 Views: 213
• 

  Set up the concrete operation steps of MySQL master-slave replication and read-write separation on CentOS7.

  This article is mainly about the concrete operation steps of building MySQL master-slave replication and read-write separation on CentOS7. If you are interested, let's take a look at this article. I believe that after reading the gymnastics of building MySQL master-slave replication and read-write separation on CentOS7.

  2022-06-01 17:40:20 Views: 289
• 

  Introduction and installation of redis

  In the previous two articles, we briefly learned about the installation of memcached and the combination of php. Now I introduce another nosql key database redis. Through learning to look up the information, I found that redis is used more frequently than memcached, and its function is more powerful. I will pass through the following.

  2022-06-01 17:40:20 Views: 226
• 

  Semi-synchronous replication (Semi-synchronous Replication)

  Before MySQL5.5, the replication of MySQL was an asynchronous operation, and there was a certain delay between the data of the master database and the slave database. There is a hidden danger: when a transaction is written to the master database and delivered successfully, and the slave database has not yet got the Binlog log pushed by the master library, the master library goes down, such as the master library.

  2022-06-01 17:40:19 Views: 214
• 

  Overview of MySQL Index

  MySQL Index outlines the advantages of an index: 1. By creating a uniqueness index, you can ensure the uniqueness of each row of data in the database table. two。 It can speed up the retrieval of data. Index shortcomings: 1. When the data in the table is added, deleted and modified, the index should also be dynamically maintained and reduced.

  2022-06-01 17:40:19 Views: 251
• 

  Oracle 11gR2 RAC build (virtual machine build)

  Installation environment description and virtual machine regulation: installation environment host operating system: windows 10 virtual machine VMware15: two CentOS-7.6Oracle Database software: Oracle11gR2 (11.

  2022-06-01 17:39:53 Views: 235
• 

  Principle and configuration of MySQL MHA High availability Cluster

  This article mainly introduces the principle and configuration of MySQL MHA high availability cluster in detail. It also introduces the startup method of MHA high availability cluster and the method of checking MHA status. I hope you can get something through this article. MHA High availability Architecture deployment configuration example 1, Preface 1

  2022-06-01 17:39:52 Views: 259
• 

  Soft links solve directory structure problems

  After I moved the Oracle software directory to another directory, and then ran the java graphics tools such as netca,netmgr, I could not find jre. The prompt I saw was always looking for the jre running environment in the old directory structure. I opened it again.

  2022-06-01 17:39:52 Views: 237
• 

  Configure galera+nginx to realize multi-master mode of mariadb and mysql database

  Requirements and problem solving points: 1: existing mysql data master-slave mode, data synchronization delay; 2:mysql master-slave process often crashes, data leveling is difficult; 3: database master-slave or master-master mode data query and write slow; 4:mariadb or mysql database section

  2022-06-01 17:39:51 Views: 280
• 

  The solution to the error of creating Table Times in MySQL Database

  How to solve the error when creating tables in MySQL database: Invalid default value for 'create_date'? I believe that many novice rookies can do nothing about this. Through the summary of this article, I hope you can find a solution. Scene [E

  2022-06-01 17:39:51 Views: 283
• 

  Detailed explanation of redis configuration file

  # General # # start background process daemonize yes# background process pid file storage location pidfile /

  2022-06-01 17:39:51 Views: 280
• 

  RAC modifies parameter DB_FILES

  This blog focuses on the steps of how to modify the parameters under RAC in a production environment, which is a little different from a single instance. DB_FILES defines the number of data files in oracle data. When the number of data files exceeds the value set by this parameter, it will be reported to ORA-00059.

  2022-06-01 17:39:50 Views: 238
• 

  Binding variable 2 of Oracle

  Binding variables (bind variable) we often use in writing plsql, so let's take a look at the difference between static sql and dynamic sql in binding variables in plsql, declare v_value_a varchar.

  2022-06-01 17:39:39 Views: 277
• 

  Oracle Database Patch Conceptual knowledge

  Release standard product release. For example, if the first release of Oracle Database 10g Release 2 is 10.2.0.1, you can download Patch Set Re publicly on OTN, edelivery and other sites.

  2022-06-01 17:39:32 Views: 271
• 

  Basic and examples of MongoDB:MapReduce

  Background MapReduce is a very flexible and powerful data aggregation tool. Its advantage is that an aggregate task can be divided into multiple small tasks, which can be distributed to multiple servers for parallel processing. MongoDB also provides MapReduce, of course, the query language must be JavaSc

  2022-06-01 17:39:32 Views: 295
• 

  How to solve the problem that you can't start MySQL with root account

  How to solve the problem that I can't start MySQL with my root account? I believe that many inexperienced people are at a loss about this. This article summarizes the solution to the problem of not starting MySQL with a root account. Through this article, I hope you can solve this problem. Scene version 5.6.44, [

  2022-06-01 17:39:32 Views: 212
• 

  Hbase cannot empower the user

  Hbase failed to empower the user and reported an error. Background description of the problem: test environment, hdfs has been format. Many hdfs-based environments have been affected. Hbase has also been affected. But in the process of starting hbase on master, as long as the hdfs

  2022-06-01 17:39:32 Views: 273
• 

  Mysql optimizations and types

  MySQL also supports choosing to specify the display width of the integer value in parentheses after the keyword of this type (for example, INT (4)). Int (M) in the integer data type, M represents the maximum display width, which is specified for columns whose width is less than the specified width

  2022-06-01 17:39:31 Views: 293