Database Administrator

Problem description: mysqlcc is installed in Federo8 but garbled characters appear after the database is opened. However, as far as I know, mysqlcc supports GBK Simplified Chinese. This problem does not occur in windows. At first, I suspected

When our Oracle Server is a Linux/Unix system, we want to use the EM tool to start oracle to learn about some system information from windows or other clients. You can use the following method: Open a window on the server and enter the following

I have been fully transferred to Linux. In the past, some services and databases under windows had to be transferred step by step. Apache, tomcat, jboss, and so on are easy to handle, that is, mysql has been tossing for 2 or 3 days. It is mainly

I wrote a script to check the domain name and run it on my Ubuntu 8.04 Desktop machine. An error occurred while importing data to the Mysql database: Mysql> load data infile "/home/cron/ddd.txt" into table test;ERROR 29 (HY000): File '/home/cron/ddd.

Sun released MySQL database software version 5.1 last week. Later, they said there were many bugs to fix, including new features. According to MySQL founder Michael Wideniu, the bug has been found to be very serious and may cause crash or even data

Abstract: This section briefly introduces how to optimize the database performance at the server level and the hardware problems involved in improving the database performance. Selecting a system as fast as possible is easy to think of using RAID

Install MySQL on Fedora 10 Create group/user:$/Usr/sbin/groupadd mysql$/Usr/sbin/useradd-c "MySQL Software Owner"-g mysql$ Passwd mysql Install mysql$ Su$ Yum install mysql-devel mysql-server mysql-administrator Start the server$/Etc/init.

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

MySQL replication is established to achieve data redundancy based on business needs. MySQL 5.6.10 provides a more convenient GTID-based replication function. MySQL can automatically identify the last synchronization point through GTID, which greatly

For masters who often work under SQL * Plus, they always query the help commands of SQL * Plus from time to time. It's too much to remember. The help Command is provided in SQL * Plus to help describe the usage of all commands. Hey, you no longer

The MySQL master-slave structure is based on mysql incremental logs, which is different from the master-slave replication structure. In the master-master replication structure, any changes to the data inventory on one of the two servers will be

Original database version: Oracle 10.2.0.4.0 Target database version: Oracle 11.2.0.1.0 Use expdp to export data from the original database: Expdp system/xxxxxx schemas = test1201 directory = easbak dumpfile = test1201.dmp logfile =

Obtain all unmatched query results using the Oracle Regular Expression -- Not a numberSelect * from dual whereNot REGEXP_LIKE ('1 is not a number 1', '^ [0-9] + \. {0, 1} [0-9] * $ ') -- Is a numberSelect * from dual whereREGEXP_LIKE ('1. 1', '^ [0

In a CBO optimizer-based environment, the generation of SQL Execution plans depends on the authenticity and completeness of statistical information. Such as column discretization, column histogram, index availability, clustering factor on the index.

Oracle DbLink Test Source database: Computer Name: beijing Database Name: orcl Target database: Computer Name: suzhou Database Name: ocp 0. Create a test table for the target database SQL> conn scott/password Connected. SQL> show user; The USER is

I. Initialization1. Create an initialization file[Oracle @ sigleNode dbs] $ more initdw. ora | grep-v '#' | grep-v '^ $'> initprod. oraEdit the initialization file and set parameters. Add the following settings based on the original parameter

I. Concepts Hibernate and Apache OJB: "one-stop" ORM Ibatis: A "semi-automated" ORM implementation. That is to say, ibatis will not automatically generate SQL Execution for programmers at runtime. The specific SQL needs to be compiled by the

In SQL query statements, many people often doubt the query efficiency of in and exists. Many people think that the query speed of exists is faster than that of in. in fact, this statement is not absolute, both exists and in have their appropriate

Share a MySQL function written yesterday. The purpose is to obtain the week number of the month. DELIMITER $ USE't _ girl $ Drop function if exists 'weekofmonth' $ Create definer = 'root' @ 'localhost' FUNCTION 'weekofmonth '(F_datetime DATETIME)

MySQL Replication Format 1: Replication modes supported by MySQL: Statement-based replication (SBR) Row-based replication (RBR) Mixed-based replication (MBR) 2: simple definition of three modes: Statement-based replication: The slave database (slave)