Database Administrator

Linux terminal prompt features are defined by the system environment variable ps1. Run ''echo $ ps1' to view the current settings.The PS1 value is composed of a series of static texts or \ and escape character sequences, such:PS1 = "\ u @ \ H \ w

1. It is best not to write a Commit statement in the Oracle stored procedure. Generally, the calling program automatically Commit data. For example, when calling with NHibernate, NHibernate automatically Commit data. If it is written, an error will

Thinkc wrote, "a user named Klaus Keppler submitted a bug report (Bug # April 17) to MySQL at on November 23, 36187 ), the content is in the just release of the mysql-5.1.24-rc binary version has been unable to find ndb and other commands related to

Platform: Red Hat RHEL5 + VSFTPD + MySQL 1. Install MySQL Mysql-5.1.7-beta-linux-i686-glibc23.tar.gz# Tar zxvf mysql-5.1.7-beta-linux-i686-glibc23.tar.gz# Ln-s mysql-5.1.7-beta-linux-i686-glibc23/usr/local/mysql# Cd/usr/local/mysql#

Installing MySQLdb in Linux still has some problems. If you do not pay attention to it, you may always report an error. Here I will give a brief introduction. First, download the MySQLdb source package, here are:

The following illustration describes how to install PostgreSQL8.3 In Ubuntu. First download postgresql-8.3.3-2-linux.binRoot @ bai-desktop:/home/bai/liuy # lsPostgresql-8.3.3-2-linux.binRoot @ bai-desktop:/home/bai/liuy # chmod u + x postgresql-8.3.3

1] in Linux, how does one create a management user for the mysqld database?After the database is installed, we should create a management account for the mysql database. To set the root user as the administrator, we should run the following command;[

In Oracle, user permissions are divided into two types (this article does not involve dba or role permissions, but only describes the permissions of common users ), system Privilege System permission and User Table Privilege User data Table

When querying the Oracle database server, it is found that the disk space of the database server reaches 98%, and the total data files for analysis cannot reach this level, after query, the usage of the original temporary tablespace reaches 32 GB,

Master: 1. stop httpd 2. mysql> show master status; Write down the file name and position, 3. stop master 4. scp/mysql/bbs/*. * root @ slaveIP:/mysql/bbs Slave: 1. vi/etc/my. cnf Join Server-id = xxx // id must not be the same as the master

On June 19, March 23, Oracle announced the release of its enterprise package for development tool Eclipse to enhance the access and use capabilities of this free development tool for Oracle Integrated middleware components. It is undoubtedly a good

Shell calls the Oracle database Method AddStudent (){LOGPATHFILE =/home/test/user/xxxx/log/bdfWarn. logUID = $1UNAME = $2 UAGE = $3 USEX = $4 Db_user = enter the user name here Db_password = Password Db_server = service name or SID Table =

Database Version: 5.1.24. For databases of Version 4. x, go to the relevant documentation. English document address: http://dev.mysql.com/doc/refman/5.1/en/replication-howto.html 1. When the master server (master) runs normally, create a user

The postgresql installed on the server has not been used for a long time. It is actually used for redmine databases. Considering that mysql may be upgraded frequently, and the connection component of rails is a little difficult to install, it was

OS: Ubuntu Server 12.10 For two servers, the Intranet IP address of A is 192.168.1.111, the Intranet IP address of B is 192.168.1.222, A is the master, and B is the Slave. 1. Configure Mysql of (1) vim/etc/mysql/my. cnf Remove the # comment for

Magento database imports and exports to process foreign keys. After testing, the foreign key can be removed smoothly with this section added. Header/*! 40101 SET @ OLD_CHARACTER_SET_CLIENT = @ CHARACTER_SET_CLIENT */;/*! 40101 SET @

1. delete archivelog all will delete all archived logs without reservation (corresponding records are recorded in the control file) 2. the archived log information is recorded in the control file. the lifetime and total number of retainable logs

MySQL two-way replication (master mode) Environment: A: 192.168.1.1 no data B: 192.168.1.2 no data Add the following content to the [mysqld] field of: Auto-increment = 2 (Growth Value) A will grow like Auto-increment-offset = 1 (initial value) Add

1. Differences between dba, sysdba, and sysoper A dba is a role. A role can contain system permissions, object permissions, and roles. A dba does not contain sysdba and sysoper permissions; Sysdba and sysoper are two types of system permissions. If

Effect of order by sorting on Performance -*********************************** Case Study -*********************************** Alter system flush shared_pool; Set autotrace traceonly explain stat; Select * from t3 where sid> 90; Execution Plan ------