NAV: SLTechnology News&Howtos > Database >

• 

  Introduction to Openstack+Monasca (1)

  Since there is not much introduction to Monasca in Chinese, this series of articles mainly introduces the workflow and principle of Monsca components in openstack: introduction to Openstack+Monasca (1) Monasca components introduce what Monasca is:

  2022-06-01 08:48:21 Views: 281
• 

  Zhongyi Science and Technology Huang Yuanbang Technology Life (16)-- Red Alert-- the wave of Oracle is coming, move quickly!

  1 introduction February 14, on the eve of Valentine's Day, a set of Oracle 11.2.0.4 RAC in a data center went down! A few days later, another set of RAC went down! A few days later, another RAC went down. As an operation and maintenance staff, when you hear that other customers have such a wave of downtime

  2022-06-01 08:47:57 Views: 223
• 

  SQL Learning to create a Student Management Database

  1. First of all, before learning to create a database, as shown in the following figure, let's first introduce the type of database: from the point of view of database application management, SQL server database is divided into system database and user database. Secondly, what are system database and user database? Each of them has

  2022-06-01 08:47:33 Views: 293
• 

  Cache of Django (1)

  Recently, the company is mainly responsible for writing the company's financial accounting, financial statistics functions, but also made up some financial knowledge (these are secondary), the most important of which is to generate a balance sheet. Of course, when generating the balance sheet, the code will certainly go to the database to query a large number of

  2022-06-01 08:47:32 Views: 206
• 

  AWR oracle

  SELECT dbid, baseline_name, baseline_type, moving_window_size from dba_hist_baseline; DBID BAS

  2022-06-01 08:47:30 Views: 204
• 

  Resolve ORACLE startup error ORA-00119,ORA-00132

  The database is suddenly unable to connect. After checking, it may be caused by abnormal shutdown, such as power outage, etc. The startup error is as follows: ORA-00119: invalid specification for system parameter LOC

  2022-06-01 08:47:30 Views: 255
• 

  Error report when installing Oracle under VNC-- Could not execute auto check for display colors

  Using Oracle user installation software under VNC, can not display the graphical interface solution: 1, root user login 2, execute xhost + 3, su-oracle4,. / runInstaller attachment: http://down

  2022-06-01 08:47:29 Views: 225
• 

  Mongodb Monitoring tool mongosniff

  The mongodb monitoring tool mongosniff introduces that mongosniff provides a low-level operational tracking and sniffing view of database real-time activity. You can think of mongosniff as customized for MongoDB, similar to tcpdump for T

  2022-06-01 08:47:29 Views: 261
• 

  Resolve ERROR 1231 (42000): Variable 'time_zone' can't

  Resolve the following errors in the migration or restore process of mysql database: ERROR 1231 (42000): Variable 'time_zone' can't be set to the value of

  2022-06-01 08:47:29 Views: 254
• 

  Some summary of the use of mongodb

  When all query writes are written with a timeout as far as possible, use the batch API to build indexes as much as possible, which will have a certain impact on write performance, so when building indexes, several public fields that can cover most of the data shall prevail. There is indeed a need to add some uncovered.

  2022-06-01 08:47:29 Views: 224
• 

  The basic concepts that must be known in the introduction to database

  The basic concept of database: dynamic website development is inseparable from data storage, data storage is inseparable from the database, database technology is an important part of computer technology, and plays a vital role in software development and other fields. The so-called database can be understood as a warehouse used to store information. And the information is to be stored.

  2022-06-01 08:47:26 Views: 266
• 

  How to realize mysql query the difference between hourly data and hourly data

  This article mainly explains how to achieve the mysql query hourly data and the last hour data difference, the content is clear, interested partners can learn, I believe it will be helpful after reading. First, the preface requirement is to obtain hourly data and last hour data within a certain time range.

  2022-06-01 08:47:25 Views: 280
• 

  JDBC02 uses JDBC to connect to the database [using database connection pooling]

  1 there are several shortcomings when using Statement to execute SQL statements with dynamic information: 1.1 due to the need to splice dynamic data into SQL statements, which leads to high program complexity, error-prone data that contains SQL syntax content will lead to spliced SQ

  2022-06-01 08:46:55 Views: 225
• 

  Twelve suggestions for optimizing sql sentences

  1. Try to avoid judging the null value of the field in the where clause, otherwise it will cause the engine to give up using the index and do a full table scan, for example, select id from t where num is null can be set on num

  2022-06-01 08:46:55 Views: 276
• 

  Nfs learning

  1. Experimental requirements (1) nfs server export / data/application/web; (2) nfs client mount nfs server exported file system to / var/www/html; (3) client (

  2022-06-01 08:46:46 Views: 229
• 

  If the Oracle log file is too large, it is easy to appear 03113.

  Use the find command to query files larger than 2G $cd $ORACLE_BASE$find. -size + 2097160192c./product/9.2.0.4/admin/SID/bdump/alert_SI

  2022-06-01 08:46:35 Views: 240
• 

  New features and enhancements in AlwaysOn 2016

  New AlwaysOn 2016 features and enhanced AlwaysOn availability groups were introduced as new features of SQL Server 2012 that enhance database mirroring and failover clustering technologies, providing high availability and disaster recovery. In SQL Server

  2022-06-01 08:46:35 Views: 245
• 

  MariaDB10.3 adds AliSQL patch-Security execution Online DDL

  Online DDL from the name is easy to mislead the novice, thinking that no matter what the situation, modify the table structure will not lock the table, the ideal is very plump, the reality is very bony, pay attention to this pit! There are two situations where performing a DDL operation will lock the table, Waiting for table me

  2022-06-01 08:46:26 Views: 214
• 

  Mysql full backup and recovery

  Mysql full backup and recovery experiment introduces that database backup can be divided into physical backup and logical backup from a physical and logical point of view. From the point of view of database backup strategy, it can be divided into full backup, differential backup and incremental backup. This experiment mainly introduces full backup. The advantage of full backup is backup.

  2022-06-01 08:46:26 Views: 215
• 

  Index series five-- sum avg optimization of stored values for index characteristics

  Optimized drop table t purge;create table t as select * from dba_objects;create index idx1_object_id of SUM/AVG

  2022-06-01 08:46:25 Views: 225