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

By default, mysql is installed on Ubuntu with the character set latin1. 1. View character set support Show character set; 2. View character set variables Show variables like "character_set % "; 3. Set the default Character Set To solve garbled

Environment: 1. Install CentOS 5.0When installing CentOs5.0, if the server is only running the Oracle database, you must install gnome, development kit, and Legacy development kits when installing CentOs5.0. You can choose not to install other

When MySQL becomes the database of more and more web2 sites, when the site is getting bigger and bigger, the traffic is increasing, and the number of users is increasing, the database is often the first to become the bottleneck of the system, how to

Sun has confirmed that all major vulnerabilities in the latest version of MySQL 5.1 have been fixed and everything is ready. Open-source users looking forward to seeing it available in the coming weeks. zack Urlocker, vice chairman of Sun's database

1. Download the four required rpm installation packages from the mysql website (which must be downloaded from the official website to prevent data modification and expires

Backup and restoration of MySQL database in Linux [Root] #/usr/bin/mysqldump-h127.0.0.1-uusername-ppassword databasename>/opt/share/1/backup. SQL /Usr/bin/mysqldump: The program used for execution; -H: Host Name -U: Database User -P: Database

Generally, we will use the memory of the Oracle instance to 80%-60% of the physical memory of the system (4G memory or above uses more than 80%, 2g memory uses 60%-70%)S = pga + sga_max_size = 80% memory)Db_cache_size = 60% sgaShared_pool_size = sga_

After receiving a new task today, You need to import MySQL database data to the local machine from the remote server. This is really a bit of a duck on the shelf. Because I have almost never touched mysql before, and MySQL is deployed on a Linux

I came to the company to start my computer today. On the login page, my computer reported that a service failed to start. My computer had no new software installed and there was no problem on Saturday. Why did I suddenly report this error? So I went

ORA-12514 and ORA-28547 troubleshooting Oracle 10 Gb is installed on the local machine. The website is dynamically obtained by the company. It is normal to log on to the database with SQL plus. When you open the database with pl/SQL, the error "ORA-1

Linux C Programming inserts Chinese data garbled into MySQL. First read this article titled "Cannot display MySQL Chinese characters and solve sock Link errors in Linux ". After the above changes, you should add this sentence before inserting data

For data replication at the database TABLE level, the most common method is create table as (CTAS. In fact, the copy command under SQL * Plus can do the same job, and it is better, and the performance is also better. What's more, data replication

Install Oracle 11G notes in Ubuntu 12.04. 1. First, update the system to the latest version. Sudo apt-get updateSudo apt-get dist-upgrade 2. Install the dependency packageSudo apt-get install alien binutils build-essential cpp-4.4 debhelper g + +-4.4

Oracle RAC normal restart sequence:Oracle 10g rac:Generally, the 10g RAC (ASM) Switch sequence is as follows:1) Stop Oracle RAC 10g environmentStop the Oracle instance first. When this instance (and related services) is closed, the ASM instance is

The first time I configured mysql in Linux is really tortuous, so I would like to recordStep 1: download and install MySQLTerminal input: sudo apt-get install mysql-server mysql-clientStep 2: confirm the address of the MySQL hostTerminal input:

Version: mysql-5.1 [Root @ localhost mysql-5.1.55] # useradd-M-s/sbin/nologin mysql[Root @ localhost media] # tar zxf mysql-5.1.55.tar.gz-C/usr/src[Root @ localhost media] # cd/usr/src/mysql-5.1.55/ The next step is to compile and install [Root @

Mysqlslap is a mysql testing tool started with mysql 5.1.4.  [Root @ www.bkjia.com ~] # Mysqlslap -- helpMysqlslap Ver 1.0 Distrib 5.5.31, for Linux (x86_64)Copyright (c) 2005,201 3, Oracle and/or its affiliates. All rights reserved. Oracle is a

Always use MySQL 5.0. After a batch of large data tables have been imported recently, the database has become very slow. The reason is that the performance of the InnoDB engine is severely impaired. Then upgrade the database to MariaDB 10.0.2

1. Environment Description OS: Linux RedHat5.5 Oracle version: Oracle RAC 11.2.0.1 2. Problem Description Use exp to export data of multiple users in the database. The statement is exp buffer = 4096000 file = exp. dmp wner = user1, user2 .... The