Database Administrator

This article allows you to use eight simple sentences to teach you how to deal with the MySQL database.1. Connect to MYSQLFormat:Mysql-h host address-U User Name-P User Password1. Example 1: connect to MySQL on the local machine:First, open the DOS

Note: To install the linux component, select the everything swap partition to be greater than 4 GB. Otherwise, the installation may be inexplicable.When the installation prompts that two. sh scripts are run. Be sure to open a single window and run

When interviewing MySQL DBA or those who intend to optimize MySQL performance, my favorite question is: what adjustments should I make after the MySQL server is installed according to the default settings?I was surprised how many people could not

++ Creates user hillary with the password window. The default tablespace is users and the temporary tablespace is temp.Create user hillary identified by window default tablespace users temporary tablespace temp;++ Delete a userDrop user user_name

About Oracle 10 Gb performance, the most talked about is the new automatic workload repository (AWR) features and proactive performance monitoring through automatic database Diagnostic Monitoring (ADDM. They are widely reported as an alternative to

In viewing Mysql file operations, it operates on files on different operating systems, in addition to using standard C Runtime library functions, including open, close, seek, etc, the file and directory operation functions under Win32 use CreatFile,

The database part in the deployment system is mysql, which is used in linux.In mysql, there is no password for Local root Login by default.Execute a grant statement as follows:Grant all on *. * to 'livesky 'IDENTIFIED by '20140901 ';Explanation:

1. Oracle Database NameThe database name is the "ID number" of the database, used to identify a database. DB_NAME is used in the parameter file.The database name must be used to install the database, create a new database, create a database control

Oracle Database logs are called redo logs. All data changes are recorded in redo logs, which can be used to repair damaged databases. Large Databases use logs. The benefits of this design are the same.Redo logs are grouped. A database must have at

RedHat Linux 9.0 is a very good Linux release version with good Chinese support and rich application software, so that many Linux users, including the author, can't help it. However, due to the high GCC version used by Redhat9.0, some compatibility

I want to develop a database on the Ubuntu7.10 platform. I saw on the Ubuntu Forum that mysql installation was quite simple, so I chose mysql. I did not expect that I had spent two days on this simple problem. It seems that the simplicity of things

Initialize Oracle Data to mysql. Use the oracle to mysl tool to map oracle data types to mysql Data Types and modify them accordingly so that mysql can accommodate the length of oracle fields, this document executes the initial data and does not

Today, we found that the impdp command has a special purpose. You can migrate one user of the database to the user of the database on another machine. If the target user does not exist, you can create the user accordingly. The command format is as

When the monitoring software cacti is installed, mysql cannot create a database Mysql> create database cacti; ERROR 1044 (42000): Access denied for user ''@ 'localhost' to database 'cacti' The root user's create_priv permission problem is solved

Hello everyone! Today, we have compiled examples of how to create 10g 11g all partition tables. Here we will share with you: Partitions supported by 1.1 9i, 10g, 11gR1, and 11gR2 Interval list hash Interval 11gR1 9iR2 9iR2   List 11gR1 11gR1 11gR1  

Solution to ORA-12520 errors The ORA-12520 listener cannot find the available handler for the requested server type: 1) The database is a dedicated server, but the connection mode is set to shared in the tnsname. ora configuration. In this case,

Oracle index file migration steps: Preparations:1) Back up GBOS User table indexes: Use plsqlDevelop to export all GBOS User table indexes for backup.  1. view the data files in the index tablespaceSelect file_id, file_name, tablespace_name, bytes/10

1. In the system environment, CentOS 6.3, master a ip: 192.168.1.28, and master B ip: 192.168.1.29. 2. Install cmake and mysql 1. Install cmake # Tar xf cmake-2.8.8.tar.gz # Cd cmake-2.8.8 #./Bootstrap # Gmake & gmake install 2. Install mysql #

The V $ view contains information about the data structure maintained by the kernel in the memory, which can be accessed through a DBA account with the SYS permission. The following is a summary of the recovery-related views: Articles: Oracle

The default number of connections in Oracle XE seems to be 40. If the process exceeds this number, the request for a connection again will be rejected. 1. Log On with the system user: Sqlplus system/password @ xe 2. Run the following command: