Database Administrator

Recently, due to project requirements, mysql Data Synchronization has been set on Linux servers. Fortunately, there are a lot of network resources, and google has all of them, but the actual operation is troublesome and many problems are encountered,

The new server gave me a try. I simply recorded the installation and upgrade process and learned from the experts. When installing Linux AS 4.7, you can choose LVM to easily manage the space, increase or reduce the size of the file system, and

SQLDBA> SELECT * from v $ LOGFILE;GROUP # STATUS MEMBER-----------------------------------------------1 STALE/Oracle/7.3.4/dbs/log1P734. dbf2/oracle/7.3.4/dbs/log2P734. dbf3/oracle/7.3.4/dbs/log3P734. dbf Solution summary: 1. Do not forcibly close

The Listener. ora and tnsnames. ora files are often difficult to use due to format issues. I have configured and kept a backup, and I will copy it and modify it later! Hey ~~~ Because Linux is usually used in many cases, sometimes you may encounter

The output formatting of the MySQL client is amazing. I didn't notice it before. I 'd like to share it here:$ Mysql-uroot-e "show global status like 'uptime '"+ ----- + --- +| Variable_name | Value |+ ----- + --- +| Uptime | 2174838 |+ ----- + --- +

When I was writing SQL statements recently, I encountered two problems: 1) ORA-01795: maximum number of expressions in a list is 1000 Cause: the following SQL statement is written: SELECT PALLET_ID, BOX_ID, STATUS FROM SD_CURRENT_BOX WHERE

In the development and testing environments of Oracle databases, the log mode and automatic archiving mode of databases are generally not set, which is conducive to the adjustment of system applications, the generation of a large number of archive

1.download and install mysql-5.5.30.tar.gzand cmake.2.8.11.2.tar.gz (1) install cmake first (after mysql5.5 is compiled through cmake) [Root @ rhel5 local] # tar-zxv-f cmake-2.8.11.2.tar.gz[Root @ rhel5 local] # cd cmake-2.8.11.2[Root @ rhel5 cmake-2

I have a lot of Oracle databases that use SUSE linux as the basic platform. When installing oracle, former colleagues directly use the loose package (oraRun *. rpm ). The lazy package is naturally quite lazy, saving a lot of effort when installing

-- ======================================-- Configure sqlnet. ora to restrict IP Access to Oracle-- ====================================== Similar to the firewall function, Oracle limits and allows a specific IP address or host name to access the

Environment: you can download the CentOS 5.9 Enterprise Edition official websiteVirtual Machine virtualBoxOracle 11g R2 posts:Http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-linx8664soft-100572.html1. Briefly describe

Sometimes it is a big mistake to study seriously. As long as you learn to treat one thing with impetuousness, this will treat you the same way.Let's take a look at my miserable 1 hour.The problem is that I create a table:SQL> create table

There are three common ways to install MySQL: Rpm package format Common binary format Source code compilation 1. rpm package format (1) provided by the operating system publisher (2) officially provided by MySQL (version updates fix more common

Full-link initialization standardization process: 1) Verify synchronization link connectivity Run the info extract/pump/replicat and detail commands to check whether the trail files and checkpoints of each process in the synchronization link are

Because the project needs to test the environment, the original database is Oracle 10.2.0.4 64-bit, and the environment needs to be migrated to a 32-bit machine. There are many articles on the Internet that upgrade 32-bit to 64-bit, in fact, the

Today, when the view backs up two large tables in expdp mode to a mounted nfs disk, it encounters a ORA-27054: NFS file system where the file is created or resides is not mounted with correct options. I checked it online and found three solutions:

Oracle provides powerful audit functions to audit operations on a variety of databases at the user level, system level, standard audit, fine-grained audit, and other methods. However, many small and medium databases need to record user login and

Abstract: This article summarizes some common MySQL problems, solutions, and suitable use cases and optimization solutions. Directory: Storage engine Selection: MyISAM vs InnoDBUse and OptimizationDatabase OptimizationSQL OptimizationApplication

1 problem: As mentioned above, a materialized view for timed refresh is created in my project. This materialized view is based on the query of a table with two remote machines connected to the left. For the previous article "materialized views of

I. Preparations before installation (1) Before installation, see to learn about the installation and configuration of the Postgresql database. (2) create a bandwidthd-pgsql account to log on to the Postgresql database Root @ Ubuntu :~ #