Was this on the shared server: Moodle Error 500 https://moodle.org/mod/forum/discuss.php?d=400066 ? Did you find out why?
And this escalation happened just after the upgrade yesterday?
Having 'too much fun', Howard?
2 cents ... both areas of Moodle bench relate to users and authentications ... so how are users authenticating?
Moodle is backended by DB server ... suggest, IF MySQL or MariaDB ... installation of MySQLTuner ...
https://github.com/major/MySQLTuner-perl
Does mdl_user table have any issues? Is the table and all the columns in that table match up with character set/collation (variable in config.php). How about mdl_log_store_standard_log ... the 'who done it' table?
Scripts in moodlecode/admin/cli/ will help check DB.
'SoS', Ken
I take it PM has to do with MySQLTuner? which is NOT a Moodle plugin but an operating system thang. You probably have an icon for something like MySQL Bench in cPanel ... but that's not near as good as Tuner.
Do you have a Terminal icon in your cPanel?
Hostgater? Hmmm ... guess they don't think you will ever need to tweak your DB's.... too bad!
'SoS', Ken
More than likely, but dunno for sure, when you click the terminal icon a new browser window will appear and in it a 'termanal' shell.
Has a prompt like 'accountlogin>'
And at the prompt one can type commands.
Try some for info purposes:
whoami [ENTER]
pwd [ENTER]
Biggy:
sudo -s [ENTER]
You will be prompted to provide the password of the account. Successfully entering that, prompt should change to:
root:>
which means you should have no trouble installing MySQL Tuner.
To exit sudo and terminal, type:
exit [ENTER]
with sudo have to do that twice:
exit [ENTER]
'SoS', Ken
This is a powerful dedicated server - 8 Core / 16 Thread Intel Xeon-D CPU, 30 GB RAM, 1 TB SSD, Unmetered Bandwidth (https://www.hostgator.com/dedicated-server -> Enterprise) - still extremely slow even with the 200 users per day! So something is extremely wrong.
Sorry to say this, but from your approach, and the fact that you want Cpanel instructions, you are unfamiliar with the Unix Shell and avoid it. Remember, this is a dedicated server, the hoster can't restore the system. What if you do more damage and lose the whole system? For me the risk it too high and too much of a responsibility. I'm glad that I haven't given any specific instructions here, if there are, please ignore them!
Just tryin' to cover all the bases! Haven't seen a moodle server yet that couldn't benefit from DB tweaks ... minor as they might be!
'SoS', Ken
Not too sure what to look for under MySQL tuner but i see the pic below suggesting that the maximum memory usage is dangerously high
Did you run tuner with superuser for DB credentials? The DB user in your config.php of Moodle may not have same privs.
That's unusual ... normally, Tuner finds MySQL/MariaDB could/should use more!
So get into the terminal again and type: top [ENTER]
At the 'top' of 'top', it shows memory.
What does that look like?
Also, further up in Tuner output there is a 'Performance Metrics' section.
Maximum reached memory usage
Maximum possible memory usage
There is a section on InnoDB Metrics
InnoDB buffer pool / data size
InnoDB buffer pool instances
'SoS', Ken
Now that you know you have terminal access to server, there are some command line only php scripts in moodlecode/admin/cli/ that are specifically for MySQL/MariaDB.
Issuing them with no switches brings up help:
php mysql_compressed_rows.php
For info:
php mysql_compressed_rows.php -i
Database version: 5.7.30
Database name: moodle
Database engine: InnoDB
innodb_file_per_table: ON
innodb_file_format: Barracuda
BTW, mysql did have an update recently bringing version to 5.7.30
php mysql_collation.php -l
will list all tables and columns in those tables collations and end with a summation - all tables should have collation that matches what's in config.php for site.
Of interest/attention would be mdl_users and mdl_logstore_standard_log.
Either of those are related to what is shown as a performance issue in bench.
'SoS', Ken
php mysql_collation.php -l
I don't see any info on collation in the config.php. Is it ok with you @Ken I send you the log details so you can check it .
config-diet.php file for a 3.8.highest version of moodle has this in
$CFG->dboptions = array(
.... other settings here do not use this line ....
'dbcollation' => 'utf8mb4_unicode_ci', // MySQL has partial and full UTF-8
// support. If you wish to use partial UTF-8
// (three bytes) then set this option to
// 'utf8_unicode_ci', otherwise this option
// can be removed for MySQL (by default it will
// use 'utf8mb4_unicode_ci'. This option should
// be removed for all other databases.
Using:
php mysql_collation.php -a
You should see utf8mb4_general_ci listed as well as
one that is 'default':
utf8mb4_unicode_ci (default)
Tuner
InnoDB buffer pool is 128M ... data is 3.5G
Highest usage of available connections ... default is 151
IF you ever have many students in taking a quiz at one time
150 could come into play ...
DB server on same box as Apache/php-fpm is somewhat a balancing act.
DB performs better if it can use more memory ... but not overly so
that fewer php-fpm's can launch to handle user request of site.
In my.cnf (config file for MySQL) for your server and tuner output,
the following:
skip-name-resolve=1
innodb_buffer_pool_size=3.5G
innodb_buffer_pool_instances=3
restart mysql and check for errors
'SoS', Ken
Both of those settings were not present in my.cnf file.
In that file you might have sections like [mysqld] and all setting under that apply to server. Below might be [mysqlclient] and all settings below that apply to clients.
So you can't add those lines just anywhere in my.cnf
The issue with sudoers ... that probably correct ... user you login with in cPanel is also the user of the terminal shell. Providers often do not provide to customers superuser creds to DB server. But they are there ... have to be.
Don't know how GoDaddy does that ... so contact GoDaddy Tech support.
Think you *might* have to tweak your web server/php-fmp settings to launch fewer copies to make sure we have a balance of memory usage.
While tech support if fixing access to my.cnf for ya, may as well ask about those settings as well.
'SoS', Ken
As a matter of security, the shell root user and password is not the same as superuser in DB. DB superuser might say 'root' but that's not really the shell root user and not the same password either.
Again ... *** contact GoDaddy Helpdesk ***.
'SoS', Ken
Were you able to get any help from GoDaddy Technical on superuser credentials for DB server on your dedicated to you only VPS?
You've reported server is faster now, but without the last steps server is still not as optimal as it could be and if usage/users increase, you might slide back into 'slow'.
'SoS', Ken
You should be able to copy text clips of log to clipboard, paste into Notepad or Textedit on your local machine. Then come back here to paste those clips. I don't want to be sent what could be a Gig or more log file. Am sure you can understand why! :_
'SoS', Ken
This can't be a dedicated server! Moodle BenchMark doesn't say anything about scalability, but when it finds an error, you have to take it seriously.
So the story is, you had a shared server hitting the limits, migrated to a dedicated server 1 two weeks ago, still "insufficient", migrated to dedicated server 2 two days ago. This is the result? Talk to the hosting provider.
N.B. What are these "snapboard" screen-shots? Why can't you upload them here? Are you sure the visitors will find those images tomorrow? (A forum is a knowledge base, which others access - not only for today!)
My apology on the use of snapboard, I didnt think of the visitors, will definitely load them here next time. Let try to tuner MySQL and if no improvement then I can talk to the host.
Where is the database? Could this be a database issue?
Theme designer is off, as for the log, their advert says no limit on the bandwidth but let me look up and see if I can see the logs
Do you have a WAF (web application firewall) now that you did not have before? A WAF would watch all request to server but, would think, especially with login. Are your students using smartphones more than before? (webservices turned on, I assume)
'SoS', Ken
Does 'sitelock' keep logs?
Check them out.
Mox nix if you had it before or not ... that was then ... this is now! ;)
'SoS', Ken
This one is a local browser error. Not Moodle.
'SoS', Ken
So we've come full circle. Error screen isn't coming from Moodle thus not reaching Moodle. Sent you a PM. Please respond to that.
'SoS', Ken
