search

SunshineYang / mycheckpoint

Automatically exported from code.google.com/p/mycheckpoint
0 stars 1 forks source link

generate a too long google chart URL #5

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. take a sample every 2 minutes
2. the chart can not display
3. The google chart return the error "The requested URL /chart... is too 
large to process."

What version of the mycheckpoint are you using?
revision 76

What version of the MySQL are you using?
MySQL-5.1.41

On what operating system?
CentOS 5.3

Please provide any additional information below.
the chart URL:
http://chart.apis.google.com/chart?
cht=lc&chs=400x200&chts=303030,12&chtt=Latest+13+hours:+Jan+11,+00:19++-
++Jan+11,+13:08&chdl=com_select_psec|com_insert_psec|com_delete_psec|com_up
date_psec|com_replace_psec&chdlp=b&chco=ff8c00,4682b4,9acd32,dc143c,9932cc&
chd=s:NMMLLLLKJJIHHHHGGGGGGGFFFFFFFFFEFFFFFEEEEEEEEFEEDDDEDDDDDDEDDDDDDDDDD
DDDDDDCDCDDDDCCDDCCDCCCCCCCCDCCCCDCCCCCCCCCCCCCCCCCDCCCCCDCCCCCCDCCDCDDDDDD
DDDDDDDDDEEEEEEEFFFFFFGGFFGGGGGHHHHHHHHIIHIIJJJJJKJKKKKKKLJLMLMMMNNONOOPQRR
SSSSUUUUVVVVWWWYYXYYYZYYZdihhhheeedcccbcbZZZadbbZYYZbaaZZZaZYZZYZZZYZZZZYYY
ZZYYYYYXZaYZYYXXXYYYYZYXXYYYZXXXXXYYYYXZZYYZYZZXYaZYZYZZaZYYaaaaaaZZaZZZZZ,
DDDCCCCCCCCBCBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBABBBBABA
ABBBBBBABBBAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABAAAAAAAAAABBAAAAAAAAAB
BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBCCCCCCCCCCCCCCCCCCCCCCCCDCDDDDDDDDDDDEEEEEEEE
FEFFFFFFFFFFGFGFFFGIJIIIIHHHHHHHGHGGGGGHGGGGFGGGGGFGGFFFGFFFFFFFFGFFFFFFFFF
FFFFFFFFFFFFFFFFFFFFFFFFFEFEFFFFFFFFFFFFFFFFFFFFFFFFFFGFFFFFFFFFFFFF,AAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA,aaZWVWVUSRQO
PNONNMMMMNMLLKKLLMKJKJJJJIJIJIIJJLJIHHHHHGGHHHIHHGHHGHHHGGGHGGGFGFGHHGGGGFF
FFEDEFFFEFFFEFFFFEFEEEEEEEEEEEEFFFEEEFFGFFFFFFFFFFFFFGFFFGGGFFGFGHHHIIJJKKK
KKKKMMLLLLMNNONNOOPPPQQQPRSTSSSTSSUUTUVUSXWVYYYZYaZabccghhiiiklkkklnnoopssq
srssrruz97787310zyyzxxwutsuyvusrrsutututsssttstusqtrtrprtssqqrrqqtursrrpqpq
ssqtrqprrrsppopqrrrqpturqsrtsqpvtqsrsswssswuvwvxtuvtsttt,AAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA&chxt=x,y&chxr=1,0,3740.1
7&chxl=0:||||04:00||||08:00||||12:00||&chxs=0,505050,10&chg=7.81,25,1,2,5.3
4,0&chxp=0,5.34,13.15,20.96,28.77,36.58,44.39,52.20,60.01,67.82,75.63,83.44
,91.25,99.06

Original issue reported on code.google.com by bash...@gmail.com on 11 Jan 2010 at 7:12

GoogleCodeExporter commented 9 years ago 
Thank you.
Clearing up on bug's nature: a 2 minute sample results with a very long DML 
chart
URI. Google charts will only accept 2048 characters, which are exceeded (the 
rest of
the charts unaffected because only DML has that many different data lines).
Easiest solution right now is to only sample onc per 5 minutes (tested to work).

But this relates to yet another issue with charts which must be addressed: 
there is a
hidden assumption that the samples are taken in constant intervals; and gaps are
never presented in the charts. That is, the charts are not truly time-series 
charts,
though they may appear so. We ask google to evenly spread the x-values, even if 
it's
incorrect.

A proper solution is to force the chart into a true timeline series chart. 
Using the
obvious method (chart type = lxy) is out of the question, since this will 
increase
the URI size (almost double the length). But I have an idea for a different 
kind of
solution, which will be developed next.

Original comment by shlomi.n...@gmail.com on 12 Jan 2010 at 10:34

GoogleCodeExporter commented 9 years ago 
Thank you.
I'm look forward to the next release.   :-)

Original comment by bash...@gmail.com on 12 Jan 2010 at 10:51

GoogleCodeExporter commented 9 years ago 
Fixed in revision 77
See http://code.google.com/p/mycheckpoint/downloads/list

Sample-based charts are now displayed in 10 minute resolution (regardless of 
sample
frequency) and provide with true time-series axis.

Please verify this works for you and comment back.

Original comment by shlomi.n...@gmail.com on 16 Jan 2010 at 8:10

GoogleCodeExporter commented 9 years ago 
I have just tested the latest version, there is no problem. The charts shows 
normal,
regardless of sample frequency now.

Thanks again!

Original comment by bash...@gmail.com on 21 Jan 2010 at 11:13

GoogleCodeExporter commented 9 years ago 
Verified as fixed by reporter

Original comment by shlomi.n...@gmail.com on 21 Jan 2010 at 11:18