[R-sig-DB] Installing RMySQL under CentOS 5.5 version of Linux?

[Spencer Graves]

       Thanks very much to Tomoaki, Dirk, Jeremy, Sean, Jack, and all 
who responded to my earlier questions.  I fixed the CentOS problems by 
replacing it with Fedora.


       Now I have a different problem:  I'm trying to load just over 35 
MB per day, 1 GB per month, into a MySQL database, and the time to load 
a file of 5 one-second observation is roughly 0.1*N^(1/6) seconds, where 
N = the cumulative number of files loaded to that point.  Since 2^(1/6) 
= 1.12, each time the size of the database doubles, the time to load an 
observation (or a file) increases by 12 percent.  The load time started 
at 90 ms per file.  Now it's closer to 1 second per file.  The size of 
the file will double roughly 6 more times before I'm done with this 
project, by which time the load time will be closer to 2 seconds per 
file -- if something else doesn't break before then.  I don't think the 
problem is with R, because I've restarted R several times, and the total 
memory in use has not gone much over 400 MB = 12 percent of the 3.2 GB 
available on this computer;  it's running nothing else at the moment.


       Is it normal for the load time to increase with the size of the 
table like this?  Should I specify an index for each table?  I did not.  
I understood from the documentation that it would take the first 
variable as the index under certain circumstances.


       Is this peculiar to MySQL?  Might I have the same problem with 
postgreSQL?


       What do people usually do to work around problems like this?


       Thanks for your help.
       Best Wishes,
       Spencer


On 10/26/2010 7:13 PM, Tomoaki NISHIYAMA wrote:
> Hi,
>
> Did you install mysql-devel package?
> On CentOS
> # yum install mysql-devel
> as root. That should install the library and headers required for
> MySQL client development.
>
> Provided R is well installed as user application
> just
> $ R CMD INSTALL RMySQL_0.7-5.tar.gz
> after downloading works.
> If it is common application, perhaps you need to
> do it as root again.
> -- Tomoaki NISHIYAMA
>
> Advanced Science Research Center,
> Kanazawa University,
> 13-1 Takara-machi,
> Kanazawa, 920-0934, Japan
>
>
> On 2010/10/27, at 10:44, Spencer Graves wrote:
>
>> Hello:
>>
>>
>>       I'm not very unixed, and I'm trying to install RMySQL under 
>> CentOS 5.5 version of Linux.  I'm having trouble parsing the 
>> installation instructions, e.g., at 
>> "http://cran.fhcrc.org/web/packages/RMySQL/INSTALL".  Any suggestions?
>>
>>
>>       Thanks,
>>       Spencer
>>
>> _______________________________________________
>> R-sig-DB mailing list -- R Special Interest Group
>> R-sig-DB using stat.math.ethz.ch
>> https://stat.ethz.ch/mailman/listinfo/r-sig-db
>>
>
>