NAV: SLTechnology News&Howtos > Database >

• 

  Common operations of mysql

  Mysql create database Mysql > create database test;Mysql add users and password Mysql > grant all on *. * to ucenter@'%' identified by

  2022-06-01 16:23:45 Views: 259
• 

  Implementation of redis distributed Lock

  1. Several conditions to be satisfied in using distributed locks: 1. The system is a distributed system (the key is distributed, and the stand-alone can be realized by using ReentrantLock or synchronized code blocks). 2. Sharing resources (each system accesses the same resource, resource

  2022-06-01 16:23:45 Views: 282
• 

  Instantclient_10_2 usage

  1. Create the oracle user useradd oracle2, create the soft folder mkdir-p / home/oracle/soft/3 under the oracle user, upload the corresponding software and extract the unzip basic-1

  2022-06-01 16:23:44 Views: 213
• 

  Unconventional repair methods for mysql innodb engine table

  If the data in the online MySQL production database is mistakenly deleted, and then DBA goes to recover the data, it is found that the database is not backed up and binlog is not open. Is there any other way to try to recover the data? Percona provided an unconventional repair.

  2022-06-01 16:23:44 Views: 212
• 

  Mysql metadata lock Meta Data lock

  What is MDLMDL,Meta Data lock, a metadata lock, is generally called a dictionary lock. Dictionary locks correspond to data locks. Dictionary locks are used to protect data objects from being changed. Generally, some DDL will change dictionary objects, such as two things, thing 1, query the table first, and then things.

  2022-06-01 16:23:44 Views: 223
• 

  Highcost SQL

  Select s.sid, s.serial#, s.username, s.sql_id, m.physical_reads, m.log

  2022-06-01 16:23:43 Views: 253
• 

  Elasticsearch cluster deployment

  Elasticsearch is a distributed search service that provides Restful API, underlying based on Lucene, uses multi-shard to ensure data security, and provides automatic resharding function, github and other large sites

  2022-06-01 16:23:43 Views: 237
• 

  Mongo 3.2 replica set configuration

  1. Environmental information CentOS release 6.7 (Final) mongo version: 3.2.6192.168.1.173 primary192.168.1.174 secondary192.

  2022-06-01 16:23:42 Views: 241
• 

  OOG: the OGG between two instances of a server

  Here we have to complain that there was something wrong with the brother who proposed the test, and then I said to him to do it. But he now plays video games in Internet cafes. The main purpose of this paper is to verify whether the synchronization between instances can be practiced through OGG on a multi-instance server.

  2022-06-01 16:23:30 Views: 246
• 

  Shell script solution for sql server data backup in small Enterprises

  The company has three sql server databases. Every day, the data is backed up locally through sql server scheduling tasks, and then uploaded locally to the data server for preservation. This is repeated, sometimes because the work is busy and forgot to upload, resulting in the phenomenon that the data is replaced without backup. After the right

  2022-06-01 16:23:25 Views: 253
• 

  Question and answer marketing model how to go in the future, there are all marketing circles.

  Question and answer marketing is a hot marketing mode at present, and it is indeed the first step to open the enterprise brand, so what is question and answer marketing? A brief explanation of question-and-answer marketing is to initiate discussion among users by asking questions, focusing on the promotion of enterprises through communication and interaction with users.

  2022-06-01 16:23:25 Views: 263
• 

  How to move the database path in DAG

  There are many scenarios for moving the database path. The typical scenario is that there is not enough disk space. It is not difficult to move the database path to another disk with a wizard. But if DAG is enabled, there are some precautions, as described below. PS: if you need to move the database path, you must

  2022-06-01 16:22:52 Views: 265
• 

  How to install Redis in a windows environment

  Redis is completely open source and free, complies with the BSD protocol, and is a high-performance key-value database. Redis and other key-value cache products have the following three features: Redis supports data persistence and can transfer data in memory

  2022-06-01 16:22:51 Views: 214
• 

  Master and Slave of redis and Sentinel deployment

  First, stand-alone radis deployment 1, install gccyum install gcc2, install redistar-zxvf redis-3.2.9.tar.gz-C / usr/src/cd / usr/src/redi

  2022-06-01 16:22:41 Views: 294
• 

  [basic operation] 1. Table operation

  -1. Basic table operation table drop table user1;create table user1 (id number (5Magne3) not null,-- (NMagine M) N: a total of several digits, M: after the decimal

  2022-06-01 16:22:41 Views: 265
• 

  Centos7-msyql- slow query optimization

  Through the slow query, we can find whether the long-time search statements use index statements to find the bottleneck of mysql, and optimize show variables like'' to query various configuration information show global stat of mysql.

  2022-06-01 16:22:41 Views: 207
• 

  [MongoDB Learning Notes 33] MongoDB copy set rs auxiliary function

  Rs is a global variable, which contains auxiliary functions related to replication. Most of these functions are just wrappers for database commands, such as > db.adminCommand ({"replSetInitiate": config}) and > rs.in.

  2022-06-01 16:22:40 Views: 238
• 

  The influence of MySQL itself on performance

  MySQL architecture if you want to understand the impact of MySQL itself on performance, you need to be familiar with the architecture of MySQL and common storage engines. MySQL is not perfect, but it is flexible enough to adapt to demanding environments, such as Web applications. At the same time, MySQL can be embedded

  2022-06-01 16:22:21 Views: 227
• 

  Detailed introduction and installation configuration of SQL Server database

  1. The necessity of using the database using the database can store data efficiently and clearly, so that the staff can manage the data more quickly and conveniently. The database has the following characteristics: it can store a large amount of data information structurally, which is convenient for users to retrieve and access effectively, and can effectively maintain the number.

  2022-06-01 16:22:20 Views: 299
• 

  Oracle linux 5.8install oracle installation for oracle 11g rac environment

  Continued system configuration, environment variable addition and grid installation in the previous blog, this article is mainly following the remaining installation of the previous post, the previous blog address: http://tongcheng.blog.51cto.com/6214144/18520741. Test

  2022-06-01 16:21:50 Views: 279