Database Administrator

Install Greenplum source code in CentOS 7 Cluster composition: One host and one slave node. System Environment: Operating System: CentOS 7, 64-bit, 7.4.1708 (in/etc/RedHat-release) CPU: AMD Fx-8300 8-core Memory: 8 GB Hard Disk: 120 GB GNOME: 3.22.2

Install Percona Server in rpm package Percona XtraDBIt is an enhanced version of the InnoDB Storage engine and is designed to better use and update the performance of computer hardware systems. It also contains some new features in high-performance

Install the oracle client in linux and the linuxoracle Client 1. Prepare the required installation

Convert the suffix. frm,. myd, and myi into. SQL and import it to the mysql database. frmmyi Use a local MySQL database to convert these files to. SQL scripts. 1. Install MySQL. The version and font must be the same as that on the server. Otherwise,

[Introduction to Data Mining]-Introduction to data types and Data MiningData TypeDifferent datasets are manifested in many aspects. For example, attributes describing data objects can have different types: quantitative or qualitative. In addition, a

[Introduction to Data Mining]-Introduction to Data MiningIntroduction to Data Mining Reading NotesPrerequisites for data mining: rapid advances in data collection and storage technologies. Data Mining is a technology that combines traditional data

Java uses JDBC to connect to any type of Database (mysql oracle ..), Oraclejdbc Package cn. liz. test; import java. io. inputStream; import java. SQL. connection; import java. SQL. driver; import java. SQL. SQLException; import java. util.

Log System ELK usage (4) -- kibana installation and use, elk -- kibanaOverview Log System ELK usage (1)-How to UseLog System ELK usage (2)-Logstash Installation and UseLog System ELK usage (III)-elasticsearch InstallationLog System ELK usage

1 PreparationCentOS-6.5-x86_64-bin-DVD1Linux_11gR2_database_1of2Linux_11gr2_database204 F2VMware Workstation 10.0.2SSH Secure Shell ClientInstantclient_11_2Plsqldev10052. Install virtual machines and CentOS(1) install VMware Workstation(2) install

Recently, all the company's operating systems have been upgraded to Windows 7. Our company has an ORACLE product software for Engineering Planning called Primavera Six (P6). So I need to migrate the P6 database from XP to the Win7 system. This is

Recently, Oracle released the latest version of MySQL Workbench 6.0, including the Community version and the enterprise version, to improve the development and management of MySQL databases. MySQL Workbench is a unified visualization tool designed

The alarm logs sent by netizens are originally about a deadlock. Another problem is that the logs written from the redo log buffer to the redo log file cannot be allocated with new logs, private strand flush not complete wait event. This is a redo

Introduction to SQLite and introduction to SQLite I. Why SQLite? SQLite is currently the most popular open-source embedded database. compared with many other embedded storage engines (NoSQL), such as BerkeleyDB and MemBASE, SQLite supports some

47 common Oracle PL/SQL Toolkit, oracleplsql47 Oracle PL/SQL Utility Library Common PL/SQL Toolkit code, including: PDF file generation Toolkit: Excel file generation, RTF file generation, Zip file compression and decompression, JSON file

In daily DB2 O & M, we often encounter slow execution of Several SQL statements, but the cpu and memory usage of the database server is not high, similar problems are basically caused by locks, sorting, and other reasons. Next we will analyze how to

MySQL auto_increment gap problem, mysqlautoincrement Link to this book (http://www.jianshu.com/p/cca59b515e20) We often use the auto_increment field in MySQL, especially the innodb engine. I also often use it. I only know that mysql can ensure

The JDBC driver of Informix is type 4. 1. Environment DescriptionOS: Windows XPInformix: IDS V10.00.TC1JDBC: Informix JDBC Embedded SQLJ V2.20JC22. JDBC ConfigurationAfter Informix JDBC is installed, add the ifxjdbc. jar path to the CLASSPATH

During the implementation of software projects, data import has always been a headache for the project staff. In fact, many data import methods are integrated in SQL Server. Some project implementation consultants have a headache. In the eyes of our

In general, it is impossible to avoid any problems during the migration of DB2 database applications. This article will introduce some problems that may occur during the migration of DB2 database applications. BKJIA has previously introduced how to

Import and export data between SQL Server databases (1). Use select into to export data The most widely used SQL Server is to export data using the SELECT INTO statement. The SELECT INTO statement has two functions at the same time: create an empty