Database Administrator

The mysqldump import solution is simple. You can specify the character set during the export.Mysqldump-u root-p-c -- default-character-set = UTF-8 wapad site> dd. SQLUser Database Table Name Mysql-uroot-p -- default-character-set = utf8 wapad

OS: RedHat Linux Today, we found that the webpage content in em is normal, but the buttons are garbled. The solution is as follows: 1. Modify the font of jdk.[Oracle @ rac2 db_1] $ cd $ ORACLE_HOME/jdk/jre/lib/[Oracle @ rac2 lib] $ mv font.

After several days, the MySQL Character Set Problem was finally solved! I believe many colleagues have encountered the MySQL Character Set Problem and may not solve it easily. Today, I will share my successful experiences with you. Problem

Pfile is used for Oracle8i and can also be used in oracle9i. It exists in text form and can be modified in vi editor. For oracle9i and later versions, oracle can use the server parameter file (spfile, system parameter file) to replace the

Mysqlhotcopy runs as follows: [Root @ local_slavedb ~] # Mysqlhotcopy test/tmp Invalid db. table name 'test. test'. 'mytest' at/usr/bin/mysqlhotcopy line 855. Solution: Suggested fix: A quick and dirty fix is to strip the database prefix from

An error occurred while opening the database startup Oracle in Linux today: ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], [], [] Later, I checked the information and figured out that I changed the

1. EnvironmentUbuntu8.04.1 desktop edition (under WMWare virtual machine) 2. Download Oracle-xe-universal_10.2.0.1-1.0_i386.deb: Http://www.oracle.com/technology/software/products/database/xe/htdocs/102xelinsoft.html After downloading the file, use

If there is a problem with the MySQL DATA table, you can use the -- recover -- quick parameter to fix it: Linux # myisamchk -- recover -- quick tbl_name Linux # isamchk -- recover -- quick tbl_name If the preceding method cannot solve the problem,

A table is one of the most basic objects in an Oracle database. From the ground up, the base object is very important for databases. Whether the design is reasonable is directly related to the database performance. From the Oracle database cainiao

I believe that many system administrators are doing the same job every day-backing up data. Once the system fails and data recovery is required, the system is powerless. It would be nice to set a fixed time every day for the system to automatically

When configuring the SDF server in Linux, sometimes the graphical interface for installing MySQ cannot be installed. You need to download and install the server again: Select software tools: MySQL Control Center MySQLCC is a fully functional,

The role of the control file to the Oralce database is similar to that of the Registry in the Microsoft operating system. The control file is a relatively small binary file that records the structure information of the database. If the Database

Today I also encountered a ORA-00257, although not exactly the same, but also almost, are flash_recovery_area is too small. The following is reproduced from the network. In the actual project encountered a ORA-00257 error (insufficient space error),

This article is from a series of articles by Simon Maynard, co-founder of bugsng. Based on the experience in using Redis over the past few years, the author systematically summarizes the Redis monitoring methods. There are a lot of things available,

Time: Fault: the database server is restarted without reason. When the Slave is started, the relay_log is damaged, and the SQL thread cannot proceed. Cause of failure: OS restart may cause relay_log to fail to be synchronized normally In this

The front-end time is related to a DB project. alanc reports a query. Using indexes is much slower than not using indexes. So I followed up and used explain to look at two different query results. The results of queries without indexes are as

Today, I received a request from my colleague, saying that there was a select query that would take more than a minute to run on Oracle. He hoped to get the results within 5s. The SQL statement is as follows: Select/* + parallel (src, 8)

1. Lock principle Oracle locks are usually a problem at the business layer. locks are designed to ensure Database Consistency in the case of concurrency, so there is no Lock without concurrency. Oracle locks have the following principles: The row

Let's talk about what they have in common: they are essentially an exclusive lock on resources, all caused by concurrency (if the database has only one session, it cannot be locked ). Next we will focus on their differences: First, they have

A colleague said that a PERL script on the production machine always reports a deadlock error, and the concurrency is enabled in the script: the error is as follows: Failure: ORA-12801: error signaled in parallel query server P126, instance