Re: Memory usage increasing constantly

[Rick James]

( Select_scan ) = 9,551,157 / 171023 = 56 /sec -- full table scans
-- Add indexes / optimize queries (unless they are tiny tables)

( Select_scan / Com_select ) = 9,551,157 / 16223159 = 58.9% -- % of selects doing full table scan. (May be fooled by Stored Routines.)
-- Add indexes / optimize queries

( long_query_time ) = 10.000000 = 10 -- Cutoff (Seconds) for defining a "slow" query.
-- Suggest 2

( Aborted_clients / Connections ) = 237 / 670 = 35.4% -- Threads bumped due to timeout
-- Increase wait_timeout; be nice, use disconnect

( Threads_created / Connections ) = 282 / 670 = 42.1% -- Rapidity of process creation
-- Increase thread_cache_size (non-Windows)

Let's look at a few of the worst queries in the slowlog; with 320qps and such a sign Select_scan value, you may be generating a lot of tmp tables, thereby blowing out RAM.

We can probably help you change the queries and/or the schema to fix it. (Please provide SHOW CREATE TABLE for the table(s) in the slow queries.)