MySQL slow.log file growing

Do you have another MySQL service (or other database) running?  Does the log show any other information, such as connection status or query?

We only have MySQL running but with multiple databases. It logs the full query also but no connection status.

Thanks!

Are the queries something you would expect from your application?  Have you analyzed any of the queries in the log?

What is the value of the log_queries_not_using_indexes variable?

arent you missing '=' signs between the settings?....

slow_query_log =   OFF
slow_query_log_file =   MRBURNS-slow.log #(our slow.log file isn't even called this)
long_query_time   = 100.000000

Also check if the option /* SQL_NO_CACHE */ has been specified... seems to  log a lot of entries as well.

for me slow query log is not open all the time, so I think you check with lsof if you can truncate it.
(plus note by noci that you log all queries in reality)

Sorry, busy few days..

log_queries_not_using_indexes is set to off

The logs do appear to be just every query from the web server when updating and puling info from the SQL DB's. Heres an example

# User@Host: user[user] @  [10.10.10.11]
# Query_time: 0.006652  Lock_time: 0.000031 Rows_sent: 0  Rows_examined: 6523
SET timestamp=1443864887;
UPDATE app0stats_views SET viewcount = viewcount+1 WHERE viewdate >= '2015-10-01' && viewdate <= '2015-10-31' && objectType = 'Page' && objectID = '1';

I've even tried manually setting the long_query_time variables directly to SQL whilst its running so that the values are set really high but it still logs away.

Thanks

If your my.cnf is without equal signs to set configuration values it is not parsed correctly.
Can you post your my.cnf ?

and are the slow log settings under the [mysqld] tag?

What about your general log?  Is it running, and where does it go?

Sorry guys, please see our my.cnf attached. You'll see that the slow log settings are under the [mysqld] tag.

The general log is set to OFF at the moment.

Still struggling to find out what it is, currently turning the log regularly as an intermediate solution.

Thanks
my.txt

Why dont you go with default slow log parameters for start?

I think when it was originally setup we used a guide for MySQL config. I'll look for a default config and try that with the logs, I didn't think the logging was too much from standard.

I'll do that over the next couple of days and restart MySQL one night.

Just make it enabled and specify file, and leave rest of threshold settings commented.