Description:
While creating the employee db from our documentation databases samples I noticed that the Maria Engine took more time than InnoDB Engine.
The test was run on Windows Vista 64-bit 4GB RAM:
mysql 6.0 > show variables like "%version%";
+-------------------------+--------------------------------------+
| Variable_name | Value |
+-------------------------+--------------------------------------+
| protocol_version | 10 |
| version | 6.0.11-alpha-Win X64 revno: 2734-log |
| version_comment | Source distribution |
| version_compile_machine | unknown |
| version_compile_os | Win64 |
+-------------------------+--------------------------------------+
5 rows in set (0.00 sec)
mysql 6.0 >
See attached file for the output of the salaries table.
The server was started with the defaults settings.
How to repeat:
Download the employee db from our Documentation site:
http://dev.mysql.com/doc/
Follow the instructions in the README file.
Create the database with InnoDB default engine.
See the time to create the table salaries.
Edit the employees.sql file to make Maria the default engine.
Create the database again and compare the times.
Suggested fix:
--
