ubh3 + MySQL 4.1.x, default storage engine "gothca"

So, it seems that when you install 4.1.x on Windows and run the
configuration wizard, you automatically get InnoDB as your 
default storage engine for all your tables.

    http://dev.mysql.com/doc/mysql/en/Storage_engines.html

"When MySQL is installed on Windows using the MySQL Configuration
Wizard, the InnoDB storage engine will be the default instead of
MyISAM."


Needless to say, this causes horrific database performance.  I
noticed I was getting about 6 inserts per second in ubhdb.

To rememdy this problem, you can either modify your my.ini to 
specify MyISAM as the default
storage engine:

    default-storage-engine=myisam

...or use the MySQL Administrator tool:
    Startup Variables ->
        General Parameters ->
            General ->
                Default Storage (set to MyIsam)

Remember to restart the server.


With MyISAM, ubhdb is doing about 192 inserts per second.  Ahhhh,
much better.

-Gerard







 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/ubh/

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/