Database Administrator

MySQL dual-host hot backup is often used in Linux Server lvs load balancing and dual-host hot backup applications. The installation and configuration process is as follows: 1. Install MySQL # Cp

Install MySQL 5.0.22 in openSUSE 11.1 1. Open mysql5.0.22http: // download.mysql.cn/download_file/gz/5.0/mysql-5.0.22.tar.gz 2. The downloaded file is named mysql-5.0.22.tar.gz. 3.copy the downloaded mysql5.0.22.tar.gz file to the/usr/local

I 've been hearing that installing Oracle on Ubuntu is quite troublesome. I 've experienced it today and may be lucky. There's no problem. Just record it and declare that I installed Oracle XE, that is, the quick version mentioned on the official

How to solve the problem of max_allowed_packet is read-only when BugZilla is installed on Fedora 11Problem description: When I have installed all the perl modules and MySQL databases, the following error occurs when I run./checksetup. pl:DBD: mysql:

Today on the server df next, a look, var directory has been 98%, clear some log files and backup files found that mysql below a lot of files similar to mysql-bin.000001, if Google says it's a log, it's useless. Database operation logs Mysql-bin.000

How to Get Discuz recently! Apply Memcache to do some things and record the Memcache installation process. The detailed method is as follows: 1. Download memcached and libevent respectively and put them in the/tmp directory:# Cd/tmp# Wget http://www.

Copyright statement: original works can be reproduced. During reprinting, you must mark the original source, author information, and this statement in hyperlink form. Otherwise, legal liability will be held.Http://tianzt.blog.51cto.com/459544/212606

The SELECT statement of MySQL has the following parameter: SQL _CALC_FOUND_ROWS. This parameter can be used with the function FOUND_ROWS () provided by MySQL. When we use LIMIT ?,? During paging query, only the records you want are returned. For

I. OverviewMongoDB is an open source database project based on distributed file storage. Written in C ++. It is designed to provide a high-performance data storage solution that can be expanded for WEB applications. MongoDB is a product between

I. Question 1 The following error is found in the alert log for RAC standby: SUCCESS: diskgroup DATA was mounted ERROR: failed toestablish dependency between database dave_st and diskgroup resourceora. DATA. dg SUCCESS: diskgroup FRA was

OutlineI. Log ClassificationIi. Log details Note: MySQL version, Mysql-5.5.32 (different versions of mysql variables are different) I. Log ClassificationError LogQuery logsSlow query logBinary logRelay logTransaction LogRolling logs Ii. Log details1.

I have recently studied how to solve the IO competition problem if the storage level cannot be optimized. Finally, I thought of asynchronous IO. My redo disk write speed has reached the maximum value, no matter how I adjust the redo size and number

I checked alert log and found the following error: View alert log: Fri Aug 2 07:13:33 2013 Errors in file/u01/Oracle/admin/eptdb/bdump/eptdb1_j002_961_4.trc:ORA-00600: internal error code, arguments: [ktspNextL1: 4], [], [], [], [], [], [], [],

Oracle Online Segment shrinkage (Online Segment Shrink) refers to the fragments in the Online Segment space. It has the following features: Online, that is, in the segment compression process, DML is almost unaffected (DML will be blocked only a

Oracle 10 DBMS_MONITOR tracks and analyzes other session SQL statements 1. session information View the current session information statement Select sid, serial #, username, machineFrom v $ sessionWhere type! = 'Background'And username = 'sys '; --

Note:This article installed and configured the Oracle 11g slave uard physical standby Database, and tested the new feature of the 11g slave uard physical standby Database Active Data Guard. It is a feature of Oracle Database Enterprise Edition and

A developer said that there was a problem when using postgres's extended row-to-column application. The example is as follows: For more information about the extension package, see: I. EnvironmentOS: CentOS 6.3DB: PostgreSQL 9.3.0 Ii.

After hive-0.11.0 came out, I learned that row_number was encapsulated. It is a great happiness for me who do not know java! Don't hesitate to discard 0.8.0! The specific upgrade steps are as follows: 1. Disable the processes currently being

Configure the database environment, goldengate users, and install goldengate. For more information, see steps 1-4.Configuration required for Oracle-Oracle one-way replication using the Data Pump: -- Here I only configure to synchronize the test3

MySQL 5.5 Command Line Client cannot be opened (disappears in a flash) Solution Solution: 1. Find the bin directory path under the mysql installation directory. 2. Open cmd, enter the path to the bin directory, and enter mysql-u root-p. Problem