Database Administrator

Check whether the system is started with pfile or spfile.Select isspecified, count (*) from v $ spparameter group by isspecified;If true exists in isspecified, the specified configuration is performed with spfile.If all values are false, pfile is

I have been in the company for a while and am currently responsible for the database design and development of the project. A few days ago, I encountered a problem where MySQL could not be installed on red-flag Linux. When installing MySQL5.1 using

1. mysql remote connection is slow or cannot be connected at all 2. log on to the mysql console locally and show processlist. Many processes are displayed, similar | 145 | unauthenticated user | 61.129.57.158: 1672 | NULL | Connect | NULL | login |

In Linux, MySQL database errors are caused by power failure or abnormal shutdown. MySQL provides multiple data Detection and Recovery Tools for different data table types. These tools are: Myisamchk Isamchk Here, myisamchk applies to MYISAM data

This article describes how to install mysql without apt in Ubuntu and enable Automatic startup. 1. Install mysql 1. Download and decompressRun http://dev.mysql.com/downloads/mysql/5.0.html#downloadsto download a mysql. I downloaded the Linux (x86) 59

Run the following command to view the table structure in MySQL: Desc table name;Show columns from table name;Describe table name;Show create table name; Use information_schemaSelect * from columns where table_name = 'table name '; By the way:Show

When Oracle is installed in Linux today, the following error occurs when the xhost service is started: _ X11TransSocketINETConnect () can't get address for localhost: 6001: Name >>or service not known Error: Can't open display: localhost: 1.0

Xmanager secureCRT Environment: Install the Virtual Machine vmware in xp and the host-only virtual Linux system. The ip address of xp is 192.168.0.1, and the virtual machine Linux is 192.168.0.88. Install xmanager and secureCRT in xp. By default,

As a corporate network manager, I know the important role of databases in enterprise operations. In the market environment where enterprise informatization is becoming more and more in-depth, enterprises have extremely strict requirements on

Let's first look at the Python connection MySQL code: #! /Usr/bin/env python#-*-Coding: UTF-8-*-# This statement tells python to use UTF-8 Encoding#===================================================== =======================================

I. System Requirements1. At least 1 GB physical memory; check command: # grep MemTotal/proc/meminfo2. Set the swap space. Check the command: # grep SwapTotal/proc/meminfoSwap space size recommended for actual memory-----------------------------------

MySQL 5.6 GA is released, which is undoubtedly the best version of MySQL. If you do not know the new features and improvements of MySQL 5.6, you can learn from here. The main purpose of my article is to test the performance. I use Sysbench workloads

I wrote MySQL 5.1 master-slave configuration a long time ago. Now MySQL has released 5.6.10 and has made many optimizations in the master-slave replication function, especially the introduction of GTID (Global Transaction ID, it is worth writing

For masters who often work under SQL * Plus, they always query the help commands of SQL * Plus from time to time. It's too much to remember. The help Command is provided in SQL * Plus to help describe the usage of all commands. Hey, you no longer

Rman is a problem for beginners, but it is also true for me. So here I will summarize the problems I encountered during the use of rman and provide a solution. I hope to give some valuable experience to those dishes that are the same as me.  1. The

Problem description: Oracle error 1691 is reported when data is imported through imp today. ORA-01691: Lob segment MID. SYS_LOB0000032765C00002 $ unable to scale through 1024 (in tablespace MID) Cause of the problem: I searched for it on the

This is the source code package installation. Installation environment: CentOS 6.3 64-bit 1. Install the dependency package first (otherwise, an error will be reported during configuration !) Yum-y install ncurses * libtermcap * Create a mysql user [

In this case, you have previously copied and restored all files under/u01/app/Oracle. to delete an existing database, it is found that the delete database option in dbca is gray. But there is actually a database, so I suspect that the configuration

The MySQL master-slave replication structure is based on the mysql bin-log. The slave database receives the bin-log incremental information of the master database by opening the IO process and saves it to the local relay log, then, the incremental

First of all, you need to pay attention to the following issues before installation: 1. In the/etc/hosts file, the hostname of the local machine must correspond to lo (if you have changed the hostname, You need to modify the file) 2. The $