There is a new version of MySQL currently in development that will be version 6. MySQL is an open source software package that allows data to be stored and queried in tables. MySQL is used my millions, and many websites use it to store data. I think the reason it is very popular is because most versions are free and works very well. In my experience the performance is comparable to commercial SQL software from Sybase, Oracle, and Microsoft.
There are many new features in version 6. Database backups have a new function to minimize table locking while running a backup or restore. This is a big improvement over the old way of dumping a database using mysqldump which caused transactions to stop while backup was running. There is a storage engine called Falcon that was designed for multi-core processors and huge memory banks. Falcon will dynamically compress data, cache data indexes, and is optimized for multi threaded cpus. Beware that Falcon is considered alpha software and will probably have bugs at first. Also there will be a new SQL statement that allows tables to be locked in a way that allows multimodes: share mode and exclusive mode. You can learn all the technical details by reading MySQL 6 online.
Related Posts
Tags: databases, hosting, microsoft, MySQL, mysql version 6, oracle, sybase, Technology
