Re: [R] Rprof fails in combination with RMySQL

From: Thieme, Lutz <lutz.thieme_at_amd.com>
Date: Fri 22 Jul 2005 - 16:04:21 EST


Hello Bogdan,

thanks for you reply. My MySQL is always optimized oustide from R (but many thanks for the interesting link!). I'm very sure that I have to optimize the R code which uses the data from my queries for calculations. To get more information  which R function is the main speed limiter I tried Rprof.
Because I'm always opening and closing the connection for every query I have never opened more than one connection. And again: The same R code runs without Rprof stable since weeks multiple times a day. I can exclude by 99% that the error comes from the database. Maybe it comes from large number of opening closing cycles?...

Regards,

Lutz

> -----Original Message-----
> From: bogdan romocea [mailto:br44114@gmail.com]
> Sent: Thursday, July 21, 2005 5:05 PM
> To: Thieme, Lutz
> Cc: R-help@stat.math.ethz.ch
> Subject: RE: [R] Rprof fails in combination with RMySQL
>
>
> I think you're barking up the wrong tree. Optimize the MySQL code
> separately from optimizing the R code. A very nice reference about the
> former is http://highperformancemysql.com/. Also, if possible, do
> everything in MySQL.
> hth,
> b.
>
>
> > -----Original Message-----
> > From: Thieme, Lutz [mailto:lutz.thieme@amd.com]
> > Sent: Thursday, July 21, 2005 10:11 AM
> > To: Rhelp (E-mail)
> > Subject: [R] Rprof fails in combination with RMySQL
> >
> >
> > Dear R community,
> >
> > I tried to optimized my R code by using Rprof. In my R code
> > I'm using MySQL
> > database connections intensively. After a bunch of queries R
> > fails with the
> > following error message:
> > Error in .Call("RS_MySQL_newConnection", drvId, con.params,
> > groups, PACKAGE = .MySQLPkgName) :
> > RS-DBI driver: (could not connect mylogin@mydatabase
> > on dbname "myDB"
> >
> > Without the R profiler this code runs very stable since weeks.
> >
> > Do you have any ideas or suggestions?
> >
> > I tried the following R versions:
> > ___________________________
> > platform i386-pc-solaris2.8
> > arch i386
> > os solaris2.8
> > system i386, solaris2.8
> > status
> > major 1
> > minor 9.1
> > year 2004
> > month 06
> > day 21
> > language R
> > ___________________________
> > platform sparc-sun-solaris2.8
> > arch sparc
> > os solaris2.8
> > system sparc, solaris2.8
> > status
> > major 2
> > minor 1.1
> > year 2005
> > month 06
> > day 20
> > language R
> > ___________________________
> > platform sparc-sun-solaris2.8
> > arch sparc
> > os solaris2.8
> > system sparc, solaris2.8
> > status
> > major 1
> > minor 9.1
> > year 2004
> > month 06
> > day 21
> > language R
> >
> >
> > Thank you in advance and kind regards,
> >
> > Lutz Thieme
> > AMD Saxony/ Product Engineering AMD Saxony Limited
> > Liability Company & Co. KG
> > phone: + 49-351-277-4269 M/S E22-PE,
> > Wilschdorfer Landstr. 101
> > fax: + 49-351-277-9-4269 D-01109 Dresden, Germany
> >
> >
> > [[alternative HTML version deleted]]
> >
> > ______________________________________________
> > R-help@stat.math.ethz.ch mailing list
> > https://stat.ethz.ch/mailman/listinfo/r-help
> > PLEASE do read the posting guide!
> > http://www.R-project.org/posting-guide.html
> >
>
>



R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html Received on Fri Jul 22 16:09:48 2005

This archive was generated by hypermail 2.1.8 : Fri 03 Mar 2006 - 03:33:55 EST