NAV: SLTechnology News&Howtos > Database >

• 

  MySQL uses pt-archiver to archive historical data

  Pt-archiver can archive tables to a history database according to specified conditions, and also supports file export, which is very convenient for archiving and cleaning up online historical data. If you want to archive the data of a table to a table in a historical database, you need to create a table structure in the historical database in advance. (1) in accordance with the conditions

  2022-06-01 06:15:45 Views: 258
• 

  Mysql, the handling of an error with a synchronization stop

  When an error occurs when synchronization stops due to 'Duplicate entry' or abnormal shutdown of mysql, you can execute the following command to skip error log and continue synchronization from the next error log: mysql > SET GLOBAL SQL_SLAV

  2022-06-01 06:15:39 Views: 288
• 

  The solution to the error of "EXP-00003: storage definition of segment not found" in oracle11g database export report

  When exporting data from oracle11.2.0.2 's server, an error was reported that "EXP-00003: storage definition for segment not found (0jin0)". The preliminary analysis is due to the fact that the data table is empty. Oracle 11G is empty when exporting with EXPORT

  2022-06-01 06:15:39 Views: 286
• 

  The connection between ATM and Database Mysql in java

  Import java.sql.*;import java.util.*;public class ATM1 {String code;int pass;double money;int iTunes 1

  2022-06-01 06:15:39 Views: 262
• 

  Oracle performance optimization

  The index is an optional structure related to the table, which is logically and physically independent of the data of the table. The index can optimize the query, but not the DML operation. Oracle automatically maintains the index. Frequent DML operations will cause a lot of index maintenance. In general, to retrieve table data, the number of

  2022-06-01 06:15:39 Views: 249
• 

  A simple method of how to access PLC remotely through Ethernet

  The general data communication of PLC equipment is carried out by cable when conditions permit. If the PLC equipment is far away from the central control room, the wiring will be quite troublesome. In order to solve this problem, we recommend a new networking scheme: use zero.

  2022-06-01 06:15:37 Views: 246
• 

  Ordinary table to partition table (online redefinition)

  Confirm whether the table can be partitioned SQL > BEGIN2 DBMS_REDEFINITION.CAN_REDEF_TABLE ('SCOTT','EMP',DBMS_REDEFINITION.CONS_USE_PK)

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

  Solution to the problem of very high utilization of oracle 11g sysaux tablespace

  Today, I found that the sysaux table space of a database is soaring, almost 100%. As shown in the figure: check out what takes up space: it is related to awr, and you need to rebuild awr to free up space. For specific reconstruction steps, please refer to my other blog post: http://blog.

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

  How to draw the production management flow chart, teach you to draw the flow chart quickly

  Production management, also known as production control, refers to all kinds of management work on the setting and operation of the whole production system of the enterprise. In our previous work, we spent a lot of time writing an introduction to the production management process and ensuring that there were duplications and more matters in each link. With the development of science and technology, all kinds of management software can easily help enterprises

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

  Installation practice of MySQL5.6 in Linux Environment

  The installation of MySQL is very simple compared with Oracle. I think it is closer to the installation and configuration of TimesTen, and the later configuration of Master-Slave or Master-Master cluster is simpler, even more simple than An of TimesTen.

  2022-06-01 06:15:25 Views: 206
• 

  I have no choice but to! The Redis author was forced to modify the description of the master-slave schema

  I believe all the developers here will not be unfamiliar with Redis's master-slave mode (master-slave). The master-slave pattern in Redis is actually derived from a concept of the same name in MySQL and is a means of synchronizing data. In such a scenario, m

  2022-06-01 06:15:22 Views: 254
• 

  Resolution of sql_trace and 10046 events

  Sql_trace and 10046 event parsing. Docx Oracle SQL Trace and 10046 event http://blog.csdn.net/tianlesoftware/article/detai

  2022-06-01 06:15:21 Views: 267
• 

  Handling of Weblogic JMS queue blocking problem

  The two jms queue,producer of Weblogic are OSB, which transfers logs to jms queue through the interface pipeline. Consumer is an Oracle DB. There was no problem at first, but the concurrency of OSB reached 15% a day.

  2022-06-01 06:15:21 Views: 211
• 

  Oracle Study-- Oracle RAC Reconstruction Control File

  Oracle Study-- Oracle RAC reconstruction control file system environment: operating system: AIX5.3Cluster: Oracle 10gR2 CRSOracle: Oracle 10gR2 in RAC environment

  2022-06-01 06:15:20 Views: 300
• 

  Where is the docker container volume usually placed?

  Where is the docker container volume usually placed? The data volume is presented to the docker container in the form of a directory that supports sharing among multiple containers, and modifications do not affect the image. Data volumes that use Docker are similar to mounting a file system in a system using mount. one

  2022-06-01 06:15:20 Views: 241
• 

  PostgreSQL DBA (23)-MVCC#3 (transaction snapshot and isolation level)

  As mentioned earlier, PostgreSQL uses a method called Snapshot isolation Snapshot Isolation (SI) for concurrency control, and here is a brief introduction to basic concepts such as snapshots and isolation levels associated with PostgreSQL. Attention: 1: 00. For the sake of simplicity

  2022-06-01 06:15:20 Views: 282
• 

  MySQL 5.7 performance_ schema Library and sys Library commonly used SQL

  Performance_ schema libraries commonly used SQL: view tables without primary keys: SELECT DISTINCT t.table_schema, t.table_nameFROM information_schem

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

  Summarize some reasons for the high CPU sys% of oracle database host.

  Today I would like to share a brief summary of some of the reasons for the high CPU sys% of the oracle database host. In the daily database operation and maintenance, the utilization rate of operating system CPU has always been an appropriate indicator for us to measure the system load. For example, USER% can be better.

  2022-06-01 06:15:04 Views: 239
• 

  The use of Chinese language processing package Hanlp

  Originally wanted to call Java through python to achieve the use of Hanlp, refer to the article: http://t.cn/RUrIF7z##########python can use easy_install to install some software #

  2022-06-01 06:15:00 Views: 278
• 

  Add, delete, change and check the T-SQL of SQLServer

  Add-insert sentence: insert into table name (column name, column name) values (data, data) such as-add Class 3 Zhang San score of 90 to the score sheet: insert into (name, grade, class) value

  2022-06-01 06:14:55 Views: 206