MySQL Forums
Forum List  »  Spanish

Re: Configuración MySQL 5.5 innodb
Posted by: Milton Villafuerte
Date: April 14, 2016 04:38PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Configuración MySQL 5.5 innodb
842
April 14, 2016 04:38PM


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.