Database Administrator

Detailed process of using mysqld_multi to deploy a single-host multi-instance With the development of hardware, multi-core Linux systems have become a general trend, while MySQL is a single-process multi-thread, so the exploitation of multi-process

With rollup in MySQL MySQL's extended SQL has a very interesting application WITH ROLLUP. The same statistics (SUM, AVG, COUNT…) are performed based on the grouping statistics ...), Similar to the statistical functions in Oracle, Oracle's

PL/SQL data type 1. Variables and constantsVariable Syntax: variable_name data_type [[not null] [: = VALUE]Note: not null is a non-NULL constraint on variable definitions. It must assign a non-NULL initial value to the variable and cannot be changed

Analysis of MySQL High Availability For most applications, MySQL is the most critical data storage center. Therefore, we have to deal with the problem of how to make MySQL provide the HA service. When the master is running, we need to think about

New Features of Oracle 11G: collecting multi-column statistics Generally, when we submit an SQL statement to an Oracle database, Oracle selects an optimal method for execution, which is achieved by the Query Optimizer. CBO (Cost-Based Optimizer) is

The process of reading and modifying data blocks in Oracle Oracle databases process SQL statements in three steps: parsing (parse), executing (exec), and returning results (fetch ). For ease of understanding, we first omit the SQL processing process

Oracle DBMS_RANDOM package details DBMS_RANDOM is a PL/SQL package provided by Oracle to generate random data and characters. It has the following functions. Among them, the initialize, random, and terminate functions are not recommended in

Reset the startup time after the GoldenGate process is disconnected. After the system is restarted, the operator does not restart the goldengate process, resulting in the disconnection of the replication link.In addition, some archiving logs have

MySQL lock mechanism details and deadlock Handling Methods To optimize MySQL in high concurrency, it is necessary to understand the lock table mechanism when MySQL queries an update. I. OverviewMySQL has three levels of locks: Page, table, and

MySQL 'root' @ 'localhost' cannot be logged on This morning, my colleague said that the MySQL root Account could not be logged on. I tried it.# Mysql-u root-pPrompt "Access denied for user 'root' @ 'localhost' (using password: YES )" Because a

Mysql storage engine types, such as MyISAM and InnoDB, and mysqlmyisam For some texts, refer to other blogs or texts.Official explanation: · MyISAM: the default MySQL plug-in storage engine, which is one of the most commonly used storage engines in

MS SQLServer Cross report (Row/column swaps), mssqlserver In MS-SQLServer 2005, you can use the combine operator to convert rows and columns. However, you must use the case when then else end statement in earlier versions. The student renewal table

Redis memory optimization, persistence and master-slave replication, redis memory optimization master-slaveConfiguration of memory optimization parameters of apsaradb for Redis, advantages and disadvantages of each persistence mode, principles of

Configure HiveServer2 and 0.14.0hiveserver2 Based on version 0.14.0In the project, you need to access hive as a mondrian heterogeneous data source to execute MDX queries. Generally, when using hive, I directly execute SQL statements using hive

Special cases of innodb RC lock, innodbrc In MySQL5.7, when read committed isolation level is used, or the deprecated innodb_locks_unsafe_for_binlogsystem variable is enabled, there is no InnoDBGap locking checks tfor foreign-key constraint checking

Modify the display and hide properties of files on mac, and hide files on macShow all the hidden files. Enter defaults write com. apple. finder AppleShowAllFiles-bool true in terminal. Similarly, if you hide the files again, enter defaults write com.

Study of oracle lesson one, oraclelesson Oracle learning Part 1 1. oracle Introduction 1.1 common database categories Small databases: SQL server, access (Microsoft) Medium-sized databases: mysql (from Sweden) and sybase (sybase from the United

Haproxy performs Load Balancing for mysql and haproxymysql1. First install haproxywget http://haproxy.1wt.eu/download/1.4/src/haproxy-1.4.24.tar.gztar zcvf haproxy-1.4.24.tar.gzcd haproxy-1.4.24Make TARGET = linux26 PREFIX =/usr/local/haproxy #

64-bit win7 mysql zip package, win7mysql 1) download the zip package and decompress it. 2) Configure environment variables to the bin directory. For example, your own directory is: F: \ mysql \ mysql-5.6.21-winx64 \ mysql-5.6.21-winx64 \ bin 3)

[Opening for Oracle Database beginners]: oracle Database beginnersDue to project reasons, I recently started to study Oracle databases. Oracle is currently one of the most popular databases, with powerful functions and excellent performance. It is