tutorials
Is MySQL 5.6 slower than MySQL 5.5? No, it's faster
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.
Category:
Database Management Systems > MySQL > Tips and Tricks
Tags:
Download, configure, compile, and install MySQL 5.6
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.
Category:
Database Management Systems > MySQL > Installation
Tags:
Fast, parallel restore from SQL dumps (mysqldump) for 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.
Category:
Database Management Systems > MySQL > Tips and Tricks
Tags:
How to download and install MySQL on Mac OS X
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.
Category:
Database Management Systems > MySQL > Installation
Tags:
MySQL DATE_FORMAT function and ORDER BY
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.
Category:
Database Management Systems > MySQL > Tips and Tricks
Tags:
MySQL Query Cache not necessarily a bad thing
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).
Category:
Database Management Systems > MySQL > Tips and Tricks
Tags:
videos
Slightly Advanced Python: Some Pyth
January 03, 2011
Understanding Python
December 29, 2010
MariaDB, the Backward Compatible Br
December 26, 2010
JavaScript: The Good Parts
March 03, 2009
Search for Drop-in JavaScript Perfo
February 10, 2009
popular searches
- free download for mysql database server 5.1.5
- php
- linux
- mysql mysql
- mysql
- java
- install mysql
- gearman
- ubuntu
- tools
- source code
- bison
- mysql initialization
- install cairo
- laptop
- mysql gearman
- initial
- libevent
- table_cache information_schema
- md5sum
archives
| 2012 | - | - | - | - | may | jun |
| - | - | - | - | - | - | |
| 2011 | jan | - | mar | - | - | - |
| jul | aug | - | oct | - | dec | |
| 2010 | jan | - | mar | apr | - | - |
| - | aug | sep | oct | nov | dec | |
| 2009 | jan | feb | mar | apr | may | jun |
| jul | aug | sep | oct | nov | dec | |
| 2008 | jan | - | - | - | - | - |
| - | - | - | - | nov | dec | |
| 2007 | - | - | - | - | - | - |
| - | - | sep | - | - | dec |
subscribe
tags cloud
