How to view MySQL error logs?
My server load is spiking up pretty high and I'm seeing in the "Process Manager" in WHM that a lot of the CPU usage is being used to write to the MySQL error log as shown below:
/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/my.server.name.err --pid-file=/var/lib/mysql/my.server.name.pid
Can anyone explain or link to a source for a complete beginner that will allow me to view the error log?
I tried downloading it to my computer using the file explorer that comes with CSF/LFD but it's unreadable in notepad (the characters are all weird symbols).
Any help is greatly appreciated.
Thank you!