Database Administrator

I set up an nginx and mysql platform. I just created it and it was inconvenient for mysql not to use phpmyadmin. I took the previous source code and thought it would be okay to modify the database user and password. The phpMyAdmin page displays:

Logmnr has made many improvements after Oracle 9i. If you do not need to build a flat text file, you can analyze the log, which means you can analyze the log without modifying the utl_file_dir parameter, the problem of restarting the database caused

I. Prerequisites for installation and configuration1. Install the Oracleasm support packageDriver: http://www.oracle.com/technology/software/tech/linux/asmlib/rhel5.htmlTo create an asm database, you first need the ASMLib driver package, which can

A database trigger is a storage subroutine associated with a data table, view, or event in a database. For example, we can enable the Oracle database to automatically activate a trigger before or after an INSERT, UPDATE, or DELETE expression affects

System: Ubuntu 10.10 Mysql source file: mysql-5.5.8.tar.gz Install required tools: cmake, GNU make, gcc, Perl, libncurses5-dev, bison (optional), chkconfig Note:1. There are several bugs in the official source code from, which were manually modified

A. hardware configuration requirementsThe minimum hardware configuration required for installing Oracle 9i is as follows:Memory: 512 MBSwap space: 1GDisk space: Database software: 3.5G; seed database: 1GTemporary disk space: 400 MB in/tmp1. If swap

1. Obtain the length of a table row record in Oracle under a user This length is the length defined by the table field. How to obtain it: SelectOwner, Table_name, Column_name, Data_type, Data_length, Sum(CaseData_type When 'Date' Then  7

For the basic installation process, refer to some installation instructions on the Internet. To describe the Linux configurations during the installation process, configure the. bash_profile in the Oracle user directory. Post the. bash_profile

Run yum to check whether mysql has been installed on Fedora 13 and you do not want to uninstall it and reinstall it. Typing mysql directly does not respond. For details, refer to here. I don't know how to deal with it. Now let's look back.Step 1: #

Because there is no hardware environment, two mysql databases are compiled and installed in the Linux of the virtual machine, one as the master and the other as the slave, install them in/home/jhw/mysql and/home/jhw/mysql2 respectively. By default,

1. Edit the/etc/my. cnf file and add "default-character-set = utf8" under "[client"2. Edit the/etc/my. cnf file and add "default-character-set = utf8" under "[mysqld"3. Restart the mysql service.# Sudo/etc/init. d/mysqld restart* View the system

The mysqlreport tool is a perl script. To run the script properly, you must install databases such as DBI and DBD-mysql. The current version is 3.5. The following describes the application of the options: -- User USER: user name used to connect to

MySQL's Table xxxx is read only error often occurs on a Linux host. After checking a lot of information on the Internet, I finally found that it is essentially a permission problem. To solve this problem, you must first add the writable permission

I encountered an interesting situation that included InnoDB gap locks when I was troubleshooting deadlocks for a customer. In non-insert write operations WHERE a WHERE clause does not match any rows, I expect that the transaction will not have a

Hash Join Process An example is provided to illustrate SQL _ID gtmmr9gaxqhfr, child number 0-------------------------------------SELECT/* + USE_HASH (d e) */e. ename, d. dname FROM emp e, dept d whereE. deptno = d. deptno Plan hash value: 1123238657

I. Hardware requirements 1. Memory & swap Minimum: 1 GB of RAMRecommended: 2 GB of RAM or more Check memory # grep MemTotal/proc/meminfo # grep SwapTotal/proc/meminfo 2. Hard Disk Since CentOS is installed almost 4 ~ 5 GB, plus Oracle and so on, so

In fact, it is very simple to create an Oracle password file, but to prevent you from forgetting it, record it. Orapwd file =/u01/app/oracle/product/10.2.0/db_1/dbs/orapworacledb password = oracle entries = 10 [Oracle @ oracle10g dbs] $

Due to Oracle authorization problems, Maven3 does not provide Oracle JDBC driver. To Apply Oracle JDBC driver to Maven projects, you must manually add the driver to the local repository. 1. Obtain the Oracle JDBC Driver 1. Download the appropriate

The binary log of Mysql records the information of all mysql database changes, so it is very important to the database. The role of binary log is summarized as follows: 1. It can be used for restoration of databases based on time points. 2. It can

Oracle's verify_function_11G function only makes the password look difficult to guess through some password rules, but some users' habits make the password complex, but it is not difficult to guess, in this case, you can use the program I wrote to