Damien Norris damienvancouver
damienvancouver
/ gist:6025136
Created
July 17, 2013 22:31
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -------- Storage Engine Statistics ------------------------------------------- | |
| [--] Status: -Archive -BDB -Federated +InnoDB -ISAM -NDBCluster | |
| [--] Data in MyISAM tables: 0B (Tables: 9) | |
| [--] Data in InnoDB tables: 11G (Tables: 1411) | |
| [!!] Total fragmented tables: 173 | |
| -------- Performance Metrics ------------------------------------------------- | |
| [--] Up for: 30d 8h 1m 47s (61M q [23.355 qps], 151K conn, TX: 153B, RX: 20B) | |
| [--] Reads / Writes: 40% / 60% | |
| [--] Total buffers: 442.0M global + 12.4M per thread (151 max threads) |
damienvancouver
/ gist:4261322
Created
December 11, 2012 19:29
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| mysql> select fid, uid, filename, uri,type, from_unixtime(timestamp) from file_managed where uri like 'private:///%' order by fid desc; | |
| +------+-----+------------------------------------------------+-----------------------------------------------------------+-------------+--------------------------+ | |
| | fid | uid | filename | uri | type | from_unixtime(timestamp) | | |
| +------+-----+------------------------------------------------+-----------------------------------------------------------+-------------+--------------------------+ | |
| | 9479 | 8 | 9637444.zip | private:///9637444.zip | application | 2012-12-11 09:10:50 | | |
| | 9476 | 1 | 8014436_1(1)(1).zip | private:///8014436_1(1)(1).zip | application | 2012-12-10 21:45:06 | | |
| | 9474 | 8 | 9637454.zip | |
NewerOlder