[근사모] 근땅e

진행하고 있는일

일본
 - FX매거진 ( fxmagazine.jp )
 - 미즈마 갤러리
 - 람비트

ShiftWorks
 - 파트너쉽
 - 웹 DNS관리 + DDNS + DDNS 클라이언트 + 파킹서비스 + 포워딩 서비스
 - APM_Setup 업데이트 / 홈페이지 리뉴얼 & 디비 컨버팅.. 작업
 - ......

 - 유폼/새싹/휩스 ..

많고 많구먼..

쩝..

언제쯤 다 할지?

아래 설정 값은
http://www.mysqlperformanceblog.com/ 를 참고하여 재 정리한 자료 입니다.
자신의 상황에 맞게 고쳐 쓸 필요가 있으며 실 서비스에 적용시 발생하는 문제에 대해서는 책임 지지 않습니다 . ^^;;

innodb_buffer_pool_size

인덱스와 데이터를 메모리로 캐쉬하기 위한 용도로 사용됨.
크게 잡을수록 Disk IO 가 적게 일어남.
최대 80% 까지를 추천
너무 크게 잡을 경우 OS 에서 사용하는 메모리가 적어져 스와핑이 발생하므로 주의 할 필요 있음.일부 보고에 의하면 50% 이상 잡더라도 실제로는 물리메모리의 50% 이상을 사용하지 않는다고 함. 따라서, 기본은 50% 를 추천함

innodb_flush_method

buffer pool size 와 관련된 중요한 설정값임
Innodb 가 이미 캐쉬한 자료를 OS 가 다시 캐쉬할지를 결정하는 설정값
Double buffering 과 스왑의 부담을 줄이기 위해 설정
Linux/Unix/Solaris/BSD 계열에서는 fsync() 를 사용하여 파일을 디스크에 Flush 함( InnoDB 가 기본적으로 사용하는 방법임). MySQL 의 쓰기 성능을 높이고자 할경우 O_DSYNC 로 설정할 수 있음. 윈도우 에서는 O_DSYNC 가 더 느릴 수 있음.

innodb_log_file_size

데이터 복구를 위하여 사용되는 로그파일의 크기
시스템 성능과 복구속도를 고려할때 256M 가 적당함.

innodb_log_buffer_size

대량의 blob 데이터를 Innodb 로 piping 하지 않는다면 4M 가 적당

innodb_flush_log_at_trx_commit

데이터 베이스의 ACID( Atomicity,Consistency,Isolation,Durability ) 를 고려하지 않거나 OS Fail시 트랜잭션을 보장하지 않을 경우 2 로 설정.
2로 설정하는 경우 짧으면서 대량의 트랜잭션 발생시 극적인 성능 향상이 기대된다.
MyISAM 엔진보다 100배 이상 느리다고 생각한다면 설정을 적극적으로 검토하라.

innodb_file_per_table

테이블 수가 지나치게 많지 않을 경우 사용
Innodb 메인 테이블스페이스를 사용 했을때의 관리 문제 극복 가능

thread_cache_size

스레드의 생성/소멸 에는 많은 비용이 드는데 이를 캐쉬에 저장하여 생성/소멸의 비용을 줄일 때 사용한다.
최소 16으로 설정하라.

query_cache_size

읽기가 집중적으로 일어나며 어플리케이션에서 캐쉬처리 하지 않을 경우 유용 너무 크게 잡으면 느려질 가능성이 있음.
범위는 32 ~ 512M 정도가 적당

출처 :

http://www.ihelpers.co.kr/programming/tipntech.php?CMD=view&TYPE=0&KEY=&SC=S&&CC=&PAGE=1&IDX=650

