NAV: SLTechnology News&Howtos > Database >

• 

  MySQL5.7.16 gtid replication

  "basic environment preparation:" first install two MySQL5.7.16 databases, and install the following steps: first, system environment preparation: ①: system yum source configuration: [linux] name=linux haebaseurl= file:///medi

  2022-06-01 18:39:05 Views: 235
• 

  How to install and configure Mysql in linux?

  This article is to share with you how to install and configure Mysql in linux. I believe most people have not yet learned this skill. In order to let you learn, I have summarized the following content. Without saying much, let's read on. There are many ways to install MySQL under preface linux

  2022-06-01 18:39:05 Views: 237
• 

  Data types and distributed Storage

  Data types and distributed storage = Overview: =

  2022-06-01 18:39:04 Views: 280
• 

  Database mail

  After you configure Database Mail in SQL Server, you can use the stored procedure msdb.dbo.sp_send_dbmail to send mail to a specific User, or notify the DBA database of an exception as soon as possible

  2022-06-01 18:39:02 Views: 238
• 

  Zentao dual computer (database backup)

  All the data of Zen Tao is stored in the database, so as long as the database is backed up, the entire Zen system is backed up. Let's share the backup I wrote by myself: ShellGunxing Bash DateNow=$ (date +% Y%m%d) BackupDir=.

  2022-06-01 18:39:01 Views: 260
• 

  How to install MySQL JDBC and ODBC drivers version 8.0.12

  The following is mainly about how to install MySQL JDBC and ODBC drivers version 8.0.12. I hope these contents can bring you practical use. This is also my article on how to install MySQL JDBC and ODBC drivers version 8.0.12.

  2022-06-01 18:38:59 Views: 260
• 

  The method of solving MySQL deadlock

  The following to understand the solution to MySQL deadlock, I believe you will benefit a lot after reading, the text in the essence is not much, hope to solve the MySQL deadlock solution this short content is what you want. First, viewing the MySQL deadlock MySQL database will solve the deadlock by itself, and kill will be dropped.

  2022-06-01 18:38:59 Views: 257
• 

  What key points should be paid attention to in optimizing mysql index

  This article mainly introduces you to optimize the mysql index need to pay attention to which points, the contents of the article are carefully selected and edited by the author, with a certain pertinence, for everyone's reference significance is still relatively great, the following with the author to understand the optimization of the mysql index need to pay attention to which points it. One, head.

  2022-06-01 18:38:59 Views: 255
• 

  Methods of creating, modifying and deleting mysql tables, views and indexes

  The following is about how to create, modify, and delete mysql tables, views, and indexes. The secret of the text lies in being close to the topic. So, let's not talk about gossip. let's just read the following. I believe you will have some ideas on how to create, modify and delete mysql tables, views and indexes after reading this article.

  2022-06-01 18:38:58 Views: 233
• 

  Xhost: install oracle under unable to open display linux

  1. Log in to the command xdpyinfo as a root user, and record the string after name of display:, such as when name of display:127.0.0.1:1.0 executes the xhost + command

  2022-06-01 18:38:58 Views: 276
• 

  A detailed introduction to the basic operation of Python full-stack MySQL database

  The following brings you the details about the basic operation of Python full-stack MySQL database. I believe you must have read similar articles. What's the difference between what we bring to everyone? Let's take a look at the body part. I believe that after reading the Python full stack MySQL database, you have a basic operation.

  2022-06-01 18:38:58 Views: 206
• 

  What is MySQL's temporary watch? What's the difference between memory table and memory table?

  There are two main types of temporary tables in MySQL, including external temporary tables and internal temporary tables. The external temporary table is through the statement create temporary table... For the temporary table created, the temporary table is only valid for this session. When the session is disconnected, the temporary table data will be cleaned automatically.

  2022-06-01 18:38:58 Views: 258
• 

  How to realize the second kill function with Redis optimistic lock

  In the development of high-traffic programs, there are bound to be scenarios of high concurrency applications. The solution is roughly divided into two directions, message queue and lock. Redis implements the simple version of the message queue core $key = 'quque'; / * *

  2022-06-01 18:38:57 Views: 227
• 

  Linux operation and maintenance (database special topic) interview questions

  1. What is a relational database? What is a non-relational database? The concept of relational database: can be understood as a second-dimensional table, each relationship has a relational name, that is, the table name, which refers to the database non-relational database organized by relational model: relational database exposes a lot.

  2022-06-01 18:38:57 Views: 244
• 

  The most common MySQL interview and written test questions

  I don't know if you know anything about the most common articles like MySQL interview and written questions before. Today I'm here to tell you a little bit about it. If you are interested, let's take a look at the text. I believe you will get something after reading the most common MySQL interview and written test questions. 01 、 My

  2022-06-01 18:38:56 Views: 235
• 

  Interaction between Hbase components

  Hbase implementation Hbase A Master node is responsible for coordinating and managing one or more RegionServer slave machines. The Master is responsible for starting, assigning the area to the registered RegionServer and recovering the failure of the RegionServer.

  2022-06-01 18:38:50 Views: 223
• 

  Linux software package management

  First of all, the linux software package is incompatible with the package in windows, so to use programs on windows on linux, you need to use virtualization tools. Library-level virtualization: linux: WinEwindows: Cywin and

  2022-06-01 18:38:50 Views: 206
• 

  Several common methods of optimizing mysql

  Let me give you a brief introduction to several common ways to optimize mysql. Have you known about similar topics before? 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 several common methods of optimizing mysql. 1. Select the appropriate storage

  2022-06-01 18:38:50 Views: 209
• 

  The solution to the non-synchronization of the two masters and slaves of mysql

  The following brings you about the solution to the non-synchronization of the two masters and slaves of mysql. If you are interested, let's take a look at this article. I believe that the solution to the non-synchronization of the two masters of mysql will be of some help to you. The solution of master-slave non-synchronization first goes to the Master library: mysql

  2022-06-01 18:38:49 Views: 206
• 

  How to set the password to access redis-server in Linux?

  Redis is installed on the server today, so set the password to access redis-server for security. First, find the redis.conf file. Our server has installed redis. Now check the process of redis through the command: [root@lnp

  2022-06-01 18:38:49 Views: 299