Filesystem       Inodes    IUsed   IFree IUse% Mounted on
/dev/md2       15073280 15073280       0  100% /

Filesystem      Size  Used Avail Use% Mounted on
/dev/md2        227G  191G   24G  89% /

[mysqld]
max_allowed_packet = 1G
bulk_insert_buffer_size = 1G
max_connections = 100
thread_cache_size = 100
query_cache_limit = 128M
query_cache_size  = 3G

#query_cache_type = ON
innodb_buffer_pool_size = 40G
innodb_log_file_size = 5G
innodb_buffer_pool_instances = 40

join_buffer_size = 1M

innodb_flush_log_at_trx_commit = 2

table_open_cache = 100000
table_definition_cache = 80000
open_files_limit = 350000
tmp_table_size = 1G
max_heap_table_size = 1G