NAV: SLTechnology News&Howtos > Database >

• 

  SqlServer series notes-database creation and backup

  -- create a database create database mydbon primary (name=mydbdata,Filename='E:\ mydb_data.mdf',size=5mb,maxsize=6mb

  2022-06-01 10:32:05 Views: 233
• 

  Openstack M version deployment

  System solution 1, environmental requirements 1, network card em1em2em3em4controller1172.16.16.1172.16.17.1nonenonecontroller1172.16.16.2172.16.17

  2022-06-01 10:32:05 Views: 217
• 

  SQL commonly used in GreenPlum

  The following collates and records some frequently used SQL for later reference: describes how SQL adds a partition (without creating a DEFAULT PARTITION) alter table tablename add partition

  2022-06-01 10:31:35 Views: 230
• 

  Principle and Construction of RAID disk Array

  RAID (Redundant Array of Independent Disks, redundant Array of Independent disks) can provide higher speed and security than ordinary disks, so the server will choose to create RAID during installation. There are two ways to create RAID

  2022-06-01 10:31:35 Views: 262
• 

  The difference of char nchar varchar nvarchar text ntext in SQL

  Type length description length shows that char (n) fixed length index is efficient. Using trim in the program to remove excess white space n must be a value between 1 and 8000. The storage size is n bytes varchar (n) variable length efficiency is not as high as char flexible n must be

  2022-06-01 10:31:34 Views: 208
• 

  Review and Analysis of Tencent Database Diagnostic Competition

  I just analyzed the topic of this competition from a personal point of view, involving some personal experience, learning and exchange. I posted the official git link: the amount of data in the dataorder table of the https://github.com/DBbrain/Diagnosis preliminary competition.

  2022-06-01 10:31:34 Views: 247
• 

  The connection between CDB and PDB

  1. Connect sqlplus system/xxxxx@10.8.5.206:1521/pdbtestALTER SESSION SET CONTAINER = PDB$SEED;2. Switch connection C in CDB:

  2022-06-01 10:31:34 Views: 201
• 

  Mysql_install_db: / usr/bin/perl: bad interpreter:

  Centos 7 installation mysql error-bash:. / scripts/mysql_install_db: / usr/bin/perl: bad interpreter: No such file or

  2022-06-01 10:31:34 Views: 232
• 

  Oracle- memorized by rote

  Lsnrctl start netca name enables listening

  2022-06-01 10:31:33 Views: 224
• 

  Framework arrangement commonly used in .NET platform

  Distributed caching framework: Microsoft Velocity: Microsoft's own distributed caching service framework. Memcahed: a distributed caching system that is currently used by many websites to improve the access speed of websites. Redis: is a high-performance KV data

  2022-06-01 10:31:33 Views: 240
• 

  Koa request log management tool

  Some time ago, I started to optimize the performance of the back-end API, and I found that there was no way to start. Although there were some crude and scattered logs in Kibana, I couldn't see anything. To sum up, there are too few logs, so I decided to do the log first, and the goal is to record the API request phase.

  2022-06-01 10:31:33 Views: 288
• 

  What is the order in which sql keywords are executed

  This article is to share with you what is the order of sql keyword execution, the editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article. The order of sql keyword execution is: first

  2022-06-01 10:31:30 Views: 208
• 

  What is the database primary key ID generation strategy

  What is the database primary key ID generation strategy? Many novices are not very clear about this. In order to help you solve this problem, the following editor will explain it in detail. People with this need can come and learn. I hope you can gain something. The only ID of the system is that we are designing a system

  2022-06-01 10:31:29 Views: 242
• 

  How to check the redis password

  How to check the redis password? In view of this problem, this article introduces the corresponding analysis and answers in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible way. How do I check my redis password? Redis does not implement access control, but

  2022-06-01 10:31:29 Views: 287
• 

  How to use sql triggers

  This article is to share with you about how to use sql triggers, the editor feels very practical, so share with you to learn, I hope you can learn something after reading this article, say no more, follow the editor to have a look. Triggers in sql are triggered when operating on a table

  2022-06-01 10:31:29 Views: 213
• 

  Can redis save objects?

  Can redis save objects? In view of this problem, this article introduces the corresponding analysis and answers in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible way. Redis can store objects, but serialization and deserialization are needed. Why

  2022-06-01 10:31:28 Views: 239
• 

  Blockers and number of blockages

  With TAs (Select ROW_NUMBER () over (order by spid) as id, spid,blocked From (select distinct spid,blo)

  2022-06-01 10:31:28 Views: 298
• 

  Mycat read-write separation and library disassembly table comprehensive experiment 3: analyze the mycat routing process through logs

  # in the client query T1 table, we defined the value of id=1 in the previous schma.cnf. T1 is a global table and is located on a datanode named mysql, so when mycat intercepts the client SQL statement, parse T1

  2022-06-01 10:31:25 Views: 219
• 

  Practice of MySQL-SQL Optimization Audit tool

  1. Background SQLAdvisor is a tool developed and maintained by DBA team (Beijing) of Technical Engineering Department of Meituan Dianping Company to analyze SQL and give suggestions for index optimization. It is based on the original lexical analysis of MySQL, combined with the analysis of where conditions, polymerization conditions and multiple conditions in SQL.

  2022-06-01 10:31:25 Views: 248
• 

  Haproxy Agent mongodb

  The replication set mode adopted by the mongodb cluster has at least 3 nodes. There is a problem, when the mongodb master node down, how to let ceilometer automatically connect to the re-elected master node? There are two solutions to

  2022-06-01 10:31:24 Views: 294