MySQL Forums
Forum List  »  Spanish

Re: Out of Memory
Posted by: Christian Seran
Date: May 04, 2018 10:31AM

Jesus, muchas gracias por tu respuesta.

Acá te dejo el my.ini

[client]
port=3306
[mysql]
default-character-set=latin1
[mysqld]
port=3306
max_allowed_packet = 16M

basedir="F:/Mysqlserver/"

datadir="F:/Mysqlserver/Data/"

default-character-set=latin1
default-storage-engine=INNODB

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

max_connections=100
query_cache_size=182M
table_cache=256
tmp_table_size=185M
thread_cache_size=8
myisam_max_sort_file_size=100G
myisam_max_extra_sort_file_size=100G
myisam_sort_buffer_size=36M
key_buffer_size=286M
read_buffer_size=64K
read_rnd_buffer_size=256K
sort_buffer_size=256K
innodb_additional_mem_pool_size=12M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=6M
innodb_buffer_pool_size=555M
innodb_log_file_size=111M
innodb_thread_concurrency=10
log_bin="mysql_bin"
server_id=1



Gracias!

Options: ReplyQuote


Subject
Views
Written By
Posted
208
May 03, 2018 07:22PM
103
May 04, 2018 07:44AM
Re: Out of Memory
105
May 04, 2018 10:31AM
106
May 04, 2018 01:01PM
95
May 08, 2018 06:55PM


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.