Database Administrator

(Linux parameters) Open the/etc/my. cnf file and modify the following settings. If not, add it manually. When adjusting the settings, please do your best, which depends on the configuration of your server, especially the memory size. The following

The MySQL database was installed on the Linux system a few days ago, and the following error message is displayed when you press the MySQL command: Can't connect to local MySQL server through socket '/var/lib/mysql. sock' The following error

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

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

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,

When backing up a logical database, you may want to add a date variable to the dmp file to differentiate backup files of different dates and avoid accidental overwriting. Referring to eagle's book "sequential Oracle", we have tested some scripts as

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

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-----------------------------------

At the end of this article, I found a fatal problem with ZRM for MySQL. As far as I understand and test it, it overwrites data recovery, for example, assume that a database server has two databases test1 and test2. You have backed up these two

The relevant Oracle Database Sequence information is as follows: Create Sequence syntax Create sequence . _ sIncrement by 1Start with 1Max value 99999999999999999999Minvalue 1Nocycle; Where:Incerment: value added each timeStart: Sequence start

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

Oracle is successfully installed on Redhat 5. The archive mode is not enabled during database creation. SQL> select name, open_mode, log_mode from v $ database; NAME OPEN_MODE LOG_MODE-----------------------------------------SZPDCORA READ WRITE

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 [

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 $

I. Using a MySQL database: 1. view the database structure: View the databases on the current server: SHOWDATABASES statement: Used to list the databases contained in the current MySQL server. After initialization, the MySQL server creates three

When I clone a database, the following error occurs at the source option: Solution: run $ Oracle_HOME/root again. sh to solve the problem. because the root is executed during database installation. sh. It is suspected that the re-execution of root

1. Install redis -------------------------------------------------------------------------------- Home: http://redis.io/: Http://download.redis.io/download the latest source package (current latest stable version 2.6.16)# Wget