Database Administrator

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

Installing Oracle in linux is usually a headache, If we only want to deploy CMS, there is no need to have a detailed understanding of Oracle parameters. Is there a way to simplify the installation process? The following is an sh script executed in

Start-> All Programs-> Oracle Business Intelligence-> Welcome to Oracle bi ee, go to the obiee Welcome page, click Oracle BI Interactive Dashboards can enter the Dashboards logon page. When you click the Oracle BI Interactive Dashboards link, the

Oracle 10g In EM Use Web To manage databases and related services. However EM Based on the prompts from colleagues and the actual experience of the author, I have summarized the relevant questions and hope to help related fans:    ( 1 ) After the

When using MySQL C APIs in Linux, You need to introduce relevant libraries and include the header file mysql. h. MySQL provides a mysql_config script that can be used to obtain the parameters during compilation. For example, execute mysql_config --

1. Name, size, used size, unused size, used percentage, unused percentage Select tablespace_name, sum (totalM), sum (usedM), sum (remainedM ),Sum (usedM)/sum (totalM) * 100, sum (remainedM)/sum (totalM) * 100From(Select B. file_id, B.

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

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

The latest MySQL version 5.5.11 requires cmake compilation and installation. It is estimated that this method will be used in later versions. Some installation methods are found on the internet and some are incorrect, record the installation steps

// Problem:CI MSISDN CNT18802 1300906019518830 13009060195 118837 13009060195 218829 13009063333 518830 13009063333 718847 13009063333 4// Result:CI MSISDN CNT18802 1300906019518830 13009063333 7// This problem is to query the cnt of the same msisdn

1. Correct Use of Indexes In a massive data table, each table has one or more indexes to ensure efficient query. In the ETL process, indexes must follow the following principles: (1) When the inserted data is more than 10% records in the data table,

// A table has an ID field, which is a primary key and increases progressively. Now you need an SQL statement to check the IDs that the table does not have.// For example, the ID record is as follows:ID124579// We need to check the values 3, 6, and 8

--- Oracle debugging:Set serveroutput on;Sho errorsSet autotrace on;Select text from user_source where name = 'SP _ LZW_ZJ201101300004 ';--- The number of linux instances that are periodically retrieved through the process:#! /Bin/sh# ZJ201101300004_

The where comparison conditions are as follows: Equal to: =, , >=, <> >, >=. =: Equal ! =, <>, ^ =: Not equal Including: in, not in exists, not exists Range: between... and, not between... and Matching Test: like, not like Null test: is null, is

When the client initiates a query to the server, a connection is established with the server. MySQL provides the maximum number of connections. Therefore, each time a connection is established successfully, when the server assigns a processing

Symptom: the server operating system is solaris 10, when the client is logged on to Oracle repeatedly several times after the ora-12516 error will be reported.Cause: this error occurs because the current number of sessions in the database is not

First, make sure that you have successfully installed HIVE and MYSQL Add the following to the hive-site.xml to specify the METASTORE address and Connection Method javax. jdo. option. ConnectionURL jdbc: mysql: // 10.20.151.10: 3306/hive?

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

Ubuntu Edit file/etc/crontab Sudo vi/etc/crontab The cron service not only reads all files in/var/spool/cron every minute, but also reads/etc/crontab once. Therefore, we can use the cron service to configure this file. Crontab configuration is

I. Bug issue performance The CPU usage is 100%. vmstat displays a large number of pending processes and context switches. The sqlplus and lsnrctl commands are invalid. The data is basically hang. Nothing can be used. This bug exists with Oracle 10.2.