Re: Configuración MySQL 5.5 innodb
Te comparto la configuración de mi archivo my.ini:
[client]
port=3306
[mysql]
default-character-set=latin1
[mysqld]
port=3306
basedir="C:/Program Files (x86)/MySQL/MySQL Server 5.5/"
datadir="C:/ProgramData/MySQL/MySQL Server 5.5/Data/"
character-set-server=latin1
default-storage-engine=INNODB
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
max_connections=800
query_cache_size=156M
table_cache=1520
tmp_table_size=512M
thread_cache_size=38
myisam_max_sort_file_size=100G
myisam_sort_buffer_size=56M
key_buffer_size=25M
read_buffer_size=64K
read_rnd_buffer_size=256K
sort_buffer_size=256K
#*** INNODB Specific options ***
innodb_additional_mem_pool_size=19M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=10M
innodb_buffer_pool_size = 1024M
innodb_log_file_size = 250M
innodb_thread_concurrency=18
max_allowed_packet = 32M
Subject
Views
Written By
Posted
1275
April 11, 2016 01:30PM
682
April 11, 2016 04:39PM
1731
April 11, 2016 07:35PM
876
April 12, 2016 08:49PM
1105
April 12, 2016 09:49PM
841
April 14, 2016 02:50PM
Re: Configuración MySQL 5.5 innodb
858
April 14, 2016 04:38PM
883
April 14, 2016 06:41PM
833
April 14, 2016 07:49PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.