NAV: SLTechnology News&Howtos > Database >

• 

  [MySQL] simple example of Dockerfile writing

  When starting MySQL service with MySQL image, we often encounter the problem of time zone and character set. This article will reconstruct MySQL image in the form of Dockerfile to solve this problem completely. 1. Pull the official image docker pull mys

  2022-06-01 15:02:26 Views: 279
• 

  Tbs_P1: create, change and delete tablespaces

  SQL > conn system/oracleSQL > CREATE TABLESPACE tbs_peenbooDATAFILE'/oradata/tbs_peenboo_01.dbf' size 1

  2022-06-01 15:02:26 Views: 287
• 

  ORA-01119 ORA-17502 ORA-15041

  ERROR at line 1:ORA-01119: error in creating database file'+ DATA'ORA-17502: ksfdcre:4 Failed to cre

  2022-06-01 15:02:23 Views: 206
• 

  Detailed documentation for complete installation of openstack mitaka (in person, it took 3 days)

  Openstack official document installation system version centos7 (minimal installation) 2 machines with 2g memory (4-6g is recommended for the control node, because 2g feels stuttered when I try it, and dashboard feels a little slow to react), cp

  2022-06-01 15:02:04 Views: 287
• 

  One of the mongodb Learning Notes: a preliminary understanding of mongodb

  Official website articles, compare SQL and mongodb http://docs.mongodb.org/manual/reference/sql-comparison/db-- show the currently used library show dbs-- display

  2022-06-01 15:01:31 Views: 304
• 

  Greenplum introduction

  There are two types of databases: 1. OLTP: heavy throughput and high concurrency; foreground applications, customer-oriented. Main features: a, the amount of data processed at a single time is very small, b, the response time is very high, c, the number of users is large 2, OLAP: re-calculation, Greenplum belongs to the number of OLAP; backend

  2022-06-01 15:01:31 Views: 223
• 

  Use log miner to analyze oracle logs

  When we lose or change the database data due to careless misoperation, we need to recover the database objects based on the point in time to find the data we need. This time point cannot be considered accurate. We can get the exact time point without operation by analyzing the oracle log. O

  2022-06-01 15:01:31 Views: 281
• 

  Zabbix 3.0.3 LTS installation / configuration / 2.x upgrade

  Environment preparation: operating system: CentOS 7 or above. Install mysql1. Set up Mysql account groupadd mysqluseradd-s / sbin/nologin-g mysql-M mysql2. Chuang

  2022-06-01 15:01:31 Views: 257
• 

  Information_schema database

  Title indexing system structure table INNODB table system structure table informaiton_schema is the database of mariadb, through this table you can roughly understand the structure and understanding of mariadb database, 1.CHARACTER_SETS: database table

  2022-06-01 15:01:30 Views: 275
• 

  Daily deadlock tracking and processing of SQL Database

  DECLARE @ spid INTDECLARE @ blk INTDECLARE @ count INTDECLARE @ index INTDECLARE @ lock TINYINTSET @ lock=

  2022-06-01 15:01:30 Views: 252
• 

  MySql Learning Notes (7): usage of explain- Index

  Main content: introduction to possible_key, key, key_len, ref and rows of explain. 1. Possible_key represents the indexes that may be used during the query. If there is an index on the field involved in the query, the index will

  2022-06-01 15:01:30 Views: 284
• 

  Linux package Management (CentOS)

  Components of binary applications: binaries, library files, configuration files, help file package managers: debian:deb, dptredhat: rpm, rpmrpm: Redhat Package Manager (RP

  2022-06-01 15:01:30 Views: 201
• 

  Oracle merge merges data

  The function introduced by Oracle 9i-to perform insert or update operations according to specified conditions-to perform update operations if there are rows that meet the criteria; otherwise, to perform insert operations-1 to avoid repeated insert and delete operations-2 to improve efficiency and ease of use-3 counting

  2022-06-01 15:01:26 Views: 271
• 

  To delete a database file by phpmyadmin

  This article is to share with you about the steps of phpmyadmin to delete database files, 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. Enter phpmyadm first

  2022-06-01 15:01:13 Views: 302
• 

  Sql_slave_skip_counter, did you really use it right?

  Write in front: recently, I have been doing tests related to traditional master-slave replication, thinking about many problems that may occur after the online master-slave replication architecture, and then pertinently setting these failures, and then thinking about how to carry out the failure under the premise of ensuring the availability of the business, or with as little impact on the business as possible.

  2022-06-01 15:01:12 Views: 273
• 

  The role of scope=both or scop=pfile in Oracle

  There should be something called spfile in scope=both and scope=spfileOracle, which is a dynamic parameter file, which sets various parameters of Oracle. The so-called dynamic means that you can do it without shutting down the database.

  2022-06-01 15:00:46 Views: 237
• 

  MySQL COLUMNS partition

  COLUMN partition is introduced since 5.5. only RANGE COLUMN and LIST COLUMN are supported; * *, date and string are supported. The partition methods of RANGE and LIST are very similar. COLUMNS and RA

  2022-06-01 15:00:46 Views: 272
• 

  SQL Server 2017 AlwaysOn AG automatic initialization (XVI)

  Summarize the considerations for using automatic seed settings in our production environment: because SQL Server 2016 and 2017 behave differently in disk file path requirements, 2017 can deploy data files on different volumes on primary and secondary copies, so 2017 is more flexible

  2022-06-01 15:00:45 Views: 250
• 

  Mongodb comes with web performance monitoring

  Mongodb comes with a web interface monitoring. The configuration is relatively simple, only need to add the parameter at startup:-- httpinterface or write httpinterface=true to the configuration file to restart. Enter: ip:mon in the browser

  2022-06-01 15:00:39 Views: 267
• 

  What is the SQL Server proxy service? What is its function?

  The SQL Server Agent agent service, a standard service of sql server, acts as an agent to perform all sql automation tasks, as well as unattended tasks such as database transactional replication. This service is stopped by default and needs to be started manually

  2022-06-01 15:00:30 Views: 225