> 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 ?
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php