Database Administrator

Use Gearman to synchronize data from MySQL to Redis For data that frequently changes, if you still use the traditional static cache method (Memocached, File System, and so on) to display data, there may be a huge overhead in cache access, but Redis,

Set Ubuntu to allow remote connection to MySQL Set Ubuntu to allow remote connection to MySQL. For security reasons, MySql-Server only allows access from local machines (localhost, 127.0.0.1. this is no problem for the website architecture of both

Oracle lab environment setup (Windows + Oracle 11g) I. systems and software Windows 7 + Oracle 11g 2. Prepare the installation environment Prepare for ORACLE Installation 1. Delete Environment Variables D: \ oracle \ product \ 11.2.0 \ dbhome_1 \

Summary of common mysql commands and summary of common mysql commands# Modifying Field TypesAlter table 'table _ name' modify column ip varchar (50 );# Adding fieldsAlter table 'table _ name' add ip varchar (50 );# Add a primary key (primary key

Oracle undo complexity-oracle Core Technology Reading Notes 4, undo-oracle I. Overview Undo stores old data. For example, if you modify A record to change abc of column A to def, abc is saved in undo. There are two purposes: 1. if your transaction

ORA-01461: can bind a LONG value only for insert into a LONG column, varchar2ora-01461 I recently encountered such a strange problem when I was working on a project of tianyinda freight interface. Background: Use the application written In proc to

NBU reconfiguration leads to unsuccessful recovery-link, NBU-Oracle of oracle and nbu[Root @ SsevendbS01 rman] # su-oracle [oracle @ SsevendbS01 ~] $ Rman target/Recovery Manager: Release 11.2.0.3.0-Production on Fri Sep 19 09:47:47 2014Copyright (c)

MySQL TIMESTAMP (TIMESTAMP) details, mysqltimestamp When creating a table, if a field type in the table is TIMESTAMP, the default statement for generating this field is: CREATE TABLE `test` ( `id` int(11) DEFAULT NULL, `ctime` timestamp NOT NULL

WAS cluster series (16): WAS cluster deletes the summary file, cluster Summary **************************************** ******************************** ****************  Original Works are from the blog of "Deep Blue blog". You are welcome to

Oracle Database officially states that it does not support Vmware and oraclevmware Oracle explicitly stated on its official Support website in September that it does not Support running Oracle databases on VMWare.What should we do in the current era

Can't open named pipe to host:. pipe: MySQL, namedpipeThe following error is reported when mysql is connected to odbc: Can't open named pipe to host:. pipe: MySQL:According to the methods mentioned on the Internet, the official mysql statement did

My. cnf already exists, affecting installation -- mysql, my. cnf -- mysql Found existing config file./my. cnf on the system. Because this file might be in use, it was not replaced, But was used in bootstrap (unless you used -- defaults-file) And

How to use STA (SQL tuning advisor), tuningadvisor1. manually generate SQL tuning advisor1. SQL text format:DECLAREMy_task_name VARCHAR2 (30 );My_sqltext CLOB;BEGINMy_sqltext: = 'select * FROM DBA_SEGMENTS where owner = ''clic' AND SEGMENT_TYPE =

[Redis album] [1] methods and steps for installing php-redis under ubuntu12.04, redisphp-redis First release path: Install phpredis I haven't written a blog post for a long time, and I haven't completed many blog posts. Today I just took the time to

Oracle primary key deletion, joint primary key creation, oracle primary key1. Delete the primary key alter table tablename drop PRIMARY_KEY execute the preceding SQL statement to delete the primary key; if it fails, use ALTER TABLE TABLENAME DROP

[Oracle Study Notes], oracle Study Notes The content mainly includes: (1) three cycles and their simplification (2) Use of cursors (3) Exception Handling (4) Stored Procedure (5) storage functions (6) triggers (7) Other pl/SQL operations -----------

[Translated from mos] Get the session id of the running job, mosjobObtain the session id of the job.Reference Original:How to get the session Id of the Running Job (Doc ID 1604966.1)Applicable:Oracle Database-Enterprise Edition-Version 9.2.0.8 and

Since MySQL was acquired by Oracle, PostgreSQL has gradually become the first choice for Open Source relational databases.This article introduces the installation and basic usage of PostgreSQL for the first time users. The following content is based

Tissot k1 k-ux And Oracle database, uxUp to now, Oracle database 12.1.0.2 has not passed the authentication on k-ux because the k-ux operating system is not in the list of authenticated operating systems, no authentication

Mysql SQL Statement Review 2 -- Regular Expressions and mysql Regular Expressions Here, we will briefly review the usage of Regular Expressions in mysql when filtering data. This mainly refers to an example for each usage or a brief description. The