search for: key_buffer_size

Dear R Developers, In the same way that MySQL/MariaDB's Engine InnoDB or MyISAM/Aria have the innodb_buffer_pool_size or the key_buffer_size for setting the maximum amount of RAM which can be used by a Server Instance: ?Would it be possible to create an R Configuration Variable which fixes the maximum amount of RAM memory to be used as Commit / Dynamic Memory Allocation? Thank you. Juan [[alternative HTML version deleted]]

...I have installed mysql-server-5.1.69-1.el6_4.x86_64 and run /usr/bin/mysql_secure_installation on a CentOS 6.4 machine with mucho RAM (32 GB) and I wonder, what would be the best place for the mysqld parameters descibed at http://dev.mysql.com/doc/refman/5.1/en/server-parameters.html mysqld_safe --key_buffer_size=64M --table_open_cache=256 \ --sort_buffer_size=4M --read_buffer_size=1M & Should I just edit the file /etc/init.d/mysqld or is there a better place in CentOS for that (under sysconfig?) Thanks Alex

On Sun, Sep 17, 2017 at 12:39 AM, Juan Telleria <jtelleriar at gmail.com> wrote: > Dear R Developers, > > In the same way that MySQL/MariaDB's Engine InnoDB or MyISAM/Aria have the > innodb_buffer_pool_size or the key_buffer_size for setting the maximum > amount of RAM which can be used by a Server Instance. Memory is not controlled by R itself because packages may malloc() directly. However most operating systems have features to limit resources of a given process. The CRAN package 'unix' has wrappers for posix...

...leeping processess or stale connections. What I have done in the past was optimize mysql with the following variable changes (/etc/my.cnf) wait_timeout=60 connect_timeout=10 interactive_timeout=120 join_buffer_size=1M query_cache_size=128M query_cache_limit=2M sort_buffer_size=8M key_buffer = 256M key_buffer_size=64M ... According to the mongrel docs it says to use 4hrs - assuming you didn''t edit mysql default settings- but what I am curious to know, is what most people set this to, those of us who do performance tweak their mysql servers. Also, if there is anything recommended mongrel/rails spec...

...log-bin=/data/mysqldata3/binlog/mysql-bin sync_binlog=1 #log warnings log_warnings #******************************* Replication related settings ********************** #master server-id = 3 binlog_format=mixed #******************************* MyISAM Specific options **************************** key_buffer_size = 32M read_buffer_size = 8M read_rnd_buffer_size = 2M bulk_insert_buffer_size = 16M myisam_sort_buffer_size = 64M myisam_max_sort_file_size = 10G myisam_max_extra_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover # ***************************** INNODB Specific options *****************...