Database Administrator

I. Oracle Enterprise Linux 5.0: Required component installation:GNOME Desktop EnvironmentEditorsGraphical InternetText-based InternetDevelopment LibrariesDevelopment ToolsServer Configuration ToolsAdministration ToolsBaseSystem ToolsX Window System 2

The default selinux configuration of RHEL5.1 only allows the MySQL Server to listen on port 3306. To enable MySQL to listen on other ports, you need to use the semanage command to set the listening permission for the MySQL Server. The following

In addition to the well-known Chinese characters, mysql instances on Linux may encounter the following problems: You use mysql5x and configure the database to use the UTF-8 character set, you use the linux Standard jdk environment, you use a high

Starting from MySQL 5.0.2, the server cursor is implemented through the mysql_stmt_attr_set () c api function. The server cursor allows the server to generate a result set, but does not transmit it to the client unless the client requests these rows.

This morning, the production sybase Database suddenly went down. I used [root @ d1 install] #./startserver-f RUN_mcsdb to disable other startup tasks. The following error is also reported. [Root @ d1 install] # Incorrectly built binary which

MySQL5.0 version of the installation of graphic tutorial is FOR beginners to learn, first download MySQL-5.0.22 (source package) FOR Linux address: Ghost (Installation Package) can go to the official website http://dev.mysql.com/downloads/ The

1. Create password file commandOrapwd file = <> password = <> entries = maximum numberThe file naming rules are in orapw in unix/linux and pwd. ora in windows.For more information, see the description below (this is a summary of pub's netizens)1.

1. test environment: > Master: physical machine, Debian (testing) + mysql5.0 + ip: 192.168.40.223 > Slave: Virtual Machine, CentOS (4.0) + mysql5.0 + ip: 192.168.40.225 2. Modify the Master (192.168.40.223) 1). Modify/etc/mysql/my. cnf Make the

MySQLMain configuration file location:/etc/mysql/my. cnf. Database Table Folder:/var/lib/mysql/, which is equivalent to the date folder of MySQL in Windows in Ubuntu Linux Log on to MySQL and run the encoding: Show variables like 'character % '; + --

After installing Oracle10g, I want to enable SQL * plus for learning, and then follow the steps in the book to connect to the database with scott user. After the installation, an error is prompted several times. Error: the account is locked Then I

The following describes how to use common data dictionaries for Oracle users by category. I. Users View the current user's default tablespace SQL> SELECT username, default_tablespace FROM user_users; View the role SQL of the current user> SELECT *

Export in Windows and run the following command in the mysql \ bin directory of the command line: Mysqldump-uroot-p password-a> mysql_data. SQL Copy the file mysql_data. SQL to Linux. Run in Linux: Mysql-uroot-p password The above method is

The preceding method uses the combination of Red Flag DC Server 5.0 and iASP to connect to an independent ms SQL Server 2000 using ASP. The advantage of this method is that you do not need to modify the user's database environment. However, the

Oracle 11g allows the index to be marked as invisible. oracle maintains the invisible index like other indexes, but the default invisible index cannot be used by the optimizer unless OPTIMIZER_USE_INVISIBLE_INDEXES = TRUE is explicitly set (you can

Today, I received a requirement to establish a replication mechanism for MySQL internationally. This is actually nothing, and the network environment is worse, MySQL can also cope with it. However, a time zone error occurs! The error is as follows:

Hang has recently been used to export schema-level data and has to stop the current export job. If you have similar problems, please continue to read it.1. Problem DescriptionThe database is hang when the entire schema is exported, as shown

Oracle error message: SQL> startup > ORA-10997: another startup/shutdown operation of this instance inprogress > ORA-09968: unable to lock file > Linux-x86_64 Error: 37: No locks available > Additional information: 64 Message file error message: (192

SQL Tuing Advisor (STA) is part of the automation Tuning Optimizer. In the previous article, I used SQL tuning advisor (STA) to automatically optimize SQL statements to describe the background of SQL Tuing Advisor (STA) and provide examples. This

InnoDB fully supports ACID transactions, row lock design, MVCC, consistent non-locked reads, and foreign key-> transaction security, and is suitable for OLTP applications (online transaction processing ).Mytrix ., inc. store more than 1 TB of data

To save the trouble in the future, we can modify the mysql garbled characters in the configuration file under RHEL6.3. My mysql configuration file is/etc/my. cnf 1. First find [mysqld] in the configuration file and add the following