could use your help in understanding this. I'm running an RDS MySQL instance (db.m3.large on SSD) with 100GB of storage.
I'm a little freaked out that my memory is 50% there:
chart http://f.cl.ly/items/2130242A0K040E392h0L/10.png
I must be doing something wrong, because the server is not heavily used at all at this point. Here's the graph for the last 2 weeks:
2 week usage chart http://f.cl.ly/items/2y411W0z0I1V1T0T3O3T/11.png
As you can see, CPU is mostly at 0%, DB connections are low, write/read ops are low too.
I do run all InnoDB tables. The only thing that comes to mind (that could've increased memory so high) is my analytics feature. I have one table (sharded) which stores daily summary of analytics computations. That table has 4 mediumtext
fields, so I've changed InnoDB to use Barracuda file format for that table (that way I can have row_format=compressed
). That's the only DB parameter that's not default for that instance (everything else is out of the box).
I don't even have many rows in that table and the largest row is at maybe 35kb max for now. There's 56 rows for the biggest client (I don't have many clients either). So it's surprising to me that this is what could be causing that...
Could you give me any insight into why my memory could be so high (aka what I messed up)? Is it because MySQL caches my analytics queries/results? Or is it something else?