Solutions to the increasing size of MySQL ibdata1 files I encountered a MySQL database installed in yum when installing zabbix monitoring. Later I used it for a while to find that the ibdata1 space under the data Directory was very large, on the
Enable MongoDB IP Security on Ubuntu By default, MongoDB3.6 rejects unauthorized links from accessing the public network to protect data from external threats. MongoDB only listens to local links, unless you add rules to allow listening to other
ORA600  logical error analysis and solution for tables and index data I. Problem Overview 1. database environment: Oracle Database 184.108.40.206.0 for Oracle Linux Server release 6.4, RAC, Virtual Machine 2, inspection found a Database alert. log
Use Redis for pre-stock Cache Recently, in my work, I gradually switched the cache of one of the PHP projects from the previous APC cache to Redis, and implemented inventory maintenance based on the data structure supported by Redis. The cache is
Add a new service to InfluxDB in CentOS7.3 Operating System: CentOS7.3.1611 _ x64 Go language version: 1.8.3 linux/amd64 InfluxDB version: 1.1.0 Here, we use the syncd service as an example to record the process of adding a new service to
Resolving index failure when Oracle Partition Table deletes partition data I. Description Today, we have a small task to delete some data. Haha, please be happy first. Because the data table to be deleted is the partition table that I previously
Examples of handling excessive MySQL connections I. Problem Description Today, I suddenly received an error: 503 Service Temporarily Unavailable. After query, it is found that a user has a large number of connections and the database connection has
Case study of MySQL startup failure data recovery Forcing InnoDB Recovery provides six levels of repair mode. Note that when the value is greater than 3, the data file will be permanently damaged and cannot be recovered. The six levels are excerpted
Oracle sequence, index, and synonym A simple record of knowledge about Oracle sequences, indexes, and synonyms. 1. Common database objects Ii. Sequence Sequence: a database object that can be used by multiple users to generate unique values.
ORA-12034: The materialized view log on SCOTT. "USER_TABLE" is newer than the last refresh Recently, when I handed over my work, I found that several schedule jobs were not successfully executed. I have shown that one of them is due to database
How to install Redis using yum in CentOS 1. Because the official CentOS yum source does not contain Redis, We need to install a third-party yum source. Here we use the epel repository of Fedora. Yum install epel-release You will be prompted to
How to Use MongoDB performance analysis tool mongostat Mongostat is a MongoDB performance analysis tool used to check the running status of mongodb. Test: Test/node-131/# restart stat -- helpUsage:Using stat Monitor basic MongoDB server statistics.
MySQL official source cannot be started after direct yum upgrade from 8.0.3 to 8.0.4 Server Environment: CentOS 7.4.14 Problem: MySQL cannot be started normally View logs 2018-02-23T02: 10: 08.371209Z 0 [System] [MY-010116]/usr/sbin/mysqld (mysqld 8.
Install and configure MongoDB in Ubuntu 16.04 LTS MongoDB is a high-performance NoSQL database. Compared with relational databases, it also provides high performance and high flexibility. Here we will explain how to install and configure the MongoDB
Oracle knowledge collection: monitoring and checking Oracle databases I sorted out some basic Oracle knowledge and shared it with you. 1. How to monitor and check Oracle databases Sqlplus '/as sysdba' Manually generate an oracle database
After Redis saves the snapshot, it cannot be written. Today, developers suddenly told me that Redis cannot be written. After entering Redis, I found that this is indeed the case and I cannot execute the set command. The following error is reported: 1
Oracle Materialized View Details In actual work, multiple data sources are synchronized to a single database for data analysis. These data can not be synchronized in real time. Generally, we extract data from the statistical analysis database
SparkSql predicate push-down rule in Chinese and foreign join queries, sparksql Predicate SparkSql SparkSql is a distributed SQL engine built on the spark computing framework. It uses DataFrame and DataSet to carry structured and semi-structured
In-depth understanding of MySQL 5.7 GTID series (II): GTID-related internal data structure, mysqlgtid Author:Gao Peng (Eight monsters in Chongqing) Original article address: Https://www.jianshu.com/p/5649644fdc13 I have a deep understanding of
In-depth understanding of MySQL 5.7 GTID series (1) and mysqlgtid Author:Gao Peng (Eight monsters in Chongqing) Original article address: Http://www.jianshu.com/p/87f66cdeb49c A total of 10 articles will be published this time. The source code