Database Administrator

What MySQL must think of before creating an index MySQL introduced metadata lock in version 5.5.3His intention is to solve several bugs in the transaction isolation feature of previous versions, but the introduced problems are not small. Let's talk

Test and failure of Oracle Materialized View Description: The Materialized View (Materialized Views) is the query result set. Changes to all original tables and Views will invalidate the Materialized view, recently, I found a problem that

Silent Installation of Oracle databases on Oracle Linux 7.0 Silent Installation is rarely used, and basically does not require Silent Installation. Xmanager is used to redirect graphics even for text-installed systems. But there is always an

Solution for sqlserver2000 to forget the sa password -- change the sa password and sqlserver2000sa I haven't used sqlserver2000 for a while. I accidentally used it today and forgot the sa password. As a result, the program failed to connect to the

Key elements of mysql high concurrency performance and mysql concurrency Elements Author: fallen flower fragrance Blog: http://blog.csdn.net/qing_gee If other websites are reprinted, please be sure to indicate the source! Preface: I have been

Oracle Gateway11g R2 accesses the configuration documents of heterogeneous databases (DB2), gateway11gdb2   Directory1. Prerequisites 2. Download transparent gateway 3. Unzip and install transparent gateway 4. Install the DB2 client program 5.

Difference between p (x | theta) and p (x; theta), theta Http://blog.csdn.net/pipisorry/article/details/42715245 Two representation methods are available for maximum likelihood estimation.   From: Gregor Heinrich-Parameter estimation for text

ParameterType usage of MyBatis Mapper configuration file, mybatismapper. xml The parameterType attribute is mentioned in the select, insert, update, and delete elements of MyBatis. The parametertypes that MyBatis can currently use include basic data

Oracle like fuzzy query and oracle fuzzy query In some queries, you may not be sure about the exact value to be queried. For example, when Baidu searches, you can enter keywords to query the relevant results. Such queries are called fuzzy

View and add table partitions in MYSQL, and add partitions in mysql View and add table partitions in MYSQL 1. View table partitions SELECTPartition_name part,Partition_expression expr,Partition_description descr,FROM_DAYS (partition_description)

Compile and install MySQL 5.5.x and MySQL 5.5.x in Linux source code Linux: CentOS 6.5 MySQL version: 5.5.20, attached: [Click to download] 1. Install cmake MySQL 5.5 and later versions have been replaced by the cmake tool./configure compilation and

Duplicate from active dg run script sfile is a complete configuration that may cause some errors, duplicatesfile Oracle 11g RMAN: Interpretation of the command for creating dg in Active Database Duplication for standby database If the previous

Output the log configuration of java log4j to mysql, log4jmysql Log4j supports outputting logs to files, databases, and even remote servers. This time I will share with you how to output logs to mysql. (1)The configuration of log4j. properties is as

ERROR 1044 (42000): Access denied for user ''@ 'localhost' to database 'mysql'. Solution: 104442000 The newly installed mysql database encountered a problem when accessing the mysql database: ERROR 1044 (42000): Access denied for user ''@ 'localhost'

Using Gearman to synchronize data from MySQL to Redis, gearmanredis For data that frequently changes, if you still use the traditional static cache method (Memocached, File System, and so on) to display data, there may be a huge overhead in cache

Common oracle functions-decode and oracle-decode The Decode function is very useful in actual development and has powerful functions. Combined with other functions, it can simplify a lot of work; DECODE (field, condition 1, result value 1, condition

Database Stored Procedure introduction and instance, database Stored Procedure instance I. Differences between stored procedures and functions: 1. In general, the functions implemented by stored procedures must be more complex, while the functions

Oracle performance optimization operation 2: Avoid unnecessary type conversion and oracle Performance Optimization It should be noted that the potential data type conversion should be avoided as much as possible. For example, if you compare the

Oracle Data insertion and oracle Data insertion Syntax structure:Insert into Table Name (column name 1, column name 2 ......) VALUES (value 1, value 2 ......) Code Demonstration: SQL> INSERT INTO INFOS VALUES (①2 's10010', 'lin chong', 'male', 22, 2,

Install the MySQL-server and MySQLdb modules in ubuntu14.04, and ubuntu14.04mysql Install Ubuntu14.04 on a VM 1. Check that the IP address can be connected to the Internet. Ii. sudo apt-get install aptitude Note: aptitude features similar to apt-