[rrd-developers] rrdtool + libdbi / mysql speed test
tobi at oetiker.ch
Tue Jan 8 14:09:52 CET 2013
Today Olivier Doucet wrote:
> Just a follow up on this :
> Problem is definitely in libdbi and the implementation of
> dbi_result_next_row(). This function is using mysql_data_seek() all
> the time to move from one row to another, which is very unefficient
> for mySQL. PostgreSQL backend does not have this problem.
> Unfortunately, we cannot fix this outside libdbi (we would need to
> call libmysql directly ...).
> A fix will be applied on libdbi in the next few days. I'll let you
> know when this is done. Then, I think a note in documentation about
> this will be very helpful for people who want to use MySQL backend
> (they should be aware of the speed issue, and how to solve it).
> The topic on libdbi mailing list can be seen here :
if you could send a pull request on github.com/oetiker/rrdtool-1.x
for any doc updates you see fit, I will be glad to integrate it ...
> rrd-developers mailing list
> rrd-developers at lists.oetiker.ch
Tobi Oetiker, OETIKER+PARTNER AG, Aarweg 15 CH-4600 Olten, Switzerland
http://it.oetiker.ch tobi at oetiker.ch ++41 62 775 9902 / sb: -9900
More information about the rrd-developers