Database Administrator

Due to work relations, you need to debug the postgreSQL source code. Just a colleague wrote such a document and posted it for sharing. To debug ipvs in Linux, perform the following steps:1. Install the Linux operating systemInstall gdb, Emacs, or

After mysql is installed, the default character set is latin1. Installing mysql in linux is not like installing mysql on windows. You can select a character set (even if the default character set is used at the time, you can modify my. but it is not

There is a stored procedure, which already has four dblinks, but due to business needs, a few more needs to be added. When it is added to the fifth, the system suddenly throws an error: ora-02020 too relational database links in use. Consulting

1. Install CentOS 5 and disable selinux (you can enable selinux after installing Oracle)System-> Management-> Security Level and firewall-> Selinux-> disable 2. Check the installed software: rpm-qa | grep xxxxxBinutilsCompat-libstdc

When analyzing SQL Performance, you often need to determine the SQL statements with high resource consumption, which are summarized as follows: 1. View suspicious SQL statementsSelect substr (to_char (s. pct, '99. 00'), 2) | '%' load, S.exe cutions

Environment: Root@www.bkjia.com ~ # Lsb_release- LSB Version: core-3.1-ia32: core-3.1-noarch: graphics-3.1-ia32: graphics-3.1-noarchDistributor ID: CentOSDescription: CentOS release 5.5 (Final)Release: 5.5Codename: Final 1. Download and install

Ora-28056The following error occurs during database connection: ERROR:ORA-28056: failed to write audit records to Windows Event Logs Solution: You have cleared the records under the application in the Event Viewer (run-eventvwr) (you can export

Improving Oracle performance-how to index I. Question proposalAt the early stage of application system development, due to the relatively small amount of data in the development database, the performance of SQL statement writing is not good for

Oracle login uard is so disgusting that it took so long ~ Next I will introduce the simplest installation method ~ 1. First, install two oracle databases with the same directory (you can select different directories). Because I use a VM, it is

0. database parameter attributesCol PROPERTY_NAME format a25Col PROPERTY_VALUE format a30Col DESCRIPTION format a100Select * from database_properties; Select * from v $ version; 1. Find the SID of the current session, SERIAL #SELECT Sid, Serial #

Article 1: First, you must have a table! Create table example ( ID Number (4) not null primary key, Name varchar (25 ), Phone varchar (10 ), Address varchar (50) );   Then, you need a custom sequence Create sequence emp_sequence Increment by 1 --

Operating System: RHEL 1, 5.4 Download MySQL 5.1.54: Wget http://mysql.ntu.edu.tw/Downloads/MySQL-5.1/mysql-5.1.54.tar.gz-c Download SphinxSE 1.10-beta: Wget http://sphinxsearch.com/downloads/sphinx-1.10-beta.tar.gz-c Detailed operation steps: Cd

Replication: Copies executed statements or datasets from the master server to one or more slave servers to synchronize databases between multiple database servers. MySQL's built-in replication capability is the foundation for building large,

Recently, I was working on an Oracle database system under RHEL 5 to store the recording data of the cluster. The database driver is odbc, here is a simple record of how odbc is installed and configured. 1. Install ODBC Download

MySQL uses the memory pool structure. It is quite simple to understand this structure, but it is hard to understand the allocation process in my_alloc.c./*Data structures for mysys/my_alloc.c (root memory allocator)*/# Ifndef _ my_alloc_h# Define _

Sqlplus system/system @ orcl -- connect SQL> ed a -- create SQL textSQL> get a -- load a. SQL into the cacheSQL>/ Create temporary tablespace sa_temp -- temporary tablespaceTempfile 'e: \ dbf \ sa_temp.dbf'Size 10 mAutoextend on; Create tablespace

Preface: This is my first time in contact with Linux, CentOS, and MySQL. After five days, I finally succeeded in the MySQL-Cluster architecture based on CentOS 5.0. I will share my experiences with you. If you find any errors and negligence, Please

Recently, a DBA asked a question: why is Rows_examined: 0 displayed in many slow query logs? It should be noted that such slow query statements are similar to select count (*) from (...) T; Before explaining this problem, we should first point out

The parameter file of Oracle RAC is different from the parameter file of a single instance. Therefore, when modifying the parameter file, pay attention to it. First, set the archive path: SQL> alter system set log_archive_dest =

The shared pool is mainly composed of data_dictionary that saves the data dictionary and the library cache that saves the SQL and PL/SQL code and execution plan. It also includes several other buffers for different system features and technologies,