Three views offer Google charts URL generation: sv_report_chart_sample, sv_report_chart_hour, sv_report_chart_day.
Not all variables and metrics are presented with charts. The above views only consider those most popular, which are worth being visually presented. Those which are presented, are presented in all three views in the same format.
Each view only utilizes last 256 values for each metric. For example, the DML column in all three views lists up to last 256 values per view. This would mean:
- Last 256 samples on sv_report_chart_sample (about 21 hours when samples are taken every 5 minutes)
- Last 256 hours on sv_report_chart_hour (about 10 and a half hours of aggregated data)
- Last 256 days on sv_report_chart_day
To generate a Google chart URL, simply query:
mysql> SELECT DML FROM sv_report_chart_hour \G *************************** 1. row *************************** DML: http://chart.apis.google.com/chart?cht=lc&chs=400x200&chts=303030,12&chtt=Oct+28,+20:00++-++Nov+8,+11:00+(10+days,+15+hours)&chdl=com_select_psec|com_insert_psec|com_delete_psec|com_update_psec|com_replace_psec&chdlp=b&chco=ff8c00,4682b4,9acd32,dc143c,9932cc&chd=s:5745njlllklmnoprstuvzz113334npkklklkmmooqrstvuwxzyzzlhihiiijjijkklmnoopqsstugefegeghjikknoprtvxx0y11lijjkikjmlnpqqstvvyz1124lijikijilkmnoqsuxu103354njkklkmlnnooqrssxy0z2245kikikjkkllnprrttxwzy1033kijikjkjlkkmpnrqttvwywyyjghfighhihijkklmpopqsstuifggigihkjlm,WXXX8bWUUTSUWYXWVWWXXWYYaaYY0oUUVUVVVYXWYWVWXWWWVXXV5XWVVVSTSTTTSTTWUUVVUUUUWSVTTUVUVVWWWWVWXXXWXYWVVTVYVSSUUVWWWWWWZYZYcZXXaWWWVUTUVWXVVYZbbXaYYXXWbUYZXVTWVWWVVVZZZZZXXXWWaUTSSSTTTVYZbbZXYZcYYXYXcUUVXYUVVWVXWUUVWVWVXWUTXRSSSQUTSSSUSSSVWVTTUWVTbSTSSTSSUUXX,KLLKxNIJHGHJJJJLJLJKJLKKLKLLmcJIHHJILKKKJKKKKKKLLKKMuLHGGIHHLIKMJJNKJJIJJJIIKJHHHIHIJKJJIIJKJIJJKJIKLIIHKHHLLKJLJKJJJKJJKJJKNJJHJHINNKKJJJIIIHIIIIIIOKIIHIIJKKJJJJIIKJKLKJLKQJHGHGHIKKKKKKKKLLKKKLPKSKKHHIIIKKJKKKKKJKKLQKKLOIGGHFFIJJILJKNJJJKJJJKJSJHGGGIJJIIJ,HIIHJHHHHHHHIIIIHIHHIIIIIIIHJHIHHHHIHIHIHIIHIIHIHHHHJHHHHHHHHHHHGHHHHHGHHHGGIGGGGGHHHHHHHHHHHHHHIHHHJHHHHHHHHHHHHHHHIHIIIIHHJHHHHHHHHHHHHHHHIHIIIIIHJHHHHHHHIIHHHHHHHIIHHHHHJHHHHHHHHHIIIIIHHIIIIIIIJHHHHHHHIIHHIHHHHHIHHHHHIHGGHHHHHHGGGGGHHHHHHHHHIGGGGHHHHHGH,&chxt=x,y&chxr=1,0,138.88&chxl=0:||Oct+30,+23:00|Nov+2,+02:00|Nov+4,+05:00|Nov+6,+08:00|&chxs=0,505050,10
The above results in the following chart:
In the above chart, the peaks are full days. Looking in more detail at recent hours:
mysql> SELECT DML FROM sv_report_chart_sample \G *************************** 1. row *************************** DML: http://chart.apis.google.com/chart?cht=lc&chs=400x200&chts=303030,12&chtt=Nov+7,+14:40++-++Nov+8,+11:55+(0+days,+21+hours)&chdl=com_select_psec|com_insert_psec|com_delete_psec|com_update_psec|com_replace_psec&chdlp=b&chco=ff8c00,4682b4,9acd32,dc143c,9932cc&chd=s:cjffahckgfakYkiecnfniffjgijgXnghlfbpckndcnenifenhimganhjofeqbljjhlojogdrlfphgknjnggnljnmhkpjtghpljtjfiqnreonoluikhYZgVbeYbgVbXaaZWbZZaeYYcZceVaYcbcYcXaYdZYccVfXecbdeWcZfbabaYfXbaZbfYbadZgbaaaZjcXfbYhZZfYahZadhZicXhaXnbZgcajWefabkccdcbncadbfgeejZkfeidZhjgfi,NSSNPWQVUOQSOTUOOVRXUPTUQUVNPVPTSNPTPTULNVPURLPSORSLNUPUUKOSNSSLNTRRTKPTPQVOSVRSVMPTQUVNOTSRWMOUPSVLNRQTUKOSPPWLNhSs8MORMPUJNSNOTIOQPSVLNUPRVKOQOPVLNTOQTONRNNTIOSNRTJOQPPRNOSOPQONQQQSMPSPOONLPNOOPNQOQPPMPOOOOOSSRQRQRRPQQRSPNRQOSQSORMWWUSUSVRRVUSXUSTRLWTSTV,GIIJFKHMHIFJFIIIFKHJHGGIGIJIFKGIIIGHGKJGHKGJIHHIHIJHGKGIIIFHGHIIHLHHHHGIGHIHHLHGGIHHHJHHINHFGHIJHHIIFHHGIIHIHIHHHXKlvKHHFHHHFHGHHJIGFIKFEGHHGFEFEFGEDGFEIGEGEGEFDFGGGEDGEEEEDFEEHHDEEEHFDGFOQFDFEDFGFQGGFGFFFHLJFGHHHJHHHGIHGHFEHIGHHHHGEHHFGHGIGFHHGKIGIGEIIFJH,EHGEEHEHGEFFEGHEEHFHHDFGFHHDFHFHHEFGFHHDEIEHHDFGFGHDEHFHIDEGEGHDEHFGIDEGFFIDEHGFIDEGFGIDEHGFIDEGFGIDEGGGIDEGFFIDEHUFIDEGEFIDEGEFHCEFEFIDEHEFIDEFEFHDEGEFGEEGEFICEHEHIDEFEFGFFHFFGFEGFGGEFHFGFFEGFFFGFGGFFGEFFFFGFHGFFGEGFFFGFGFEFGEGFGFGDGGGFGEFEEFGEHGFFGDGFFGG,&chxt=x,y&chxr=1,0,168.81&chxl=0:||Nov+7,+18:55|Nov+7,+23:10|Nov+8,+03:25|Nov+8,+07:40|&chxs=0,505050,10
The above translates to the following image:
Available charts
In order to detect the available charts, issue:
mysql> DESC sv_report_chart_sample; +------------------------------------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------------------------------+----------+------+-----+---------+-------+ | uptime_percent | longblob | YES | | NULL | | | innodb_read_hit_percent | longblob | YES | | NULL | | | innodb_io | longblob | YES | | NULL | | | innodb_buffer_pool_used_percent | longblob | YES | | NULL | | | innodb_estimated_log_mb_written_per_hour | longblob | YES | | NULL | | | innodb_row_lock_waits_psec | longblob | YES | | NULL | | | bytes_io | longblob | YES | | NULL | | | myisam_key_buffer_used_percent | longblob | YES | | NULL | | | myisam_key_hit_ratio | longblob | YES | | NULL | | | DML | longblob | YES | | NULL | | | questions | longblob | YES | | NULL | | | tmp_tables | longblob | YES | | NULL | | | table_locks_waited_psec | longblob | YES | | NULL | | | table_cache_use | longblob | YES | | NULL | | | opened_tables_psec | longblob | YES | | NULL | | | connections_psec | longblob | YES | | NULL | | | connections_usage | longblob | YES | | NULL | | | thread_cache_used_percent | longblob | YES | | NULL | | | threads_created_psec | longblob | YES | | NULL | | | relay_log_used_mb | longblob | YES | | NULL | | | seconds_behind_master | longblob | YES | | NULL | | | seconds_behind_master_psec | longblob | YES | | NULL | | | estimated_slave_catchup_seconds | longblob | YES | | NULL | | | os_cpu_utilization_percent | longblob | YES | | NULL | | | os_loadavg | longblob | YES | | NULL | | | os_memory | longblob | YES | | NULL | | +------------------------------------------+----------+------+-----+---------+-------+
The list may change in time.
Modifying chart size
Chart size is by default 400×200 pixels. There are two ways to change these settings:
- When running mycheckpoint deploy, it is possible to specify other dimensions. See Usage page.
- Manually updating table data:
UPDATE charts_api SET chart_width=500, chart_height=360
Aggregating chart data
The sv_report_html view aggregates charts into one HTML report file. See Generating html reports.
Google charts
Do take note that by using a Google Charts URL you are sending data to Google. If this concerns you, or you are unable to download images from Google due to firewall settings, you may try other charting solutions, which support the Google Charts API. See JFree’s Eastwood, for example.
To update the charts API, issue an UPDATE query. For example:
UPDATE charts_api SET service_url = 'http://localhost/eastwood/chart'