Adjustment Mysql
Posted: Tue Dec 15, 2009 8:01 pm
How it is better to optimise options Mysql for optimum work of a server?
OS Ubuntu 9.04
CPU C2D 3Hz
RAM 4G
OS Ubuntu 9.04
CPU C2D 3Hz
RAM 4G
español
esta configuración estoy usando, sin ningún problema.
Code: Select all
[client]port=3306 [mysql]default-character-set=latin1 [mysqld]port=3306basedir="C:/Program Files/MySQL/MySQL Server 5.1/"datadir="C:/Program Files/MySQL/MySQL Server 5.1/Data/"default-character-set=latin1default-storage-engine=INNODBsql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"max_connections=300table_cache=3000 query_cache_size=350Mquery_cache_type=1query_cache_limit=512k #posible que no hacen faltatmp_table_size=0M#max_heap_table_size=512M thread_cache_size=2048log_slow_queriesmemlock #probar esto, antes 14400wait_timeout =3600interactive_timeout=3600 query_prealloc_size=16k #*** MyISAM Specific optionsmyisam_max_sort_file_size=100Gmyisam_max_extra_sort_file_size=100Gmyisam_sort_buffer_size=30Mkey_buffer_size=350Mread_buffer_size=64Kread_rnd_buffer_size=256Ksort_buffer_size=256k #*** INNODB Specific options ***innodb_data_home_dir="C:/MySQL Datafiles/"#skip-innodbinnodb_additional_mem_pool_size=6Minnodb_flush_log_at_trx_commit=1innodb_log_buffer_size=3Minnodb_buffer_pool_size=350Minnodb_log_file_size=50Minnodb_thread_concurrency=8innodb_lock_wait_timeout =50innodb_file_per_tableinnodb_open_files=2400