upgrading from solidDB for MySQL Beta 4 to Beta 5

If you have been using solidDB for MySQL Beta 4 and decided to try out solidDB for MySQL Beta 5, you might have seen the following warning message when you try to start up mysqld:

SOLID Database Warning 1022: The database you are using has been
originally created with a different database block size setting
than your current setting.
To suppress this warning edit the solid.ini file to contain
the following parameter setting:
[IndexFile]BlockSize=8192

The reason for this warning message is that the default block size has changed. Beta 4 was using a default block size of 8K and Beta 5 uses a default block size of 16K.

By default (if you do nothing), you will continue to get the warning message but mysqld will start normally and the solidDB Storage Engine will work just fine. In fact, it will continue to use the original block size (8K) and will ignore the new, default block size (16K).

Unfortunately, the advice in the warning message about suppressing the warning is not quite correct. (This will be fixed in a future release.) If you do want the warning message to go away, do the following:

• If you started mysqld with the my-soliddb.cnf file (located under the support-files/ directory), then modify that file and change the soliddb_db_block_size under the [mysqld] section. Change the value from 16K back to 8K.
• If you start mysqld by hand (with no defaults-file), then start mysqld with the following additional option:

./bin/mysqld --soliddb-db-block-size=16K &

By the way, you will only see this warning message if you are using the same data directory as you were for Beta 4. If you are using a new data directory (which is the default case if you don’t specify a data directory with the –datadir option) then a new Solid database file will be created with the new default size of 16K and the warning message will not occur.