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
