NAV: SLTechnology News&Howtos > Database >

• 

  3. Persistence-related configuration in redis.conf

  Redis supports two persistence strategies: snapshot and commandlog. The former is achieved by periodically writing a snapshot of the current memory data to the RDB file, while the latter is achieved by recording the writes received by the Redis process in log. The next Redi

  2022-06-01 08:12:25 Views: 296
• 

  Implementation Plan of Oracle fixed SQL (1)-SQL Profile

  We all want to produce a correct execution plan for all SQL,CBO executed in the Oracle database, but this is not the case, for a variety of reasons (such as inaccurate statistics of the objects involved in the target SQL, or some costing within CBO

  2022-06-01 08:12:01 Views: 262
• 

  Common InfluxDB functions for InfluxDB Learning (2) selecting Class functions

  1) the BOTTOM () function returns the smallest N values in a field. The field type must be a long integer or float64 type. Syntax: SELECT BOTTOM ([,],) [,] FROM [WHERE] [GROUP BY

  2022-06-01 08:12:01 Views: 253
• 

  ERROR 1010 (HY000): Error dropping database solution

  Error report: mysql > drop database test;ERROR 1010 (HY000): Error dropping database (can't rmdir'. / test/', err)

  2022-06-01 08:12:01 Views: 245
• 

  Tough life, niubility parameter innodb_kill_idle_transaction

  Roidba always thinks highly of reading official documents and doing experimental tests on his own. Only in this way can he become a qualified DBA. Exercise your hands-on ability. Kill Idle Transactions (mariadb & percona server)

  2022-06-01 08:12:01 Views: 300
• 

  MySQL uses ProxySQL to achieve read-write separation

  Introduction to 1 ProxySQL: ProxySQL is a high-performance MySQL middleware with a powerful rule engine. Official document: https://github.com/sysown/proxysql/wiki/ download address: htt

  2022-06-01 08:12:00 Views: 301
• 

  Oracle11g startup error report missing system parameters

  Error SQL > startupORA-01078: failure in processing system parametersLRM-00109: could not open parameter

  2022-06-01 08:12:00 Views: 256
• 

  Linux modifies mysql default port

  After vi / etc/my.cnf changes the port location to the default port you want to modify, restart the mysql service, ok

  2022-06-01 08:11:57 Views: 302
• 

  View mode and T-SQL statement operation to manage SQL Server database

  About the related theoretical concepts of SQL Server database, please refer to: SQL Server database, table, data type basic concepts one, view schema management table SQL Server has two ways to operate the database, namely visual operation interface and SQL language. The following is introduced

  2022-06-01 08:11:48 Views: 289
• 

  Hive SQL de-duplicates the types of an and b and b

  Yesterday the developer came to our DBA and asked us to write a Hive SQL. Demand: there is a t table, which mainly consists of two columns: the airport name airport and the longitude and latitude distance of the airport. You want to get all the two airport names with distances less than 100s. Actually, I wrote this SQL.

  2022-06-01 08:11:47 Views: 236
• 

  Mongo shell startup configuration file .mongorc.js (2)

  Mongo shell startup configuration file .mongorc.js (II) if you have a .mongorc.js file in your home directory, it will run automatically when you start shell. Use it to initialize any helper methods you use frequently and

  2022-06-01 08:11:17 Views: 301
• 

  Analysis of InnoDB transaction locking

  This article was first published in vivo Internet Technology Wechat official account link: https://mp.weixin.qq.com/s/S7MhlsZveBHRSQhq5aTIJA author: he Zhichuang generally, people's understanding of database transactions may stay in the transaction.

  2022-06-01 08:11:17 Views: 291
• 

  Analysis of the causes of master-slave replication delay!

  Write in the front: when maintaining the online master-slave replication architecture, I encountered some master-slave delay problems, the author, is also relatively easy to learn, ! Therefore, after consulting a lot of materials, and then discarding the dregs, I sorted out this article according to my own understanding and consulting materials. I would like to declare here that the content of this article is from the author.

  2022-06-01 08:11:17 Views: 271
• 

  Several Concepts of PostgreSQL

  At the top of its logical structure is the instance, in which multiple databases can be created, multiple schema can be created in each database, and multiple objects can be created under each schema. Objects include tables, materialized views, operators, indexes, views, sequences, functions,. Wait. Dat

  2022-06-01 08:11:15 Views: 255
• 

  Shunfeng deletion engineer was fired, will he not restore the erroneous deletion of data?

  The following content only represents my personal opinion: it is reported that a Deng in the Shunfeng Technology data Center mistakenly deleted the production database, resulting in a service that could not be used and lasted 590 minutes. After the incident, Shunfeng dismissed Deng and criticized him in the whole network of Shunfeng science and technology. Really played a game of "delete from the library."

  2022-06-01 08:11:09 Views: 218
• 

  Mysql join query (commonly known as join table query) inner join, outer join, natural join

  Classification of join queries the test data used in this article is ``create table student (id int primary key auto_increment,name varchar (10)); insert

  2022-06-01 08:11:03 Views: 255
• 

  Mongodb3.2 installation and basic configuration

  Use yum to install mongodb 3.2 [root@node2 ~] # cat / etc/yum.repos.d/mongodb.repo [mongodb-org-3.2] name=MongoDB R

  2022-06-01 08:10:34 Views: 296
• 

  Oracle 11g installation and configuration tutorial (illustration)-linux

  1. Installation planning network planning: IP: xxxx-- static IP directory planning ORACLE_BASE: / oracle/app-- software directory ORACLE_HOME / oracle/app/db can be modified by yourself-- can be repaired by yourself

  2022-06-01 08:10:34 Views: 215
• 

  Simulate redis disaster recovery (lab)

  At present, the usual design idea is to make use of replication mechanism to make up for the lack of performance of aof and snapshot, so as to achieve data persistence. That is, RDB and AOF are not enabled on master to ensure the read and write performance of master, while on slave

  2022-06-01 08:10:34 Views: 290
• 

  Hadoop + Hbase + Zookeeper installation and configuration complete version (Hadoop1 series)

  Step 1: install Hadoop cluster 1, prepare Enterprise-R5-U4-Server-x86_64-dvd.isohadoop-1.1.1.tar.gzjdk-6u26-linux-x6 for the media needed to build the environment

  2022-06-01 08:10:34 Views: 226