Database Administrator

Ln-s source dist is used to generate a connection (dist) to the source When modifying mysql, remember: 1: Stop the mysql service first (stop all services first and then modify them) Service mysql stop or stop mysql. server stop under mysql

1. Install MySQL under FreeBSD Tar zxf mysql-5.0.41.tar.tar Cd mysql-5.0.41 . /Configure -- prefix =/home/happyiww/mysql-5.1.18-beta -- with-tcp-port = 7788 -- with-unix-socket-path =/tmp/happyiww. mysql. sock -- with_innodb --

This article describes how to use ulogd to save iptables logs to MySQL In debian. There are many benefits to doing so. The main benefit is that the log statistics in the future will be very convenient. Install ulogd and ulogd-mysql First, run the

Oracle databases are heavyweight, and their management is very complicated. Sort out the steps for starting and disabling Oracle databases on the Linux platform. After installing Oracle, you need to create an Oracle System User and add several

The descriptions below have no theoretical basis and are purely personal experiences. MySQL uses version 4.1 or later, and uses the default for whatever character set it is. You do not need to set MySQL. Then an example of using GB2312 and UTF-8

Solve the Problem of freezing mysql-query-browser After I upgrade my system to Ubuntu 8.04, mysql-query-browser will be frozen after I click the database. After searching for a method on the internet, you need to modify a file in the source code.

OS: Oracle-Enterprise-R5-U2-Server-i386Oracle: linux_x86_11gR1_database ERROR:Sqlplus: error while loading shared libraries:/u01/app/oracle/product/11.1.0/db_1/lib/libnnz11.so: cannot restore segment prot after reloc: Permission denied I. Simple

Skip-lockingKey_buffer = 384 MMax_allowed_packet = 3 MRead_buffer_size = 20 MMyisam_sort_buffer_size = 128 MQuery_cache_size = 64 MThread_concurrency = 8Set-variable = back_log = 1024Set-variable = interactive_timeout = 7200Set-variable =

Environment: UbuntuMYSQL 5.0.38JDK 1.6Ecplise 3.2.2Hibernate 3.2Mysql query browser 1.2.5bateDuring java project development, it was found that the Insert data was garbled and no solution was found for searching various cool people. Try the

I have been using the MySQL database software, which is stable and highly efficient. There are several possible causes for serious performance problems: 1. The index is not created; 2. SQL statements are too complex; 3. Configuration Error; 4. The

--- Create a packageCreate or replace package test_pkg isG_public_flag varchar2 (1 );Function test_function (p_param1 varchar2,P_param2 varchar2) return varchar2;Function hello_function (p_param3 varchar2) return varchar2;Procedure ff (p1 varchar2 );

Install the innodb Engine (mysql5.1 is not installed by default) You can add the -- with-plugins = innobase parameter to configrue during compilation and installation. If you have installed innodb before, you can also install the innodb

Error message for rman backup in Linux Obviously, the rman command cannot be found. There is a problem with the path or the environment variable. [Oracle @ RedHat/] $ mailMail version 8.1 6/6/93. Type? For help."/Var/spool/mail/oracle": 13 messages 1

When a frequent commit/rollback or disk I/O problem occurs and a large number of physical read/write contention occurs, we will often see that the LOG FILE SYNC wait event appears in TOP EVENTS, the metrics for evaluating log file sync wait events

1. I carefully read the Flush syntax and often use the Flush command at work. Here I will summarize it. MySQL FLUSH syntax (clear or reload internal cache) FLUSH flush_option [, flush_option]. If you want to clear some MySQL instances using internal

OS: SUSE10DBMS: Oracle11.1.0.7When querying a table, the system reports an error related to the temp tablespace, and the log reports that the tempfile cannot be expanded. Current log #2 seq #644 mem #0:/oradata/test02/test02/redo02.logTue May 14 14:2

Scenario Description: There are two tables in the Oracle database, one being tm_bus_realtime_log. The current table only contains data from the previous day. The data volume has millions of data records. There is also a table where the History Table

Because the project needs to change Oracle_sid (tested) to nid, the result is half lost and the database is suspended. Finally, you cannot reinstall the database. When I started the database today, the error was: ORA-01103 Database Control File andD:

Silly, the simplest way to write Oracle_database_linux32.zip indicates the installation package name.   #! /Bin/bash ################### Yum and rpm ################## # Touch/etc/yum. repos. d/1. repo Echo "[1]">/etc/yum. repos. d/1. repo Echo

In an SQL statement, several subqueries are union. It is okay to execute each subquery separately, but the statement is executed after union, and an error is reported.ORA-00904: "xxx": invalid identifierEach subquery of union must have the same