CODEWITHSUNDEEP
phpmysqlserverphpmyadmin
Varun Haridas
Varun Haridas

Reputation: 77

Server going offline randomly - Problem with MySQL various alerts in phpMyAdmin

Webapp goes offline randomly, the offline time is less than 2minutes. (Because the downtime checker intervals are set for 2 min test and it isn't reporting this). But users are complaining about unavailability.

Getting various alerts in phpMyadmin doubts this is something related to a MySQL connection drop.

Here are the alerts that are displayed in phpmyadmin: Alerts from phpMyadmin

Configuration.

Upvotes: 0

Views: 301

Answers (1)

fabrik
fabrik

Reputation: 14365

Looking these values it seems your tables aren't indexed (properly). Without knowing enough about your application my best bet would be:

  • Restart MySQL server (this is a must)
  • Monitor these values after restart
  • Enable and examine slow query logs, thus identifying queries causing these issues
  • Run EXPLAIN on these queries and try to introduce proper indices

Upvotes: 1

Related Questions