Daily Archives: March 25, 2019

mysql 8.0 – Show detailed warning messages executing mysqlimport or mysql LOAD DATA

1) Add log-warnings and max error count statements to /etc/my.cnf These configuration options cause detailed warning messages to be written in /var/log/mysql.log [mysqld] log-warnings max-error-count=9999999999 2) Start the mysql client session using the –show-warnings option mysql -u… -p -hlocalhost –show-warnings Adding the –show-warnings option […]

mysql /etc/my.cnf

innodb_buffer_pool_size = 12G # 60% – 70% of your RAM size innodb_log_buffer_size = 16M # 16M or 32M innodb_log_file_size = 3G # 25% of buffer pool size innodb_write_io_threads = 32 # 32 based on core and drive count, 64 is […]

GFS2: Global File System 2 on RHEL CentOS

Global File System 2 or GFS2 is a shared-disk file system for Linux computer clusters. GFS2 differs from distributed file systems (such as AFS, Coda, InterMezzo, or GlusterFS) because GFS2 allows all nodes to have direct concurrent access to the same shared block storage. In addition, GFS or GFS2 can also be used as […]