Описание картинки
Query select DATE_FORMAT(FROM_UNIXTIME(time_stamp),'%d'),round(sum(bytes_sent)/1024/1024,2) as mb from apache_logs.access_log where DATE_FORMAT(FROM_UNIXTIME(time_stamp),'%Y%m')='200907' GROUP by DATE_FORMAT(FROM_UNIXTIME(time_stamp),'%d'), Sun Jul 26 14:33:15 2009
Query select DATE_FORMAT(FROM_UNIXTIME(time_stamp),'%d'),round(sum(bytes_sent)/1024/1024,2) as mb from apache_logs.access_log where DATE_FORMAT(FROM_UNIXTIME(time_stamp),'%Y%m')='200907' GROUP by DATE_FORMAT(FROM_UNIXTIME(time_stamp),'%d'), Sun Jul 26 14:33:15 2009
DATE_FORMAT(FROM_UNIXTIME(time_stamp),'%d') | mb |
01 | 15977.46 |
02 | 16270.30 |
03 | 14303.71 |
04 | 4630.42 |
05 | 5122.16 |
06 | 5366.84 |
07 | 11227.75 |
08 | 8820.66 |
09 | 7163.43 |
10 | 6241.31 |
11 | 5392.17 |
12 | 7419.15 |
13 | 6840.60 |
14 | 5772.80 |
15 | 6020.50 |
16 | 6060.12 |
17 | 6736.49 |
18 | 5141.18 |
19 | 4368.00 |
20 | 5946.53 |
21 | 6256.60 |
22 | 6429.93 |
23 | 7846.18 |
24 | 5768.94 |
25 | 5512.70 |
26 | 2083.56 |