Uri wrote: > Dear All, > I have a setup where R pulls entries from a MySQL db server. I wanted > to know whether the R interface can pull encrypted / compressed data > from MySQLD. MySQL supports compressed communication on the server > side, but I couldn't find any references to such options on the client > (RMySQL) side.
Right, this is not properly documented (buried in ?mysqlNewConnection). You can simply add the argumet client.flag = 32 to dbConnect(), e.g., con <- dbConnect(MySQL(), ..., client.flag=32) The number 32 comes from the mysql_com.h version 4.1.17 header file #define CLIENT_COMPRESS 32 /* Can use compression protocol */ I'd be curious to know whether you find compressed connections significantly faster over raw connections. Hope this helps, -- David > > Best, > Uri Hasson. > --- > Uri Hasson. > Brain Research Imaging Center > The University of Chicago. > > ______________________________________________ > [email protected] mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html ______________________________________________ [email protected] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
