Submitted by Webmaster on February 22, 2013
MySQL 5.6 is believed to be the best MySQL release ever. In order to find out if it is true or not I ran some benchmarks and I am going to share the results with you in this tutorial. Please note that I only tested with default settings (in both cases) and using sysbench as a benchmarking tool, so its a pretty basic test. I highly recommend that you test on your particular workload before upgrading and share your results.
Submitted by Webmaster on February 06, 2013
MySQL 5.6 is the latest production-ready release of the most popular opensource database management system on the planet ie. MySQL.
Submitted by Webmaster on June 29, 2012
I have used the technique that I am going to describe below on several occasions to restore from a SQL dump generated using mysqldump. In some cases, the restore that had taken 2 days and still could not finish successfully was completed in 5-6 hours using this simple technique. Please keep in mind that this is not a pure parallel method but I'd say it is almost parallel and have proven to be faster than regular single-threaded restore.
Submitted by Webmaster on May 23, 2012
MySQL is the most popular open source database management system. It allows you to quickly download and install and run a powerful database system on almost any platform available including Linux, Windows, and Mac OS X etc.
Submitted by Webmaster on December 12, 2011
An interesting scenario that I came across today was the fact that if you use the same alias as the column name in a formatted string (using DATE_FORMAT) and you also use same alias in ORDER BY or GROUP BY clause then MySQL uses the string output of DATE_FORMAT to sort records rather than the actual date column.
Submitted by Webmaster on October 03, 2011
After reading about the query cache mutex contention, scalability issues on multi-cores, and several people recommending disabling query cache on multi-core machines. I decided to give it a try and disable it to improve performance and since I was also seeing a lot of "freeing items" states for my queries (mysql works on query cache for part of the time query is in that state).
Slightly Advanced Python: Some Pyth January 03, 2011
Understanding Python December 29, 2010
MariaDB, the Backward Compatible Br December 26, 2010
- free download for mysql database server 5.1.5
- mysql mysql
- install mysql
- source code
- mysql initialization
- install cairo
- mysql gearman
- table_cache information_schema