1

Your ulimit Open Files limit of 1024 is starving MySQL for handles. From OS command prompt, ulimit -n 36000 and press Enter will dynamically make 36000 handles available - on the next stop/start of MySQL. To make 36000 handles available over OS restart, follow this URL https://glassonionblog.wordpress.com/2013/01/27/increase-ulimit-and-file-descriptors-...


1

Analysis of VARIABLES and GLOBAL STATUS: Observations: Version: 5.5.62-38.14-log 32 GB of RAM Uptime = 7d 21:49:20 You are not running on Windows. Running 64-bit version You appear to be running entirely (or mostly) InnoDB. The More Important Issues: Unless you have a small dataset or a lot of other apps on the same server, innodb_buffer_pool_size (now ...


1

Rate Per Second = RPS Suggestions to consider for your my.ini [mysqld] section innodb_lru_scan_depth=100 # from 1024 to conserve 90% of CPU cycles used for function log_output=FILE # from NONE someday you will need Slow Query Log and General Log's tmp_table_size=16M # from 4M to be same size as max_heap_table_size slow_query_log=ON # from OFF to record ...


Only top voted, non community-wiki answers of a minimum length are eligible