Hardware and performance

Help with Windows Moodle Performance

 
Picture of J P
Help with Windows Moodle Performance
 

Hello,

This is my first year administering our Moodle site.  I am not a database guy but trying to learn as much as possible.  We have had a few hiccups this year but are working them out.  Right now is semester test time of course and are having quite a bit of slowness users not able to login.  Looking for help or things to look at on our MySQL database to see if everything is setup the way it should be or if there are some tweaks that could help.  Trying to find where the bottleneck is if there is one.  I am using MySQL Workbench to monitor our MYSQL server.  It seems once we reach above 300 client connections it starts getting slow.  Server resources are 92-100%CPU and using around 68GB of 320GB Memory when slow. Using about 30% of our internet connection.   We have anywhere from 3000 - 8000 logins per day with a little over 100 courses on it.

Information below:

All Moodle Data, Website, Database on this server:

Database and Website on same drive, Moodle Data folder on separate drive

Windows 2012 R2 64bit

MySQL 5.7.8

IIS 10

PHP 7.1.8

Processor - 2 Intel Xeon E5-2643 v3 3.40GHz

320GB Ram

Hard Drives - RAID 10 - 8TB 7.2K Drives ,  PHP is running on a single SSD drive.  Moodle and PHP cache are pointed to it as well.

Moodle 3.3.1+ Build 20170824

Some info from my.ini file (let me know if there are other values that would help to see)

max_connections = 800

query_cache_size=0

table_open_cache=2000

tmp_table_size=4G

thread_cache_size=10

innodb_flush_log_at_trx_commit=0

innodb_log_buffer_size = 16M

innodb_buffer_pool_size = 100G

innodb_thread_concurrency=4

innodb_autoextend_increment=64

innodb_buffer_pool_instances=8

PHP Info - (let me know if there are other values that would help to see)

memory_limit = 512M

mysqli.max_persistent = -1

mysqli.allow_persistent = Off

mysqli.cache_size = 2000

mysqli.max_links = -1


Any help would be very much appreciated!  

Thanks

 
Average of ratings: -
Picture of Chris Fryer
Re: Help with Windows Moodle Performance
Particularly helpful Moodlers

Are you running PHP OPCache? Would be interested to see those settings.

 
Average of ratings: -
Picture of J P
Re: Help with Windows Moodle Performance
 

We are currently not running OPCache.  In previous versions we were running WinCache and I was about to work on getting it going on this server once this semester is over (end of next week).  Thanks

 
Average of ratings: -