MySQL Forums
Forum List  »  PHP

"Error" randomly appearing on page loads
Posted by: Robert Tee
Date: March 05, 2019 12:17PM

Hello,


I have an issue where when I load a page on a site it returns "Error" (the default message when my cms cannot access it's DB or MySQL is not available) A subsequent page load is fine. There are no errors logged in mysql_error.log. I know this is an issue with MySQL though. What can I do or capture to understand what is causing this to happen? I already enabled mysql slow query log for days and there aren't any slow querys.


This happens maybe every 50 - 60 page clicks/loads so it's hard to capture it in real time.

MySQL Version: 5.7.23
Instances: 1
Databases: 24

Customization in my.cnf:

table_open_cache = 950
max_connections = 500
tmp_table_size = 10G
max_heap_table_size = 10G
connect_timeout = 100
interactive_timeout = 300
wait_timeout = 300

Options: ReplyQuote


Subject
Written By
Posted
"Error" randomly appearing on page loads
March 05, 2019 12:17PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.