Database Administrator

Efficient data migration using the table space technology that can be transferred This article demonstrates the Oracle tablespace migration process and many precautions. Tutorial objective: to migrate the tablespace TBS_SEC_D on the oracle 10g

Install MySQL in Ubuntu and perform simple operations Installing MySQL on Ubuntu is very simple and requires only a few commands. 1. sudo apt-get install mysql-server 2. apt-get isntall mysql-client 3. sudo apt-get install libmysqlclient-dev During

Oracle archiving logs Archive Log is a non-active backup of redo logs. archive logs can be used to keep all redo history records. When the database is in ARCHIVELOG mode and the log is switched, the background process ARCH will save the redo log

Build a MySQL environment on the OS X Platform References: The simplest way to install MySQL on OS X is to download the Community version DMG package from the official website. The latest version is version 5.7, the installation method has

MariaDB thread and Connection Today, we will introduce how to check the number of links and threads of mariaDB (the same as MySQL. What is the difference between MariaDB and MySQL. This is an entry to reduce database load and improve database

Use Grid Control to quickly deploy Oracle physical Data Guard Grid Control (GC in this article) is a good helper for monitoring and managing databases, and also a double-edged sword. If you are proficient in applications, You can greatly improve the

MySQL slow query log settings and Analysis The slow query log is used to record some slow query statements, which can help the Administrator analyze the problem. This log is not enabled by default. You need to add a series of parameters in the

TPCC test for MySQL 5.7 Mysq5.7.7-rc System info:System | Dell Inc.; PowerEdge R620; vNot Specified (Rack Mount Chassis)Service Tag | JX47Z42Platform | LinuxRelease | CentOS release 6.6 (Final)Kernel | 2.6.32-431.23.3.el6.x86 _ 64Architecture | CPU =

Oralce creates a userPrerequisites Note that you must first Log On As SYSDBA. You can select the logon role on some development tools.If it is a command lineAs sysdbaCreate user process To create an Oracle database, you can use the SQL developer

MySQL index push-Down Technology The whole idea of index push-down is as follows: To see how this optimization works, consider first how an index scan proceeds when Index Condition Pushdown is not used: Get the next row, first by reading the index

Socket programming: byte order When it comes to socket programming, it will certainly be subject to byte sequence conversion. For a string, there is no difference in the byte order. Just like writing, the memory is like paper, and the string is

MySQL performance query and Configuration Overview View MySQL database performance:Show proceelist view the database connection status and total number of connectionsShow globalstatus like 'max _ used_connections '; view the maximum response

Oracle statement execution tracking An interface on the system often times out to submit data (more than 3 seconds), while I only need 17 ms to execute insert in the background database (Oracle. The client that submits data does not have any

ORA-09817 troubleshooting ORA-09817 error solved one case sharing. When you log on to a development database, the following error occurs: When an error is reported, the system prompts that the audit file fails to be written because there is no

Redis Design and Implementation Study NotesPreface This book focuses on the implementation of the underlying Redis layer, which is divided into four parts: Data Structure and Object Standalone Database implementation Implementation of

Fast paging using ROW_NUMBER The method of listing by page in Linq uses Skip () and Take (). However, how do I write paging using SQL scripts? First, we can sort by ROW_NUMBER () OVER and get a view with serial numbers. Then, we can use the

How to enable MySQL database remote connection Sometimes it is not possible to remotely connect to the MySQL database. You can refer to the following method to solve the problem. 1. log on to the MySQL database of your machine: mysql-uroot-p

MySQL paging Optimization This afternoon, I helped my colleagues rewrite a MySQL SQL statement that involves two tables, one of which is a dictionary table (a field needs to be returned ), the other table is a business table (which contains 150

Oracle Data Pump example Oracle Data Pump example: 1. Export the specified tablespace: Expdp system/xxx DIRECTORY = dump_dir tableapace = xxx dumpfile = xxx _ % DATE :~ 0, 4% % DATE :~ 5, 2% % DATE :~ 8, 2% ". dmp logfile = xxx. log It seems

Description: sqlSessionFactory injection method of MapperScannerConfigurer, sessionfactory Injection SqlSessionFactory injection for MapperScannerConfigurer First, there is a configuration in Mybatis that is very convenient, saving us time to write