List:General Discussion« Previous MessageNext Message »
From:Rogger Date:June 13 2002 4:24pm
Subject:Innodb Memory use for a Benchmark in MySQL...
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