Comments on: Bash script: report largest InnoDB files https://shlomi-noach.github.io/blog/mysql/bash-script-report-largest-innodb-files Blog by Shlomi Noach Tue, 06 Jan 2015 09:47:44 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: shlomi https://shlomi-noach.github.io/blog/mysql/bash-script-report-largest-innodb-files/comment-page-1#comment-301835 Tue, 06 Jan 2015 09:47:44 +0000 https://shlomi-noach.github.io/blog/?p=6682#comment-301835 An updated version of this script, which also looks at MyISAM and ARCHIVE engine: https://gist.github.com/shlomi-noach/59c1e8624052cc8c255f

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/bash-script-report-largest-innodb-files/comment-page-1#comment-226500 Thu, 19 Dec 2013 11:18:20 +0000 https://shlomi-noach.github.io/blog/?p=6682#comment-226500 Hi Art,

We’re running this once per hour. I guess once per day is also fine; the more immediate catastrophes are caught by other, simpler metrics.

For completion, here’s how we push into graphite:

unixtime=$(date +%s)
mysql_env=oltp # we have multiple MySQL environments; e.g. OLTP, OLAP etc.
echo "data.mysql.$mysql_env.mysql_stats.$table_schema.$table_name.size_bytes $file_size $unixtime" | nc -w 1 our.graphite.server.com 2003
]]> By: Art van Scheppingen https://shlomi-noach.github.io/blog/mysql/bash-script-report-largest-innodb-files/comment-page-1#comment-226495 Thu, 19 Dec 2013 10:30:47 +0000 https://shlomi-noach.github.io/blog/?p=6682#comment-226495 Nice one Shlomi!
I’m already trying to wrap this script inside our environment and send the stats off through graphite.
How frequent are you running this script? Once a day? Or multiple times per day?

]]>