Database Administrator

A MySQL table is designed in PowerDesigner of Win7. It is only found that MySQL is ready to be imported into the MySQL database.The ODBC program is not installed, and the ODBC configuration is not found in the console. This is too tricky.1. first go

In database management, some historical data or basically unchanged data is put into the read-only tablespace. Because such tablespaces can only be read but not DML. It can effectively prevent accidental modification or deletion, so it is suitable

The Master/Slave configuration of the mysql server, which can implement read/write splitting, or restore data from the slave database after the master database fails.Two machines are required, mysql is installed, and the two machines must be in the

It is interesting to have a look at the discussion of different roles. Start with Linus: O_DIRECT (Larry McVoy; Linus Torvalds)-Yarchive Note that this post is a little long and has a long time span. It takes a bit of patience to finish reading.

// Interface Class package com. syxy. dao; import com. syxy. domain. user; // The dao interface for manipulating the database public interface UserDao {// Add a User public void addUser (user User); // get a User public user getUser (int userId ); //

1. del key1 key2 ''''' Add version 1.0.0. Time Complexity: O (n) N indicates the number of keys to be removed. Remove the key of a single string. the time complexity is O (1 ). Remove keys of a single list, set, sorted set, or hash table type. The

Modify the locked user in Oracle 11g: scott After installing Oracle10g and creating an oracle database, you can log on to the database using scott to check whether the connection is successful. When you log on with sqlplus scott/tiger in the cmd

SQL server 2005 has been installed on one server, and everything is normal. Recently, due to the use of table type parameters, sqlserver 2008 needs to be installed, but cannot be connected after installation. The local machine can be connected

I/O statistics for tablespace in the oracle database during the last two hours -------------------------- ------For single instance---------- Select e. tsname,Sum (e. phyrds-nvl (B. phyrds, 0) reads,Sum (e. phyrds-nvl (B. phyrds, 0 ))/(Select

1. Questions about database RestorationHttp://bbs.csdn.net/topics/390699019The following error occurs when you restore the. bak file:Error: 3205 too many devices are specified for backup or restoration. Only 64 devices are allowed.The restore

Speaking of DBA, the full name is Database Administrator, not Doctor of Business Administration. Do not misunderstand it. That's a world of difference! Even so, many people still think that there is a mysterious veil, an uncertain, and a garlands

Advantages and disadvantages of ASSM and MSSM. ASSM: advantage, support for large concurrent Inserts : Disadvantages: the clustering factor of the index will be very poor-you can use reverse key indexes and Hash partitions. MSSM does not support

The last article in the Sesame Series introduced how to add Triple Data. This article describes how to export Triple Data to a file.1. Establish a database connection static NativeStore nativeStore;static Repository repo;static String

When the built-in functions provided by Hive cannot meet your business processing needs, you can consider using user-defined functions (UDF: user-defined function ). Currently, Hive only supports writing udfs in java. If you need to use another

In the process of writing documents, there must be a system database design. How should we design the database? First, let's explain a concept: CDM: The concept Data Model (CDM) is used to design the process from the concept layer. In the concept

1. External Connection select * from T_N left join T_S on T_N.id=T_S.id   select * from T_N right join T_S on T_N.id=T_S.id

(gdb) qThe program is running. Quit anyway (and detach it)? (y or n) yDetaching from program: /u01/app/oracle/product/11.2.0/bin/oracle, process 7376 [oracle@mydb ~]$ gdb $ORACLE_HOME/bin/oracle 7376GNU gdb Fedora (6.8-27.el5)Copyright (C) 200

Character Set is a set of symbols and encoding rules. Both the oracle database and mysql database have character set selection problems. Character sets are important for databases, because most of the data stored in the database is various texts.

Http://www.mysqlperformanceblog.com/2013/03/16/simcity-outages-traffic-control-and-thread-pool-for-mysql/ This article vividly describes the beauty of the thread pool, which can solve the performance degradation of high-concurrency

The previous tasks involving oracle regular backup were completed at the operating system level. The following uses oracle task scheduler to regularly perform oracle backup. For detailed steps, see: 1. the backup statement/oracle/bak/fullbk.txt is