NAV: SLTechnology News&Howtos > Database >

• 

  Redis cluster master-slave actual combat

  Redis is a non-relational database and a high-performance key-value database. It is often used as a cache database of relational databases to improve server access speed, especially for high concurrency scenarios. In order to improve the high availability of Redis, let's first talk about redi.

  2022-06-01 20:45:51 Views: 272
• 

  MariaDB minor version upgrade 10.1.22-& gt; 10.1.26

  1. The upgrade reason is that DB is often crash because of the version bug. This may be due to problems with innodb's adoption of new statistics collection. Related web page: https://jira.mariadb.org/browse/MDEV-12281h

  2022-06-01 20:45:51 Views: 280
• 

  Php-mysql version issues in Lnmp environment

  Operating system: CentOS release 6.7 (Final) 64-bit kernel: 2.6.32-573Database: mysql5.6.30 (RPM installation) problems: 1. When the rpm package first installed mysql5.6.30

  2022-06-01 20:45:50 Views: 301
• 

  Installation and Management of Crond

  First, check whether to install the rpm package: rpm-qa | grep cron II. Confirm whether the crond service is set to boot the crond service chkconf at boot service crond status startup and shutdown levels 3 and 5

  2022-06-01 20:45:45 Views: 203
• 

  The implicit cursor returns the result

  The implicit result of SQLPlus: in 12c, SQLPlus returns the result from an implicit cursor of a PL/SQL block without actually binding a RefCursor. This new dbms_sql.return_result process will

  2022-06-01 20:45:45 Views: 261
• 

  What are the optimization methods of mysql

  This article mainly introduces what mysql optimization methods have, which has a certain reference value, friends who need can refer to it. Let's take a look at the mysql optimization method with me. First, the overall optimization idea first build a script to observe the number of queries, connections and other data, to determine the environmental reasons and internal

  2022-06-01 20:45:38 Views: 209
• 

  Oracle View execution Plan

  Method 1: SQL > explain plan for select name from a where a. ID. ID; has been explained. SQL > select * from table (DBMS_XPL

  2022-06-01 20:45:35 Views: 242
• 

  How to install mysql 5.7.13 on linux CentOS 7 system

  This article mainly introduces how to install mysql 5.7.13 in linux CentOS 7 system. The things involved are learned from the theoretical knowledge. There are many books and documents for your reference. From the practical point of view, the accumulated practical experience can be shared to

  2022-06-01 20:45:35 Views: 277
• 

  Data recovery method of server crash and downtime realized by redis

  Today, what the editor shares with you is the data recovery method of redis to achieve server crash and downtime. I believe many people do not know much about it. In order to make you understand better, I have summarized the following contents for you. Let's take a look at it. I'm sure you'll get something. Because redis is stored in memory and provides

  2022-06-01 20:45:26 Views: 262
• 

  Full backup of Mysql and how to restore data by binlog

  This article mainly introduces Mysql full backup, binlog how to restore data, I hope you can supplement and update some knowledge, if you have other questions to understand, you can continue to follow my updated article in the industry information. One day, during the working hours, a bad guy made a mistake and was in production test.

  2022-06-01 20:45:22 Views: 212
• 

  Mysql-5.7.18 Custom installation path handout

  This article mainly introduces the mysql-5.7.18 custom installation path handout, which involves things, learned from the theoretical knowledge, there are many books, literature for your reference, from a practical point of view, accumulated years of practical experience can be shared with you. 1. Prepare mysql in advance

  2022-06-01 20:45:19 Views: 300
• 

  Update details of some mysql commonly used scripts

  The following content mainly brings you some details of commonly used mysql scripts, the knowledge mentioned here, which is slightly different from books, is summed up by professional and technical personnel in the process of contact with users, and has a certain value of experience sharing. I hope to bring help to the majority of readers. Check the lock: more c

  2022-06-01 20:45:16 Views: 211
• 

  How to implement handouts for Mysql Master and Slave in Linux system

  This article mainly introduces the Linux system Mysql master and slave how to achieve handouts, hoping to supplement and update some knowledge, if you have other questions to understand, you can continue to follow my updated article in the industry information. The first thing to do here is to create a database that you want to synchronize for testing

  2022-06-01 20:45:11 Views: 256
• 

  Application of JDBC driver in java connecting mysql

  This article mainly introduces the application of JDBC driver in java connection mysql, which involves things, learned from the theoretical knowledge, there are many books, literature for your reference, from the practical point of view, accumulated years of practical experience can be shared with you. Introduction: connect through java

  2022-06-01 20:44:53 Views: 221
• 

  MySQL main key, index handout

  The following content mainly brings you MySQL key, index handouts, the knowledge here is slightly different from books, are summed up by professional and technical personnel in the process of contact with users, have a certain experience sharing value, hope to bring help to the majority of readers. <-- Catalog-- > 1) Master

  2022-06-01 20:44:50 Views: 218
• 

  Install MySQL-python module to execute database operation method

  This article mainly introduces how to install the MySQL-python module to perform database operation, hoping to supplement and update some knowledge, if you have other questions to understand, you can continue to follow my updated article in the industry information. To perform database operations in python, first

  2022-06-01 20:44:47 Views: 298
• 

  The method of solving the Chinese garbled Code of mysql in cmd

  This article mainly introduces the method to solve the problem of Chinese garbled code in mysql in cmd, the things involved, learned from the theoretical knowledge, there are many books and documents for your reference, from a practical point of view, accumulated years of practical experience can be shared with you. The main content of this article is to solve the problem.

  2022-06-01 20:44:41 Views: 290
• 

  PDO queries how mysql avoids SQL injection

  The following content mainly brings you PDO query mysql how to avoid SQL injection, the knowledge here is slightly different from books, are summed up by professional and technical personnel in the process of contact with users, have a certain experience sharing value, hope to bring help to the majority of readers. Use tradition

  2022-06-01 20:44:38 Views: 288
• 

  What is the reason why redis can do distributed locks?

  What is the reason why redis can do distributed locks? I believe there are many people do not understand, today, in order to let you know more about the reasons why redis can do distributed locks, so give you a summary of the following content, let's look down together. Redis is a single-process, single-thread mode, using queue mode.

  2022-06-01 20:44:29 Views: 261
• 

  How MySQL5.6 deploys the TLS method

  This article mainly introduces how to deploy the TLS method in MySQL5.6. The things involved are learned from the theoretical knowledge. There are many books and documents for your reference. From the perspective of practical significance, the accumulated practical experience for many years can be shared with you. Note: omit MySQL5.6

  2022-06-01 20:44:27 Views: 262