Usage: configure [options] [host]
Options: [defaults in brackets after descriptions]
Configuration:
  --cache-file=FILE       cache test results in FILE
  --help                  print this message
  --no-create             do not create output files
  --quiet, --silent       do not print `checking...' messages
  --version               print the version of autoconf that created configure
Directory and file names:
  --prefix=PREFIX         install architecture-independent files in PREFIX
                          [/usr/local]
  --exec-prefix=EPREFIX   install architecture-dependent files in EPREFIX
                          [same as prefix]
  --bindir=DIR            user executables in DIR [EPREFIX/bin]
  --sbindir=DIR           system admin executables in DIR [EPREFIX/sbin]
  --libexecdir=DIR        program executables in DIR [EPREFIX/libexec]
  --datadir=DIR           read-only architecture-independent data in DIR
                          [PREFIX/share]
  --sysconfdir=DIR        read-only single-machine data in DIR [PREFIX/etc]
  --sharedstatedir=DIR    modifiable architecture-independent data in DIR
                          [PREFIX/com]
  --localstatedir=DIR     modifiable single-machine data in DIR [PREFIX/var]
  --libdir=DIR            object code libraries in DIR [EPREFIX/lib]
  --includedir=DIR        C header files in DIR [PREFIX/include]
  --oldincludedir=DIR     C header files for non-gcc in DIR [/usr/include]
  --infodir=DIR           info documentation in DIR [PREFIX/info]
  --mandir=DIR            man documentation in DIR [PREFIX/man]
  --srcdir=DIR            find the sources in DIR [configure dir or ..]
  --program-prefix=PREFIX prepend PREFIX to installed program names
  --program-suffix=SUFFIX append SUFFIX to installed program names
  --program-transform-name=PROGRAM
                          run sed PROGRAM on installed program names
Host type:
  --build=BUILD           configure for building on BUILD [BUILD=HOST]
  --host=HOST             configure for HOST [guessed]
  --target=TARGET         configure for TARGET [TARGET=HOST]
Features and packages:
  --disable-FEATURE       do not include FEATURE (same as --enable-FEATURE=no)
  --enable-FEATURE[=ARG]  include FEATURE [ARG=yes]
  --with-PACKAGE[=ARG]    use PACKAGE [ARG=yes]
  --without-PACKAGE       do not use PACKAGE (same as --with-PACKAGE=no)
  --x-includes=DIR        X include files are in DIR
  --x-libraries=DIR       X library files are in DIR
--enable and --with options recognized:
  --with-libdir=NAME      Look for libraries in .../NAME rather than .../lib
  --disable-rpath         Disable passing additional runtime library
                          search paths

SAPI modules:

  --with-aolserver=DIR    Specify path to the installed AOLserver
  --with-apxs[=FILE]      Build shared Apache 1.x module. FILE is the optional
                          pathname to the Apache apxs tool [apxs]
  --with-apache[=DIR]     Build Apache 1.x module. DIR is the top-level Apache
                          build directory [/usr/local/apache]
  --enable-mod-charset      APACHE: Enable transfer tables for mod_charset (Rus Apache)
  --with-apxs2filter[=FILE]  
                          EXPERIMENTAL: Build shared Apache 2.0 Filter module. FILE is the optional
                          pathname to the Apache apxs tool [apxs]
  --with-apxs2[=FILE]     Build shared Apache 2.0 Handler module. FILE is the optional
                          pathname to the Apache apxs tool [apxs]
  --with-apache-hooks[=FILE]     
                          EXPERIMENTAL: Build shared Apache 1.x module. FILE is the optional
                          pathname to the Apache apxs tool [apxs]
  --with-apache-hooks-static[=DIR]
                          EXPERIMENTAL: Build Apache 1.x module. DIR is the top-level Apache
                          build directory [/usr/local/apache]
  --enable-mod-charset      APACHE (hooks): Enable transfer tables for mod_charset (Rus Apache)
  --with-caudium[=DIR]    Build PHP as a Pike module for use with Caudium.
                          DIR is the Caudium server dir [/usr/local/caudium/server]
  --disable-cli           Disable building CLI version of PHP
                          (this forces --without-pear)
  --with-continuity=DIR   Build PHP as Continuity Server module.
                          DIR is path to the installed Continuity Server root
  --enable-embed[=TYPE]   EXPERIMENTAL: Enable building of embedded SAPI library
                          TYPE is either 'shared' or 'static'. [TYPE=shared]
  --with-isapi[=DIR]      Build PHP as an ISAPI module for use with Zeus
  --with-milter[=DIR]     Build PHP as Milter application
  --with-nsapi=DIR        Build PHP as NSAPI module for Netscape/iPlanet/Sun Webserver
  --with-phttpd=DIR       Build PHP as phttpd module
  --with-pi3web[=DIR]     Build PHP as Pi3Web module
  --with-roxen=DIR        Build PHP as a Pike module. DIR is the base Roxen
                          directory, normally /usr/local/roxen/server
  --enable-roxen-zts        ROXEN: Build the Roxen module using Zend Thread Safety
  --with-thttpd=SRCDIR    Build PHP as thttpd module
  --with-tux=MODULEDIR    Build PHP as a TUX module (Linux only)
  --with-webjames=SRCDIR  Build PHP as a WebJames module (RISC OS only)
  --disable-cgi           Disable building CGI version of PHP
  --enable-fastcgi          CGI: Enable FastCGI support in the CGI binary
  --enable-force-cgi-redirect
                            CGI: Enable security check for internal server
                            redirects. Use this if you run the PHP CGI with Apache
  --enable-discard-path     CGI: When this is enabled the PHP CGI binary can
                            safely be placed outside of the web tree and people
                            will not be able to circumvent .htaccess security
  --disable-path-info-check CGI: If this is disabled, paths such as
                            /info.php/test?a=b will fail to work

General settings:

  --enable-gcov           Enable GCOV code coverage (requires LTP) - FOR DEVELOPERS ONLY!!
  --enable-debug          Compile with debugging symbols
  --with-layout=TYPE      Set how installed files will be laid out.  Type can
                          be either PHP or GNU [PHP]
  --with-config-file-path=PATH
                          Set the path in which to look for php.ini [PREFIX/lib]
  --with-config-file-scan-dir=PATH
                          Set the path where to scan for configuration files
  --enable-safe-mode      Enable safe mode by default
  --with-exec-dir[=DIR]   Only allow executables in DIR under safe-mode
                          [/usr/local/php/bin]
  --enable-sigchild       Enable PHP's own SIGCHLD handler
  --enable-magic-quotes   Enable magic quotes by default.
  --enable-libgcc         Enable explicitly linking against libgcc
  --disable-short-tags    Disable the short-form <? start tag by default
  --enable-dmalloc        Enable dmalloc
  --disable-ipv6          Disable IPv6 support
  --enable-fd-setsize     Set size of descriptor sets

Extensions:

  --with-EXTENSION=[shared[,PATH]]
 
    NOTE: Not all extensions can be build as 'shared'.

    Example: --with-foobar=shared,/usr/local/foobar/

      o Builds the foobar extension as shared extension.
      o foobar package install prefix is /usr/local/foobar/

 --disable-all   Disable all extensions which are enabled by default

  --disable-libxml        Disable LIBXML support
  --with-libxml-dir[=DIR]   LIBXML: libxml2 install prefix
  --with-openssl[=DIR]    Include OpenSSL support (requires OpenSSL >= 0.9.6)
  --with-kerberos[=DIR]     OPENSSL: Include Kerberos support
  --without-pcre-regex    Do not include Perl Compatible Regular Expressions support.
                          DIR is the PCRE install prefix [BUNDLED]
  --with-zlib[=DIR]       Include ZLIB support (requires zlib >= 1.0.9)
  --with-zlib-dir=<DIR>   Define the location of zlib install directory
  --enable-bcmath         Enable bc style precision math functions
  --with-bz2[=DIR]        Include BZip2 support
  --enable-calendar       Enable support for calendar conversion
  --disable-ctype         Disable ctype functions
  --with-curl[=DIR]       Include cURL support
  --with-curlwrappers     Use cURL for url streams
  --enable-dba            Build DBA with bundled modules. To build shared DBA
                          extension use --enable-dba=shared
  --with-qdbm[=DIR]         DBA: QDBM support
  --with-gdbm[=DIR]         DBA: GDBM support
  --with-ndbm[=DIR]         DBA: NDBM support
  --with-db4[=DIR]          DBA: Berkeley DB4 support
  --with-db3[=DIR]          DBA: Berkeley DB3 support
  --with-db2[=DIR]          DBA: Berkeley DB2 support
  --with-db1[=DIR]          DBA: Berkeley DB1 support/emulation
  --with-dbm[=DIR]          DBA: DBM support
  --without-cdb[=DIR]       DBA: CDB support (bundled)
  --disable-inifile         DBA: INI support (bundled)
  --disable-flatfile        DBA: FlatFile support (bundled)
  --enable-dbase          Enable the bundled dbase library
  --disable-dom           Disable DOM support
  --with-libxml-dir[=DIR]   DOM: libxml2 install prefix
  --enable-exif           Enable EXIF (metadata from images) support
  --with-fbsql[=DIR]      Include FrontBase support. DIR is the FrontBase base directory
  --with-fdftk[=DIR]      Include FDF support
  --disable-filter        Disable input filter support
  --with-pcre-dir           FILTER: pcre install prefix
  --enable-ftp            Enable FTP support
  --with-openssl-dir[=DIR]  FTP: openssl install prefix
  --with-gd[=DIR]         Include GD support.  DIR is the GD library base
                          install directory [BUNDLED]
  --with-jpeg-dir[=DIR]     GD: Set the path to libjpeg install prefix
  --with-png-dir[=DIR]      GD: Set the path to libpng install prefix
  --with-zlib-dir[=DIR]     GD: Set the path to libz install prefix
  --with-xpm-dir[=DIR]      GD: Set the path to libXpm install prefix
  --with-ttf[=DIR]          GD: Include FreeType 1.x support
  --with-freetype-dir[=DIR] GD: Set the path to FreeType 2 install prefix
  --with-t1lib[=DIR]        GD: Include T1lib support. T1lib version >= 5.0.0 required
  --enable-gd-native-ttf    GD: Enable TrueType string function
  --enable-gd-jis-conv      GD: Enable JIS-mapped Japanese font support
  --with-gettext[=DIR]    Include GNU gettext support
  --with-gmp[=DIR]        Include GNU MP support
  --disable-hash          Disable hash support
  --without-iconv[=DIR]   Exclude iconv support
  --with-imap[=DIR]       Include IMAP support. DIR is the c-client install prefix
  --with-kerberos[=DIR]     IMAP: Include Kerberos support. DIR is the Kerberos install prefix
  --with-imap-ssl[=DIR]     IMAP: Include SSL support. DIR is the OpenSSL install prefix
  --with-interbase[=DIR]  Include InterBase support.  DIR is the InterBase base
                          install directory [/usr/interbase]
  --disable-json          Disable JavaScript Object Serialization support
  --with-ldap[=DIR]       Include LDAP support
  --with-ldap-sasl[=DIR]    LDAP: Include Cyrus SASL support
  --enable-mbstring       Enable multibyte string support
  --disable-mbregex         MBSTRING: Disable multibyte regex support
  --disable-mbregex-backtrack
                            MBSTRING: Disable multibyte regex backtrack check
  --with-libmbfl[=DIR]      MBSTRING: Use external libmbfl.  DIR is the libmbfl base
                            install directory [BUNDLED]
  --with-mcrypt[=DIR]     Include mcrypt support
  --with-mhash[=DIR]      Include mhash support
  --with-mime-magic[=FILE] 
                          Include mime_magic support (DEPRECATED!!)
  --with-ming[=DIR]       Include MING support
  --with-msql[=DIR]       Include mSQL support.  DIR is the mSQL base
                          install directory [/usr/local/Hughes]
  --with-mssql[=DIR]      Include MSSQL-DB support.  DIR is the FreeTDS home
                          directory [/usr/local/freetds]
  --with-mysql[=DIR]      Include MySQL support. DIR is the MySQL base directory
  --with-mysql-sock[=DIR]   MySQL: Location of the MySQL unix socket pointer.
                            If unspecified, the default locations are searched
  --with-zlib-dir[=DIR]     MySQL: Set the path to libz install prefix
  --with-mysqli[=FILE]    Include MySQLi support.  FILE is the optional pathname
                          to mysql_config [mysql_config]
  --enable-embedded-mysqli  MYSQLi: Enable embedded support
  --with-ncurses[=DIR]    Include ncurses support (CLI/CGI only)
  --with-oci8[=DIR]       Include Oracle (OCI8) support. DIR defaults to $ORACLE_HOME.
                          Use --with-oci8=instantclient,/path/to/oic/lib
                          for an Oracle Instant Client installation
  --with-adabas[=DIR]     Include Adabas D support [/usr/local]
  --with-sapdb[=DIR]      Include SAP DB support [/usr/local]
  --with-solid[=DIR]      Include Solid support [/usr/local/solid]
  --with-ibm-db2[=DIR]    Include IBM DB2 support [/home/db2inst1/sqllib]
  --with-ODBCRouter[=DIR] Include ODBCRouter.com support [/usr]
  --with-empress[=DIR]    Include Empress support [$EMPRESSPATH]
                          (Empress Version >= 8.60 required)
  --with-empress-bcs[=DIR]
                          Include Empress Local Access support [$EMPRESSPATH]
                          (Empress Version >= 8.60 required)
  --with-birdstep[=DIR]   Include Birdstep support [/usr/local/birdstep]
  --with-custom-odbc[=DIR]
                          Include user defined ODBC support. DIR is ODBC install base
                          directory [/usr/local]. Make sure to define CUSTOM_ODBC_LIBS and
                          have some odbc.h in your include dirs. f.e. you should define
                          following for Sybase SQL Anywhere 5.5.00 on QNX, prior to
                          running this configure script:
                              CPPFLAGS="-DODBC_QNX -DSQLANY_BUG"
                              LDFLAGS=-lunix
                              CUSTOM_ODBC_LIBS="-ldblib -lodbc"
  --with-iodbc[=DIR]      Include iODBC support [/usr/local]
  --with-esoob[=DIR]      Include Easysoft OOB support [/usr/local/easysoft/oob/client]
  --with-unixODBC[=DIR]   Include unixODBC support [/usr/local]
  --with-dbmaker[=DIR]    Include DBMaker support
  --enable-pcntl          Enable experimental pcntl support (CLI/CGI only)
  --disable-pdo           Disable PHP Data Objects support
  --with-pdo-dblib[=DIR]    PDO: DBLIB-DB support.  DIR is the FreeTDS home
                            directory
  --with-pdo-firebird[=DIR] PDO: Firebird support.  DIR is the Firebird base
                            install directory [/opt/firebird]
  --with-pdo-mysql[=DIR]    PDO: MySQL support. DIR is the MySQL base directory
  --with-zlib-dir[=DIR]       PDO_MySQL: Set the path to libz install prefix
  --with-pdo-oci[=DIR]      PDO: Oracle OCI support. DIR defaults to $ORACLE_HOME.
                            Use --with-pdo-oci=instantclient,prefix,version
                            for an Oracle Instant Client SDK.
                            For Linux with 10.2.0.3 RPMs (for example) use:
                            --with-pdo-oci=instantclient,/usr,10.2.0.3
  --with-pdo-odbc=flavour,dir
                            PDO: Support for 'flavour' ODBC driver.
                            include and lib dirs are looked for under 'dir'.
                           
                            'flavour' can be one of:  ibm-db2, unixODBC, generic
                            If ',dir' part is omitted, default for the flavour
                            you have selected will used. e.g.:
                           
                              --with-pdo-odbc=unixODBC
                             
                            will check for unixODBC under /usr/local. You may attempt
                            to use an otherwise unsupported driver using the "generic"
                            flavour.  The syntax for generic ODBC support is:
                           
                              --with-pdo-odbc=generic,dir,libname,ldflags,cflags

                            When build as shared the extension filename is always pdo_odbc.so
  --with-pdo-pgsql[=DIR]    PDO: PostgreSQL support.  DIR is the PostgreSQL base
                            install directory or the path to pg_config
  --without-pdo-sqlite[=DIR]
                            PDO: sqlite 3 support.  DIR is the sqlite base
                            install directory [BUNDLED]
  --with-pgsql[=DIR]      Include PostgreSQL support.  DIR is the PostgreSQL
                          base install directory or the path to pg_config
  --disable-posix         Disable POSIX-like functions
  --with-pspell[=DIR]     Include PSPELL support.
                          GNU Aspell version 0.50.0 or higher required
  --with-libedit[=DIR]    Include libedit readline replacement (CLI/CGI only)
  --with-readline[=DIR]   Include readline support (CLI/CGI only)
  --with-recode[=DIR]     Include recode support
  --disable-reflection    Disable reflection support
  --disable-session       Disable session support
  --with-mm[=DIR]           SESSION: Include mm support for session storage
  --enable-shmop          Enable shmop support
  --disable-simplexml     Disable SimpleXML support
  --with-libxml-dir=DIR     SimpleXML: libxml2 install prefix
  --with-snmp[=DIR]       Include SNMP support
  --with-openssl-dir[=DIR]  SNMP: openssl install prefix
  --enable-ucd-snmp-hack    SNMP: Enable UCD SNMP hack
  --enable-soap           Enable SOAP support
  --with-libxml-dir=DIR     SOAP: libxml2 install prefix
  --enable-sockets        Enable sockets support
  --disable-spl           Disable Standard PHP Library
  --without-sqlite        Do not include sqlite support.  DIR is the sqlite base
                          install directory [BUNDLED]
  --enable-sqlite-utf8      SQLite: Enable UTF-8 support for SQLite
  --with-regex=TYPE       regex library type: system, apache, php. [TYPE=php]
                          WARNING: Do NOT use unless you know what you are doing!
  --with-sybase[=DIR]     Include Sybase-DB support.  DIR is the Sybase home
                          directory [/home/sybase]
  --with-sybase-ct[=DIR]  Include Sybase-CT support.  DIR is the Sybase home
                          directory [/home/sybase]
  --enable-sysvmsg        Enable sysvmsg support
  --enable-sysvsem        Enable System V semaphore support
  --enable-sysvshm        Enable the System V shared memory support
  --with-tidy[=DIR]       Include TIDY support
  --disable-tokenizer     Disable tokenizer support
  --enable-wddx           Enable WDDX support
  --with-libxml-dir=DIR     WDDX: libxml2 install prefix
  --with-libexpat-dir=DIR   WDDX: libexpat dir for XMLRPC-EPI (deprecated)
  --disable-xml           Disable XML support
  --with-libxml-dir=DIR     XML: libxml2 install prefix
  --with-libexpat-dir=DIR   XML: libexpat install prefix (deprecated)
  --disable-xmlreader     Disable XMLReader support
  --with-libxml-dir=DIR     XMLReader: libxml2 install prefix
  --with-xmlrpc[=DIR]     Include XMLRPC-EPI support
  --with-libxml-dir=DIR     XMLRPC-EPI: libxml2 install prefix
  --with-libexpat-dir=DIR   XMLRPC-EPI: libexpat dir for XMLRPC-EPI (deprecated)
  --with-iconv-dir=DIR      XMLRPC-EPI: iconv dir for XMLRPC-EPI
  --disable-xmlwriter     Disable XMLWriter support
  --with-libxml-dir=DIR     XMLWriter: libxml2 install prefix
  --with-xsl[=DIR]        Include XSL support.  DIR is the libxslt base
                          install directory (libxslt >= 1.1.0 required)
  --enable-zip            Include Zip read/write support
  --with-zlib-dir[=DIR]     ZIP: Set the path to libz install prefix

PEAR:

  --with-pear=DIR         Install PEAR in DIR [PREFIX/lib/php]
  --without-pear          Do not install PEAR

Zend:

  --with-zend-vm=TYPE     Set virtual machine dispatch method. Type is
                          one of CALL, SWITCH or GOTO [TYPE=CALL]
  --enable-maintainer-zts Enable thread safety - for code maintainers only!!
  --disable-inline-optimization
                          If building zend_execute.lo fails, try this switch
  --enable-zend-multibyte Compile with zend multibyte support

TSRM:

  --with-tsrm-pth[=pth-config]
                          Use GNU Pth
  --with-tsrm-st          Use SGI's State Threads
  --with-tsrm-pthreads    Use POSIX threads (default)

Libtool:

  --enable-shared[=PKGS]  build shared libraries [default=yes]
  --enable-static[=PKGS]  build static libraries [default=yes]
  --enable-fast-install[=PKGS]  optimize for fast installation [default=yes]
  --with-gnu-ld           assume the C compiler uses GNU ld [default=no]
  --disable-libtool-lock  avoid locking (might break parallel builds)
  --with-pic              try to use only PIC/non-PIC objects [default=use both]
  --with-tags[=TAGS]      include additional configurations [automatic]

  --with-gnu-ld           assume the C compiler uses GNU ld [default=no]

Cordless Desktop Wave™