List:General Discussion« Previous MessageNext Message »
From:Rogger Date:June 13 2002 3:33pm
Subject:Innodb Memory use for a Benchmark...
View as plain text  
We are developing a benchmark (only querying) between
MySQL, SQLServer2000, and Access 2000....
We are using as base, the Database propose by TPC.org (www.tpc.org)...
With the records they propose and the indexes they proposed ....

But for the testing we are using INNODB tables, with the appropiate indexes 
and foreign keys, equal to SQL SERVER 2000 ....

In some queries, (SQL Server 2000 beats MySQL) .... in other QUERIES MySQL 
doesn't finish, and ACCESS and SQL SERVER does ...

MySQL outputs a error "Tables #tmp something ??? is full " ....

The specfic questions, are :
We are testing in a DELL pentium III with 128 MB of memory ....
How much is recommended for INNODB_BUFFER_POOL_SIZE ?

The IBDATA has 900 MB, and the LOGS 80 MB each and are 3 ... of them ...
How do I know how much space are the DATA actually use ...

in SQL SERVER the same amount of DATA uses 600 MB aprox ,,,

We make IBDATA of 900 MB, in case the DATA will not fit ....

Are there other parameters we have to tune up .... (TMP space ?, KeyBuffers?, 
Query_Cache ?) ...

We think MySQL can do much better than SQL SERVER 2000 in most queries, but we 
also think that we are not configuring very well MySQL to obtain better 
performance, any hints ?


Thread
table is read only when DB copied from Win to UNIXFrancisco Reinaldo12 Jun
  • Re: table is read only when DB copied from Win to UNIXTonu Samuel12 Jun
    • Re: table is read only when DB copied from Win to UNIXFrancisco Reinaldo13 Jun
      • Re: table is read only when DB copied from Win to UNIXChris Knipe13 Jun
        • Re: table is read only when DB copied from Win to UNIXFrancisco Reinaldo13 Jun
          • Innodb Memory use for a Benchmark...Rogger13 Jun
            • Innodb Memory use for a Benchmark in MySQL...Rogger13 Jun
RE: table is read only when DB copied from Win to UNIXFrancisco Reinaldo13 Jun