Database Administrator

How to rename a MySQL database [Preface] One of the databases needs to be backed up for business needs, and then imported into a brand new database; it is the fastest and easiest way to directly modify the name of the current database for backup.

Cases of high CPU usage and memory usage in MySQL Faults:At about seven o'clock, I received a complaint from the playback center that the video was playing slowly and could not be loaded for a long time. At first, he thought it was the tomcat

SQL Server attaches Database Error 5123 correct solution Because I have a database tutorial based on SQL Server 2005, the sample database used in the tutorial is AdventureWorks for SQL Server 2005, and my computer is equipped with SQL Server 2008,

PostgreSQL -- run Supervisord on Ubuntu in Docker I tried to use the supervisor to start nginx and PostgreSQL on the docker container boot. Use the following Dockerfile and supervisord. conf files. The above application starts, but stops after a

Ten Suggestions for improving database speed and Ten Suggestions for database Learning Important information of many websites is stored in the database. Users can obtain user information by submitting and accessing the database. If the database

[Translated from mos] What is split-brain in Oracle Clusterware and RAC? mosclusterware What is split-brain in Oracle Clusterware and RAC? Source:What is Split Brain in Oracle Clusterware and Real Application Cluster (Document ID

Postgresql fatal error: Reserved connection locations are reserved for Super Users who execute non-replication requests, and postgresql Super Users Recently, database monitoring of the monitoring system is always delayed. An error is reported when

Mybatis FAQ and mybatis FAQ1. Mybatis basics: # {...} and $ {...}MyBatis will #{...} It is interpreted as a parameter mark of JDBC prepared statement. And $ {...} Interpreted as string replacement. It is useful to understand the differences between

Oracle new features 4-maintenance, upgrade, recovery and data pump, and oracle New Features 1. Contents 1) enhanced table partition maintenance. 2) Database Upgrade and improvement. 3) Restore/restore data files across networks. 4) Data Pump

PL/SQL-related data dictionary and plsql-related dictionary Data Dictionary related to PL/SQLHttp://www.oracle.com/technetwork/issue-archive/2012/12-nov/o62plsql-1851968.html Sometimes, we encounter the following problems during PL/SQL development:1

Oracle foreign key cascade deletion and cascade update, oracle key level update Cascading Deletion Oracle has three behaviors: no action (similar to RESTRICT), CASCADE, and set null. The following uses the student-class as an example to describe

Database review 8 -- concurrency, database review 8Database review CH15 concurrency 15.1 concurrency issues The I (Isolation, independent) of the ACID nature of the transaction, and the concurrent transactions are transparent. The interspersed

Oracle BASICS (1), Oracle BASICS ( Oracle Database System is a group of software products with distributed databases as the core provided by Oracle in the United States. It is currently the most popular Client/Server) or one of the databases in the

Navicat premium usage-navicat connects to the MySQL database, navicatmysql Recently, I was studying navicat premium, a third-party database management software. During my internship, I used this software to call the database on the server. However,

Oracle learning path (5) ----- General oracle data type operations, oracle ----- oracle1. Some common Operators Operator Meaning = Equal <> ,! = ,~ =, ^ = Not equal Less >

Oracle learning path (4): oracle learning pathLOB type ORACLE provides the LOB (Large OBject) type for storing Large data objects. ORACLE currently supports the BFILE, BLOB, CLOB, and NCLOB types. NCLOBStores large NCHAR character data types.

Aerospike C client manual --- query-query records, aerospike ClientQuery records In addition to the primary index, the Aerospike C client also provides APIs to query databases through secondary indexes. To use the secondary index to query data,

High-performance Mysql -- Schema and data type optimization; high-performance Mysql Schema Good logical design and the foundation of High Performance for physical designers1. Select an Optimized Data TypeSmaller is usually betterCPU cycle required

After the SQL Server clustered index is rebuilt, the column name of the change column location statistics information remains unchanged, It was originally found by using the clustered index primary key. It was confirmed that it was not a primary key

Data Center reconstruction-Database Design (2), Data Center reconstruction-Database After completing the database requirements analysis, erdiagram, and relational model phases of the data room charging system, we should design the database based on