Database Administrator

Overview of MySQL btree Indexes Today, I have studied the B-tree index in mysql. Through this article, you can understand the principle of the B-tree index in mysql and the data retrieval process, different btree indexes in innodb and myisam engines,

Oracle PLSQL export data table xx contains one or more CLOB columns Solution When Oracle exports data, the Table xx contains one or more CLOB columns error occurs. This indicates that the Table contains multiple clob types and cannot be exported.

Modify the storage location of MySQL binlog The disk space allocated for the MySQL service installed in the latest project is too small, so that binlog logs can be fully occupied in two days. The processing method is recorded here. Mysql binlog is a

No services and no listener analysis appear in Oracle 11g RAC listeners First, we must know that in Oracle 11g, the GI and Oracle database software are recommended to be managed separately. In this case, we will find that the Database Listener is

How to troubleshoot ORA-00845 errors when the database is started Problem description: A node database is down during inspection. When using sqlplus for the system, an empty instance is connected. An error is reported when the database is restarted

Solution for MySQL ibdata1 files being too largeHandling the problem that the ibdata1 file of MySQL is too large I encountered a MySQL database installed in yum when installing zabbix monitoring. Later I used it for a while to find that the ibdata1

Multi-source replication solution for MySQL Databases Overview Currently, mysql databases in the production environment are distributed on two servers. If the configuration is simple from a single master-slave perspective, the databases of the two

Amoeba for MySQL database read/write splitting I. Environment and software version:System: CentOS Linux release 7.2.1511 (Core)Mysql: Server version: 5.6.33Amoeba: amoeba-mysql-3.0.5-RC-distributionJDK: 1.7.0 _ 80-b15 (jdk is required for running

How to export empty tables from OracleBackground Using the Exp command after Oracle 11g does not export an empty table (rowcount = 0), which is a very bad problem recently encountered in the work and has even been pitted more than once, therefore,

Install and deploy Redis in Linux I recently learned about redis and also recorded the learning summary in this article. This article mainly describes how to install the redis service in Linux.1. Redis Introduction Redis is a non-relational

Let's briefly talk about the use of Join in SQL, and talk about sqljoin. Recently, I encountered a database CPU> 90% due to slow SQL, and the database hang was occupied .. Eventually, all other business queries fail. A detailed analysis is

90% index optimization problems for programmers during interviews, 90% programmers Preface This article will share with you the index optimization that 90% programmers can use during interviews. The basic indexing principles and indexing creation

SpringBoot unofficial tutorials | Article 25th: 2 hours to learn springboot, Reprinted please indicate the source:Http://blog.csdn.net/forezp/article/details/61472783This article is from Fang zhipeng's blog 1. What is spring boot? Takes an

RBAC introduction _ dynamic node Java school arrangement, rbacjava What is permission management? Permission management is basically required for systems involving users. permission management belongs to the category of system security. permission

RBAC permission model _ dynamic node Java school arrangement, rbacjava Permission System and RBAC model Overview Role-Based Access Control (RBAC. During the 1990s s, a large number of experts, scholars, and specialized research institutions

SQL UPDATE statement usage (Single Column and multiple columns), sqlupdate Update statement The Update statement is used to modify data in a table. Syntax: UPDATETable Name SET Column name = New ValueWHEREColumn name = A Value For example: Person

Summary of the Differences Between on and where filtering in SQL connection query statements, sqlwhere Preface I believe that SQL queries are simple and simple for every programmer. Generally, you only need to add, delete, query, modify, and use the

How to download and configure Postgresql in Windows, windowspostgresql Note that the download is a binary version, not a Windows Installer, or a green version. Http://www.enterprisedb.com/products-services-training/pgbindownload X86 download:

Summary of methods to prevent SQL Injection in node-mysql, node-mysqlsql SQL Injection SQL injection is one of the most common methods of network attacks. It does not use Operating System bugs to launch attacks, but is aimed at the negligence of

Problems and Solutions for installing nexus private server in Maven nexus, mavennexus 1. When installing nexus in win10, the system prompts: wrapper | OpenSCManager failed-Access denied. (0x5) The primary reason is that you do not have permissions.