[rrd-developers] rrdtool + libdbi / mysql speed test

[Tobias Oetiker]

Hi Olivier,

Today Olivier Doucet wrote:

> Hello,
>
> 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 :
> http://sourceforge.net/mailarchive/message.php?msg_id=30320894

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 ...

cheers
tobi
>
> Olivier
>
> _______________________________________________
> rrd-developers mailing list
> rrd-developers at lists.oetiker.ch
> https://lists.oetiker.ch/cgi-bin/listinfo/rrd-developers
>
>

-- 
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