Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Grafana 2.0.x Dashboard data size #1863

Closed
joakimberglund opened this issue Apr 23, 2015 · 1 comment
Closed

Grafana 2.0.x Dashboard data size #1863

joakimberglund opened this issue Apr 23, 2015 · 1 comment
Labels
Milestone

Comments

@joakimberglund
Copy link

I ran into a problem with data size of a dashboard (stored in mysql).

If you add a template that is quite large it's very easy to exceed the max size of the data column in the database, thus totaly corrupting that dashboard. (max size 64k)

I "solved" that by doing the following. "alter table dashboard modify data mediumtext not null;"
But I havn't checked if that affects something else.. it looks like it works though.

echo "select * from dashboard where id=23;" | mysql -u --password= grafana | wc
2 80 112406

@torkelo torkelo added this to the 2.0.3 milestone Apr 23, 2015
@torkelo
Copy link
Member

torkelo commented Apr 23, 2015

thanks for reporting this! changed the type, and added a sql migration step that will change the type on next server startup (will not do anything for your db as you have already changed the data type)

johann8384 added a commit to johann8384/grafana that referenced this issue Jul 9, 2015
* v2.0.x: (1178 commits)
  New direct query text box Add a brand new opentsdb M panel Create new module and controller for opentsdbM Add a drop down to select function Change some style for textbox Add opentsdb M function explanations
  Create pid file before runtime init, Fixes grafana#1990
  Fixed XSS issue with file based dashboards, was really casued by an issue with alertSrv accepting html in message alerts
  fixed version in package.json
  Updated config sample.ini with oauth allow_sign_up
  Corrected SQL migration for snapshot table column type change, grafana#1880
  fixes grafana#1880 dashboard_snapshot table does not have a data column
  fixes grafana#1880 correct mysql statement for modifying column data type
  updated version to 2.1.0-pre1
  Replaced slug dependency with one that did not use gopkgs.com
  Firefox/IE issue, invisible text in dashboard search fixed, Fixes grafana#1872
  Added units for voltage, current and frequency
  Documented units for timepicker
  Restored sql integration tests to use in mem sqlite3
  MySQL: Dashboard.data column type changed to mediumtext (sql migration added), Fixes grafana#1863
  Fix and update documents
  /api/login/ping Fix for issue when behind reverse proxy and subpath, Fixes grafana#1857
  Remove exit 0 at the end of init.d script
  Updated install docs with 2.0.2 version
  updated changelog
  ...

Conflicts:
	public/app/panels/graph/module.js
	public/app/plugins/datasource/opentsdb/datasource.js
	src/app/controllers/all.js
	src/app/partials/graphite/editor.html
	src/app/partials/opentsdb/editor.html
	src/app/services/datasourceSrv.js
	src/app/services/panelSrv.js
	src/css/less/grafana.less
	src/css/less/panel.less
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants