Database Administrator

The 21st century is the century of information, and the competition of comprehensive national strength is, to a large extent, the competition of information utilization. In recent years, with the proposal and implementation of the "digital earth"

1. First, decompress the mysql-noinstall-5.2.3-falcon-alpha-win32.zip package in the E drive and change it to Mysql, which is placed in the root directory of the E drive. 2. Create a new "my. ini" file in notepad and enter [WinMySQLAdmin]Servers =

To understand the Oracle architecture, you must first understand two basic concepts: databases and instances. I. Databases A database is a collection of data. Whether the database adopts a relational structure or an object-oriented structure, the

It is often used in the NT environment to convert a MySQL database to an SQL Server database or to a MySQL database. After using MySQL ODBC, you can use the SQL Server 7 management tool or the MySQL management tool. You can also use other management

Some work needs to be done after installing msyql using the mysql binary installation package1. Set the password/usr/local/mysql/bin/mysqladmin-uroot-p password newpassword2. Copy the startup script/usr/local/mysqlsupport-files/mysql. server

After a whole day, finally solved the problem of jdbc (mysql-connector-java-5.0.30) and mysq communication Chinese garbled! My system is linux (Ubuntu ). Use hibernate to connect to mysql in java (Myeclipse environment. There is no problem in

The following method can be used to solve the garbled problem:1. Set phpMyAdminLanguage: Chinese simplified (zh-utf-8)MySQL Character Set: UTF-8 Unicode (utf8)MySQL connection verification gbk_chinese_ci2. When creating a databaseSet it to

1. Download the MySQL Installation File The following two files are required to install MySQL: [Root @ test1 local] # rpm-ivh MySQL-server-5.0.26-0.i386.rpm is: unzip Hat Enterprise Linux 3 RPM (x86) downloads, find the Server and Client programs

In actual Oracle applications, many people may encounter such problems. For performance or other considerations, you need to change the tablespace of a table or all tables of a user. The common practice is to first Delete the table and then

I. Summary ① MySQL features Efficient and stable, open source code, multi-user support, multithreading, openness, extensive application support, transaction processing, big database processing, high flexibility, security permission and password

When using exp to export data in Linux: Connect to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-ProductionWith the Partitioning, OLAP and Data Mining optionsThe ZHS16CGB231280 Character Set and AL16UTF16 NCHAR character set have been

Oracle SQL Developer was often used for simple database operations on Windows PC. This is a JAVA application, and it should obviously be able to run on the newly installed Ubuntu 8.04. It was only installed today that it still takes some effort to

The backup script should be redirected to the Log and saved so as to find useful information in case of an error. Optimization related to RMAN backup To back up data, follow these steps: 1. read data from the disk 2. process data blocks in memory 3.

Consistent reads are generated when SQL statements are executed. What is logical read? The process in which the cpu reads these blocks in the memory is called the consistent get. The IO generated during the reading process is the logical IO. cpu

Background description:Create a catalog database in the rman environment. Problem:The following error message is displayed when you register a catalog database on the target machine: RMAN> register database; PL/SQL package RMAN. DBMS_RCVCAT version 1

Not long ago, because the developer truncate an important table, he found us and made an exception recovery to restore the table.The following is an experiment I did on the vm afterwards. It is completely replicated. Of course, you can also set the

Script file:Backup. shRq = 'date' + % Y % m % d % H % m''Su-Oracle-c "exp zjhk/zjhk_123 owner = zjhk file =/home/oracle/zjhk _ $ rq. dmp" Cron is a linux scheduled execution tool that can run jobs without human intervention. Since Cron is a built-in

MySQL 5.6 brings us the memcached fof innodb api. The main advantage is that we can read and write the MEMCACHED plug-in through the most familiar SQL statements. I will not introduce installation and configuration. If necessary, visit the official

In the execution of related SQL statements, the process in mysql is prone to some words similar to file temp, which tells us that our host SQL adopts file Sorting and other operations, this may greatly affect the efficiency of the result set to be

I recently started to study MySQL and MongoDB and found that there is not much information in this area. In particular, there are too few articles on ideas. Some articles on comparative testing are basically blind tests. The testing methods are