Database Administrator

MySQL optimization summary on Linux Currently, most of the MySQL running environments are on Linux. Here we provide some general and simple policies on how to optimize MySQL on the Linux operating system. These methods help improve MySQL performance.

MySQL Character Set inheritance relationship Verification (1) When a database is created, a character set that is not specified will inherit the server character set.Server characterset: utf8Db characterset: latin1 Mysql> show global variables like '

Solutions for moving Oracle tablespace data files Solution 1: Move regular tablespace (non-system tablespace) data files /************** When the disk space of a database server is insufficient, move the regular tablespace data file ************* ***

Oracle snapshot Management ---- Manually create an Oracle SnapshotBEGINDBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT ();END;/ --- Delete a snapshotFor more information about snapshots, see

CentOS 5.3 installation and configuration Oracle 10g Manual start and self-start service The following is a text description of the installation process on Oracle 10g, CentOS 5.3 1. Download and decompress 10201_database_linux32.zip to the database

Use of association, use of association Why is association unable to associate information, only Id: Is there a problem with writing like this? How to Use File Association Manager You can specify to always

Hard Parse & Soft Parse, hardparse Each DDL execution requires hard parsing. SQL parsing process Oracle will take the following steps to process this SQL statement: 1. syntax check: check whether the spelling of this SQL statement is correct. 2.

Real-time data warehouse and data warehouseShare an example of a real-time data warehouse.The customer is a municipal Tobacco Company and needs to analyze the cigarette sales data in real time. About 0.1 million pieces of data are collected every

In mysql5.6.19, The subquery cannot use the index. mysql5.6.19 Index The table structure is simple. Create table 'oplogs '('Id' int (10) unsigned not null AUTO_INCREMENT,'Kind' varchar (45) not null default '','Op' varchar (100) not null,'User'

Oracle 11g sets the user password to be case sensitive, oracle11g The 11g password is case sensitive by setting a parameter. The following is an experiment: C: \ Documents and Settings \ guogang> sqlplus gg_test/gg_test@10.10.15.25 _ ggSQL * Plus:

[Translated from mos] maximum data capacity limit of oracle Database and maximum data capacity limit of tablespace, mosoracleMaximum data capacity limit for oracle databases and maximum data capacity limit for tablespacesReference Original:What Is

Stage Summary-how does shell access mysql and shellmysql? For the previous project, a script is required to manage mysql, I originally wrote one in C, because it was confusing with shell at the time. Later I found that C is not convenient to shell,

Crmsql queries table information and crmsql Information -- Query the object corresponding to the specified lookup fieldSelect name, OriginalLocalizedName from MetadataSchema. EntityWhere objecttypecode in (Select objecttypecode from dbo.

Query the size of a table with a lob field in the Oracle database.Note: Because the lob field has an independent lob segment for storage, for a table with a lob field, you cannot only query dba_segments.The following scripts are from:How to Compute

JDBC and mysqljdbc In the previous article "Let's talk about Java EE", we will explain what norms are and what their functions are. In this article, we will elaborate on JDBC.JDBC JDBC (Java Database Connection) is also a specification in Java EE.

MySQL range partition (2), mysqlrange Partition MySQL range partitions are used most often. For details, see section 1. Example: Here is my personal learning Summary-> details --> if you have any questions, please come and talk about it.

In-depth analysis of LRU for physical reading (least recently used), lru resolution Reprinted please indicate the source: Http://blog.csdn.net/guoyjoe/article/details/38264883 A set of LRU linked lists include the LRU main chain, LRU auxiliary

[Translated from mos] using the ggserr. log method cyclically in Oracle GoldenGate, oraclegoldengate Use ggserr. log cyclically in OGG: Reference Original:OGG How Do I Recycle The "ggserr. log" File? (Docid 967932.1) Applicable:Oracle

Common oracle functions (1): oracle Functions 1. Return the decimal number corresponding to the specified character Select ascii ('A') A, ascii ('Z') A, ascii ('12') a dozen, ascii ('') kg from dual; 2. returns the character corresponding to the

Batch Data insertion in oracle and oracle Once a function was developed, tens of thousands of pieces of data provided by others need to be imported, There are about 80 thousand pieces of data in a *. SQL file. Insert into testtable (id, name) values