mysqlcentosmunin
How to detect what is running on MySQL every hour?
Munin showing huge spike on MySQL queries every hour but I am unable to detect what is causing this. I am running version 5.6.30.
- Tried to enable slow running queries but can't find it there.
- Also logged all queries and tried to see what is running on that particular time. I cannot find it.
- Checked cronjobs but there wasn't anything related
- Disabled almost everything on LFD & CSF
- The event scheduler status is set to OFF
Is there any other way to find what is running every hour?
Munin graph showing sql queries:
Solution
Some crawlers were mining data from my website. I wasn't able to detect because requests sent from a million different IPs.
Added captcha to website as human control and spikes gone.
- How do I retrieve results as multidimensional array from mySQL and PHP?
- Splitting a single column (name) into two (forename, surname) in SQL
- xampp MySQL does not start
- follower/following relationship
- How to fetch products by by parent tags?
- How to group 2 table records with added column details
- AND IF using variable in WHERE CLAUSE
- MySQL storing boolean - 1, 0 , or NULL
- MySQL Query to Bulk Delete Spam Wordpress Users
- How to solve General error: 2006 MySQL server has gone away
- MySQL docker container stuck reloading
- BIT(1) or TINYINT for flags in MySQL
- Using JdbcTemplate to Insert a UUID into a MySQL 8 Table
- How to validate expiry date on MySQL query
- docker mysql with Error: connect ECONNREFUSED
- SQL ZOO List each continent and the name of the country that comes first alphabetically
- How to include a PHP variable inside a MySQL statement
- How to store image files in the backend of a site
- Compare last values of two columns in SQL table to Create Grafana Alerts Condition
- Enable binary mode while restoring a Database from an SQL dump
- What is the best way to insert JSON into MySql in a Wordpress PHP function?
- How can I merge two MySQL tables?
- How to allow SELECT queries and prevent others?
- there can be only one auto column and it must be defined as a key
- Illegal mix of collations in stored procedure
- How do I use Liquibase to import a stored procedure into MySQL?
- How to get rid of MySQL error 'Prepared statement needs to be re-prepared'
- Server quit without running PID file when trying to start MySQL server?
- Get data from 3 tables using single query
- Conflict with pulling information from database into html columns with three SQL queries