Database
2008.11.24 11:00

MySQL / Admin

조회 수 21714 추천 수 0 댓글 0
?

단축키

Prev이전 문서

Next다음 문서

크게 작게 위로 아래로 댓글로 가기 인쇄
?

단축키

Prev이전 문서

Next다음 문서

크게 작게 위로 아래로 댓글로 가기 인쇄
Extra Form
  • root 계정에 패스워드 부여
    • set password for root@localhost=password('새로운 암호');
    • set password for root@"%"=password('새로운 암호');
    • flush privileges;

  • 새로운 사용자에게 모든 권한 주기(새로운 사용자 생성제외)
    • grant all privileges on *.* to 새로운사용자ID@localhost identified by '새로운암호';
    • mysql> flush privileges;

  • 네트워크를 통새 DB에 접속하려면
    • grant all privileges on *.* to 사용자ID@"%"
      identified by '사용자암호';
    • mysql> flush privileges;

  • 새로운 사용자에 SELECT, INSERT, UPDATE, DELETE, DROP 연산을 지정된 DB만 허용
    • grant select, insert, update, delete, drop on DB명.* to 사용자ID@localhost identified by '사용자암호';
    • mysql> flush privileges;

  • mysqldump (old version compatible)
    # mysqldump --extended-insert=FALSE --compatible=mysql323 --default-character-set=latin1 -uUSERNAME -p DB_NAME > DUMP_FILE.sql
TAG •

Database
2007.12.04 10:18

mysql / InnoDB Overview

조회 수 19369 추천 수 0 댓글 0
?

단축키

Prev이전 문서

Next다음 문서

크게 작게 위로 아래로 댓글로 가기 인쇄
?

단축키

Prev이전 문서

Next다음 문서

크게 작게 위로 아래로 댓글로 가기 인쇄
Extra Form
InnoDB 는 저장 엔진의 일종입니다.
commit, rollback, crash recovery 기능을 가진 transaction-safe MySQL을 제공합니다.
로우 레벨에서 locking을 하며, SELECT 문 사용시 Oracle-style과 일치하는 non-locking을 지원합니다.
이런 특징들은 멀티유저 동시성과 성능을 증가시켜 줍니다.
FOREIGN KEY 제약을 지원하며, 다른 MySQL 저장엔진과 혼합 사용이 가능합니다.

---

InnoDB provides MySQL with a transaction-safe (ACID compliant) storage engine that has commit, rollback, and crash recovery capabilities. InnoDB does locking on the row level and also provides an Oracle-style consistent non-locking read in SELECT statements. These features increase multi-user concurrency and performance. There is no need for lock escalation in InnoDB because row-level locks fit in very little space. InnoDB also supports FOREIGN KEY constraints. You can freely mix InnoDB tables with tables from other MySQL storage engines, even within the same statement.

InnoDB has been designed for maximum performance when processing large data volumes. Its CPU efficiency is probably not matched by any other disk-based relational database engine.

Fully integrated with MySQL Server, the InnoDB storage engine maintains its own buffer pool for caching data and indexes in main memory. InnoDB stores its tables and indexes in a tablespace, which may consist of several files (or raw disk partitions). This is different from, for example, MyISAM tables where each table is stored using separate files. InnoDB tables can be of any size even on operating systems where file size is limited to 2GB.

InnoDB is included in binary distributions by default. The Windows Essentials installer makes InnoDB the MySQL default storage engine on Windows.

InnoDB is used in production at numerous large database sites requiring high performance. The famous Internet news site Slashdot.org runs on InnoDB. Mytrix, Inc. stores over 1TB of data in InnoDB, and another site handles an average load of 800 inserts/updates per second in InnoDB.

InnoDB is published under the same GNU GPL License Version 2 (of June 1991) as MySQL. For more information on MySQL licensing, see http://www.mysql.com/company/legal/licensing/.

Additional resources

·         A forum dedicated to the InnoDB storage engine is available at http://forums.mysql.com/list.php?22.

 



Board Pagination Prev 1 Next
/ 1