Database Administrator

The purpose of this article is to show friends how to compile MySQL code. Some people may think that compiling MySQL code on Windows is complicated. If you have any questions about the knowledge mentioned in this article, you can seek help through

Since Oracle said it was about to provide Linux support at half the price, choosing Oracle or Redhat has become a big problem. However, Gartner recommends that users who want to use Oracle services first test system compatibility and decide whether

The installation speed is too fast. A command is completed in two or three minutes.# Installing Oracle with Linux characters# Local hardware configuration:* Hardware:* CPU: ALTHON64-K8-2800 + box* Motherboard: MSI K8T-NEO-V* Hard drive: WDC WD1600BB-

Installation File mysql-gui-tools-5.0r11.tar.gzTo setup mysql-gui-tools:Get root right to do it!Shell> tar zxvf mysql-gui-tools-5.0r11.tar.gzShell> cd mysql-gui-commonShell>./configureShell> makeShell> make installShell> cd

Today, I learned from the official MySQL website that MySQL announced the closure of the Enterprise Server Source code, which is a heavy blow to open source enthusiasts. Although free users generally only use MySQL Community Server (open-source free

There is no theoretical basis as described below, which is purely an experience. MySQL uses version 4.1 or later, and uses the default for whatever character set it is. You do not need to set MySQL. Then an example of using GB2312 and UTF-8 is

MySQL has many different forms, at least four different versions: MySQL standard, MySQL Max, MySQL Pro, and MySQL Classic. In addition to the license, MySQL Standard and MySQL Pro are exactly the same. MySQL Standard is registered in GNU Public

SQL Server cannot restart the Server to find the following error in the error log: Operating system error 1117 (unable to run this request due to an I/O device error .) On file "C: \ Program Files \ Microsoft SQLServer \ MSSQL10.MSSQLSERVER \ MSSQL \

1. First, use a statement to query data segments with a capacity greater than 1 GB. Select segment_name, sum (bytes)/1024/1024 from dba_segments group by segment_name having sum (bytes)/1024/1024> 1000; The following result is displayed: SYS_LOB00

Symptom C: \ Users \ CHEN> sqlplus "/as sysdba" SQL * Plus: Release 11.2.0.1.0 Production on Wed Oct 10 13:31:28 2012 Copyright (c) 1982,201 0, Oracle. All rights reserved. Connected: Oracle Database 11g Enterprise Edition Release

Memcached is a distributed memory object cache system, which is usually used for dynamic Web applications to reduce database load. Memcached is a hashmap based on a storage key pair. When the table is full, it is replaced by the LRU (least recently

1. Read only table description Before Oracle 11g, if we want to set a table to read-only, we can grant some users the select permission. But for the table owner, it is still read/write. In Oracle 11g, we can directly set the table's read and write

Environment: Idle> select * from v $ version;BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-ProdPL/SQL Release 10.2.0.1.0-ProductionCORE 10.2.0.1.0 ProductionTNS for

When writing an Oracle stored procedure, my colleagues modified it based on the previously written process and wanted to change the name. due to negligence, I did not change the name and compiled it. After compilation, I realized it. Then the

Recently, the Oracle 10g RAC migration under the virtual machine, after the migration is completed, the Oracle cluster resource VIP cannot start normally, received the CRS-0233: Resource or relatives are currently involved with another operation

One Oracle instance is configured with multiple listener or multiple ports The content of the listener. ora file is as follows: SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME

Two users, jytest and jytest1, both have dba permissions. In jytest1, a user creates a table named test. Create user jytest identified by "jytest" Default tablespace users temporary tablespace temp;   Grant dba to jytest; Grant resource to

The flexible combination of Linux/Unix Shell and SQL variable transmission greatly improves DBA efficiency, this article provides a few simple examples of passing variables between Linux/Unix shell SQL statements for your reference. Call SQL in

Today, when logging on to Oracle Data encountered a ora-01033: oracle initialization or shutdown in progress this problem, the company server database is 9i, using vm login on the server db and API have restarted the login or error, and then on the

Modify the default MySQL engine to innodb. 1. Stop the mysql Service #/Etc/init. d/mysqld stop 2. Back up my. cnf Cd/etc Cp my. cnf my. cnf_bak 3. modify my. cnf [Mysqld] Later # Vi my. cnf Default-storage-engine = InnoDB 4. Delete ib_logfile0 and